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
oraclelearner
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.

Report message to a moderator

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
panyam
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.

Report message to a moderator

Previous Topic: error 1067 [merged]
Next Topic: Data Transfer from SQL Server to Oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 15:55:34 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.