Home » RDBMS Server » Networking and Gateways » TNS ERROR
TNS ERROR [message #352987] Fri, 10 October 2008 07:12 Go to next message
Messages: 240
Registered: June 2006
Location: Chennai
Senior Member
I have changed my server ip address after that i cant able to connect to oracle for this i have changed my tnsnames.ora file to the new ip address and then also i got the below error while i started my listner as (lsnrctl start).

TNS-12537 TNS conncection closed
TNS-12560 TNS protocol adapter error
TNS-00507 connection closed

Please its very urgent anyone help me.

Re: TNS ERROR [message #352997 is a reply to message #352987] Fri, 10 October 2008 08:10 Go to previous messageGo to next message
Messages: 4765
Registered: February 2005
Location: East Coast USA
Senior Member
Do you think that maybe posting your tnsnames.ora and listener.ora files would be of any help to anyone? Did you bounce the listener?
Re: TNS ERROR [message #353563 is a reply to message #352987] Tue, 14 October 2008 03:25 Go to previous message
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
Did you try restarting and try again? Set the oracle sid correctly and try connecting, and are you trying to connect from the host machine or client machine?
Previous Topic: TNS-03505: Failed to resolve name
Next Topic: TNS - Unable to connect Destination
Goto Forum:

Current Time: Thu Aug 17 06:52:13 CDT 2017

Total time taken to generate the page: 0.30498 seconds