This content has been marked as final. Show 9 replies
I have the same error and I need to restart the server to start up the instance.
Thanks in advance.
Is the listener started? Have you set your environment variables correctly?
Yes, the listener is started.
What enviroment variables I need to check?
I'm working on Windows 2000 Server.
On w2k there are 2 system environment variables you must set manually.
ORACLE_HOME=<path oracle home> and
These settings are automatically set in the registry but not in the system environment. After that open cmd.exe en type: set
Then you see the 2 env.settings. open svrmgrl and there is(mostly) no error again.
lsnrctl> lsnrctl start
This will solve the problem.
I have the same problem, however when I try to run the commands u have asked to run I get errors.
When I try
'svrmgrl' is not recognized as an internal or external command.
operable program or batch file.
and when I start lsnrctl
LSNRCTL> lsnrctl start
NL-00853: undefined command "lsnrctl". Try "help"
I am using XP , the database is on other drive and the Developer suite is on other drive however, Listener is working fine. This error "ORA-12560: TNS:protocol adapter error" comes only when I try to log into my database from isqlplus. I am using 9i. Any Ideas on what should be done.
For your operating system, please perform and post the equivalent of (command line)
But the solution was something really silly.
I am suppose to put
as well as Connection Identifier:... which I missed out.
I appreciate it.
Ensure that the Oracle Service and Listener is started. Then set ORACLE_HOME and ORACLE_SID before you try to connect to SQL*Plus