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