asked on

Need to access an oracle database from wan

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 9.2.0.1 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?

Pradeepgv03

HI,
There are issues with NAT and SQL Connections. Please see metalink note 90707.1 Connecting to Database Through a Network Address Translator for further details.

Pradeep George
Oracle Certified Master.

ASKER CERTIFIED SOLUTION

Pradeepgv03

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

plakis

ASKER

Is it correct that this will work if I put a Oracle Connection Manager but not with out it?

plakis

ASKER

Made sure port 1521 was open on the external exchange server and changed the external port to use 1521 also.

TEST.WORLD =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=200.1.255.5)(PORT=1610)) # external IP address
(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.54.127)(PORT=1521))) # internal IP address
(CONNECT_DATA=(SID = TEST))
(SOURCE_ROUTE = yes))

Thanks