| TNS ERROR [message #352987] |
Fri, 10 October 2008 07:12  |
ORAGENASHOK
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  |
joy_division
Messages: 4963
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 |
amul
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
