ORA-12560: TNS:protocol adapter error

[daljitsb]

Environment: Windows 2000, Oracle 8.1.6

We had this windows 2000 server/oracle database working fine. Now I found my oracleServiceDbname stoped and listener service also stopped and are not starting - Message I am getting is 'Access is denied'. I/IT have full access and both get the same message.

I tried to login from svrmgrl getting getting this protocal adapter error.

C:\Documents and Settings\singhd>set ORACLE_SID=gen0301p
C:\Documents and Settings\singhd>svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

ORA-12560: TNSrotocol adapter error
SVRMGR> connect internal
Password:
ORA-12560: TNSrotocol adapter error

My sqnet.ora looks like:
----------

#NAMES.DEFAULT_DOMAIN = araccel.com

SQLNET.AUTHENTICATION_SERVICES= (None)

USE_DEDICATED_SERVER = ON

NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP, ONAMES, HOSTNAME, NIS, DCE)

Listener.ora:
-----------

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dbname.domain_name)
(ORACLE_HOME = F:\oracle\ora81)
(SID_NAME = dbname)
)
)


Please help.

-D

[jmodic]

You will allways get this error (12560) if your database service is not running. You must first start the service before you are able to connect to that instance (even to an idle one) with svrmgrl.

[daljitsb]

Originally posted by jmodic
You will allways get this error (12560) if your database service is not running. You must first start the service before you are able to connect to that instance (even to an idle one) with svrmgrl.

Oracle service and TNSlistner service both are starting now but still get the same error from within svrmgrl
ORA-12560: TNSrotocol adapter error

I get this error when trying to connect using sqlplus (server or client)
ORA-12537: TNS:connection closed

Here is the staus of listener:
------------------------------

LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usc1-as04)(PORT=1521)))
Services Summary...
PLSExtProc has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
gen0301p has 1 service handler(s)
DEDICATED SERVER established:2 refused:0
LOCAL SERVER
gen0301p has 2 service handler(s)
DEDICATED SERVER established:1 refused:0
LOCAL SERVER
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
D000
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=usc1-as04.araccel.com)(PORT=1093
))(PRESENTATION=oracle.aurora.server.SGiopServer)(SESSION=RAW))
Presentation: oracle.aurora.server.SGiopServer
The command completed successfully

[k.chithra]

Check the permission of the user who is passing set command.
either spelling should be wrong ,or it will be the permission problem

Login as the user who has the ORA_DBA privilege and set the ORACLE_SID

[anandkl]

On WINDOWS,
Try this
net stop oracleservice
net start oracleservice

Then check lsnrctl status, listerener should be UP

Then check svrmgrl

it should connect

regards
anandkl

[daljitsb]

Originally posted by k.chithra
Check the permission of the user who is passing set command.
either spelling should be wrong ,or it will be the permission problem

Login as the user who has the ORA_DBA privilege and set the ORACLE_SID

I have the ORA_DBA privilege and spelling seems correct. Which spelling specifically you are talking. Any more suggestion. Please help.

[daljitsb]

Originally posted by anandkl
On WINDOWS,
Try this
net stop oracleservice
net start oracleservice

Then check lsnrctl status, listerener should be UP

Then check svrmgrl

it should connect

regards
anandkl

---------------

Tried all that. Didn't help.
Any more suggestion. Please help.

-D

[rad_jen]

Comment out SQLNET.AUTHENTICATION_SERVICES= (None) in the sqlnet.ora and give a try.

[daljitsb]

Thanks guys for all your help/suggestions.

It came out to be a DNS issue - some how stopped resolving the server name. Changed it to localhost and it picked up.

Thanks again.

-Daljit