Home » RDBMS Server » Server Administration » TNS:protocol adapter error
TNS:protocol adapter error [message #216424] Sat, 27 January 2007 10:21 Go to next message
muralikumarg
Messages: 33
Registered: August 2005
Location: Chennai
Member
Hi,

I have installed in oracle 10g in my machine. I did following step

1. set oracle_sid=orcl
2. sqlplus/nolog
3. startup

I got TNS:protocol adapter eeror. This happens even when listener is up. Could anyone please explain what is the cause and give solution?

Regards
Murali
Re: TNS:protocol adapter error [message #216427 is a reply to message #216424] Sat, 27 January 2007 10:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you are on Windows, then make sure the Window's Oracle service (ie. OracleService<oracle_sid>) is started.
Re: TNS:protocol adapter error [message #216446 is a reply to message #216427] Sat, 27 January 2007 23:26 Go to previous messageGo to next message
muralikumarg
Messages: 33
Registered: August 2005
Location: Chennai
Member
Thanks ebrian, I was able to connect oracle after starting the Oracleservice<sid> service in windows.

After starting this service, the instance became up. Can anyone tell me when can we use startup command to start the oracle instance.

Regards
Murali
Re: TNS:protocol adapter error [message #216461 is a reply to message #216446] Sun, 28 January 2007 08:50 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You can use the STARTUP/SHUTDOWN command once the OracleService<sid> is started. Issuing SHUTDOWN for the database will not actually stop the Windows service, therefore you can issue STARTUP to restart the database without having to restart the Windows service.

HTH
Re: TNS:protocol adapter error [message #216508 is a reply to message #216461] Sun, 28 January 2007 23:49 Go to previous messageGo to next message
muralikumarg
Messages: 33
Registered: August 2005
Location: Chennai
Member
Hi Ebrian,

Thank you. I started oracleservice<sid> service in windows for a database. This service mounted the database and the instance was up. So I understand that there is no need to give startup when we start this service.

Is there anyway to start only the service and prevent the database instance getting mounted.

Regards
Murali
Re: TNS:protocol adapter error [message #216511 is a reply to message #216508] Mon, 29 January 2007 00:26 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

.

[Updated on: Mon, 29 January 2007 06:12]

Report message to a moderator

Re: TNS:protocol adapter error [message #216539 is a reply to message #216511] Mon, 29 January 2007 05:34 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
muralikumarg wrote on Mon, 29 January 2007 00:49

Is there anyway to start only the service and prevent the database instance getting mounted.
user52 wrote on Mon, 29 January 2007 01:26
Is there anyway to start only the service and prevent the database instance getting mounted.
NO.

you have to manully shutdown your database.
and startup up nomount mode.



Actually, you can set the Windows service to NOT autostart the database when you start the Windows service itself. If you change the ORA_<sid>_AUTOSTART paramter in the registry to FALSE, then the database will not be started when you start the Windows service for that database.
Re: TNS:protocol adapter error [message #216548 is a reply to message #216539] Mon, 29 January 2007 06:09 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Thank you.

regards
Taj
Re: TNS:protocol adapter error [message #216570 is a reply to message #216424] Mon, 29 January 2007 07:56 Go to previous message
muralikumarg
Messages: 33
Registered: August 2005
Location: Chennai
Member
Thank you Ebrian, I was able to start the service alone.

Thanks a lot..

Regards
Murali
Previous Topic: ora-12638-credential-retrieval-failed
Next Topic: table partitioning
Goto Forum:
  


Current Time: Sat Dec 07 03:26:40 CST 2024