Connecting to oracle 9iR2 running behind Airport router
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Connecting to oracle 9iR2 running behind Airport router

  1. #1
    Join Date
    Aug 2003
    Posts
    1

    Question Connecting to oracle 9iR2 running behind Airport router

    Hi all.
    I have setup my imac & pc to connect to internet via airport router, which gets an ip address from internet provider, and assigns different ip addresses to imac and pc (10.0.1.2 and 10.0.1.3).
    Now, I installed oracle 9iR2 on my PC, and listener is running on port 1521 (default port for oracle). I have setup Airport to do Port Forwarding to this ip/port (10.0.1.3:1521) with a public port 1000.
    So I'm trying to connect to the db externally using Oracle Client using the Airport router ip address and port 1000, but I can't do it. I successfully manage to to tnsping and setup a service name, but can't connect using sqlplus or login to db.
    Problem is solved if I connect pc directly to the internet without Airport.

    Anybody had similar problems or any ideas?
    Much Appreciated.
    chang

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    This question is a bit out of place, but anyway ... have you considered placing your PC in the DMZ? I'm sure your router would have an option for that, and it's the simplest thing to do.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Although the connection hand-shake starts on port 1521, other ports are dynamically assigned unless specifically inhibited (redirection).

    Suggest you search Metalink for "firewall"
    (e.g. Doc ID: Note:125021.1 Subject: Oracle Connections and Firewalls).

    USE_SHARED_SOCKET=TRUE in the Windows environment worked OK for me . . . .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width