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 188.8.131.52.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
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:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usc1-as04)(PORT=1521)))
PLSExtProc has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
gen0301p has 1 service handler(s)
DEDICATED SERVER established:2 refused:0
gen0301p has 2 service handler(s)
DEDICATED SERVER established:1 refused:0
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
The command completed successfully