Connecting to oracle 9iR2 running behind Airport router
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?