[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Need to access an oracle database from wan

Posted on 2006-05-12
4
Medium Priority
?
303 Views
Last Modified: 2013-12-11
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?



0
Comment
Question by:plakis
  • 2
  • 2
4 Comments
 
LVL 6

Expert Comment

by:Pradeepgv03
ID: 16673424
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.
0
 
LVL 6

Accepted Solution

by:
Pradeepgv03 earned 1000 total points
ID: 16673453
Hi ,
Please see a a sample tnsnames config.

For more details see the note mentioned in the  above update

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))
0
 

Author Comment

by:plakis
ID: 16679710
Is it correct that this will work if I put a Oracle Connection Manager but not with out it?
 
0
 

Author Comment

by:plakis
ID: 16694229
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
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question