Home » Other » General » what is tns error?
what is tns error? [message #200202] Sun, 29 October 2006 03:05 Go to next message
akash89_04
Messages: 1
Registered: October 2006
Junior Member
when i enter the username/password- system manager in oracle9i
SQL*plus it shows th following error

ERROR:
ORA-12560: TNS:protocol adapter error

what should i do
plz help me
Re: what is tns error? [message #200205 is a reply to message #200202] Sun, 29 October 2006 05:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
is your database open.
Is this the only database/instance on that machine?
else goto command prompt use SET ORACLE_SID=yoursid and start.
edit your sqlnet.ora and comment all entries and try again.
Re: what is tns error? [message #200206 is a reply to message #200202] Sun, 29 October 2006 05:13 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
ORA-12560 TNS:protocol adapter error

Cause: A generic protocol adapter error occurred.

Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors.For further details, turn on tracing and re-execute the operation. Turn off tracing when the operation is complete.

If Mahesh's advice doesn't help, follow this link and see what other people did about it.
Re: what is tns error? [message #200208 is a reply to message #200202] Sun, 29 October 2006 05:18 Go to previous messageGo to next message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
Hello Mahesh

Same error i m getting too.Though from same password & user login i run sql*plus but some times it show error some times
it work smooth. What is the reason behind it?

ERROR:
ORA-12560: TNS:protocol adapter error




Waiting for your response

With regards
Ashish

[Updated on: Sun, 29 October 2006 05:19]

Report message to a moderator

Re: what is tns error? [message #200209 is a reply to message #200208] Sun, 29 October 2006 05:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please see the above replies from myself and littlefoot.
and search this forum.
This quesiton is been asked and answered many times.
Re: what is tns error? [message #200215 is a reply to message #200202] Sun, 29 October 2006 06:02 Go to previous message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
Thanks for the link.
It helps me lot.

With regards
Ashish

[Updated on: Sun, 29 October 2006 06:02]

Report message to a moderator

Previous Topic: oracle database
Next Topic: ERWIN VERSIONS
Goto Forum:
  


Current Time: Fri Mar 29 04:57:05 CDT 2024