Home » RDBMS Server » Networking and Gateways » unable to connect TNS name problem.
unable to connect TNS name problem. [message #376855] Thu, 18 December 2008 22:37 Go to next message
Messages: 1
Registered: December 2008
Junior Member
Hi all,

I have an issue regarding the following
I have build a oracleserver(dev1) in one system
next I have build another oracle server(Dev2) on other machine
I have to build a server which host two applications in which one application points to dev1 and other points to dev2. In this server i have installed oracle with orcl name.
So i have made modifications in the TNSnames.ora file with ip address of dev1 and dev2.
When i try to connect dev1 in my server which has applications i get an error msg unable to connect but when i connect dev2 i am able to connect.can't troubleshoot it.

Thanks in advance.
Re: unable to connect TNS name problem. [message #376863 is a reply to message #376855] Thu, 18 December 2008 23:06 Go to previous message
Messages: 146
Registered: May 2008
Senior Member

Try to do tnsping to the dev2 from the server ( where ORCL DB is installed).

Make sure that TNS Listener of Dev2 is started.
Previous Topic: error 1067 [merged]
Next Topic: Data Transfer from SQL Server to Oracle
Goto Forum:

Current Time: Fri Dec 09 04:19:29 CST 2022