Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

service-specific error code 997 when starting up Oracle 9i service

848970Apr 12 2011 — edited Apr 21 2011
Hi,

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)
)
)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2011
Added on Apr 12 2011
4 comments
579 views