service-specific error code 997 when starting up Oracle 9i service
848970Apr 12 2011 — edited Apr 21 2011Hi,
I have both Oracle 9i and 10g installed in a server. I've added 9i SID in 10g listner.ora. When I try to startup the 9i Oracle service in windows, I get "Windows could not start the 'service name' on Local Computer......If this is a non microsoft service, contact the service vendor, and refer to service-specific error code 997".
Server is Windows 2003 R2 Standard Edition SP1
Does anyone has a solution for this error?
Thanks,
listener.ora in 10g
LISTENER10G =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sgpdb1)(PORT = 1522))
)
)
SID_LIST_LISTENER10G =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\Oracle\Ora10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = RACE)
(ORACLE_HOME = F:\Oracle\Ora10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = IWK1010)
(ORACLE_HOME = F:\Oracle\Ora9201)
(PROGRAM = extproc)
)
)
sqlnet.ora in 10g
NAMES.DEFAULT_DOMAIN = world
SQLNET.AUTHENTICATION_SERVICES= NONE
NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)
tnsnames.ora in 10g
RACE.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = sgpdb1)(Port = 1522))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACE)
)
)
IWK1010.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SGPDB1)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = IWK1010)
)
)