OraFAQ Forum: Server Administration » TNS:protocol adapter error

Home » RDBMS Server » Server Administration » TNS:protocol adapter error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS:protocol adapter error [message #216424]

Sat, 27 January 2007 10:21

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

Report message to a moderator

Re: TNS:protocol adapter error [message #216427 is a reply to message #216424]

Sat, 27 January 2007 10:39

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.

Report message to a moderator

Re: TNS:protocol adapter error [message #216446 is a reply to message #216427]

Sat, 27 January 2007 23:26

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

Report message to a moderator

Re: TNS:protocol adapter error [message #216461 is a reply to message #216446]

Sun, 28 January 2007 08:50

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

Report message to a moderator

Re: TNS:protocol adapter error [message #216508 is a reply to message #216461]

Sun, 28 January 2007 23:49

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

Report message to a moderator

Re: TNS:protocol adapter error [message #216511 is a reply to message #216508]

Mon, 29 January 2007 00:26

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

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.

Report message to a moderator