| ORA-12560 TNS: protocol adaptor error [message #3805] |
Sun, 20 October 2002 13:06  |
avinash
Messages: 22
Registered: February 2001
|
Junior Member |
|
|
Hi,
Please help me to fix these problems:
I get a ora-12560 from sqlplus
and how to check that correct Protocol Adapter are
successfully linked? How to check whether database has been started or not?
Thanks
Avi
|
|
|
|
|
|
|
|
| Re: ORA-12560 TNS: protocol adaptor error [message #3845 is a reply to message #3821] |
Tue, 22 October 2002 08:13  |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
Hi !
Did svrmgr work ???
Verify ORACLE_SID and ORACLE_HOME
Are U connected on the console or did U use a tools like 'Remote Control' or 'Terminal Server' ?
Because there is conflict with sqlplus and those tools.
else
Go to the control panel and Verify that all OracleServices are STARTED
Did U install Oracle ( or someone else ??? ).
Did sqlplus work on this server on another database ?
Reply me if it still doesn't work..
As U can See there are many possibilies ...
|
|
|
|
| Re: ORA-12560 TNS: protocol adaptor error [message #10087 is a reply to message #3845] |
Fri, 02 January 2004 10:58 |
Ashe
Messages: 1
Registered: January 2004
|
Junior Member |
|
|
I have the exact same problem and to elaborate:
a) i installed Oracle myself
b) i'm running version8.1.7
c) I verified to see if TNS listener started.
d) SQLplus worked on this computer before
e) I'm connected to SQLplus via the console.
I'm not sure what to do. I verified the SID and ORA_HOME variables. However I cannot connect as either scott/tiger or system/manager. I haven't tried to see if svrmgr works. What am I supposed to do now? Any help will be appreciated.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
