-
ORA-12560: TNS:protocol adapter error
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
-
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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
-
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
K.Chithra
Oracle DBA
-
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
anandkl
-
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.
-
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
-
Comment out SQLNET.AUTHENTICATION_SERVICES= (None) in the sqlnet.ora and give a try.
OCP 7.3,8.0,8i,9i
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|