Need to access an oracle database from wan
Posted on 2006-05-12
I have to access an Oracle database that is behind my firewall. I opened all the ports from the external IP address (which is ours) to another IP (that is also ours from the same group) that is a 1 to 1 Nat to an internal ip address. After installing oracle client 220.127.116.11 on the external server, I am able to tnsping the database. but when I try to use SQLplus I get the following error: ORA-12560 "TNS:protocol adapter error" .
I believe it is an authentication problem because when I connect with a vpn client it connects with SQLplus. What am I missing?