Home » Infrastructure » Windows » Unable to start the Oracle service in Windows
Unable to start the Oracle service in Windows [message #251657] Sun, 15 July 2007 23:39 Go to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
Hi All,

There was an issue in one of the Oracle databases. When checked for the service it did not startup and threw an error. While going through the event log the following message in BOLD was displayed. It seems a DLL required for the startup is missing. This might be a problem for the other databases also if their service goes down. Please help me in getting rid of this issue.

The description for Event ID ( 0 ) in Source ( OracleServiceSps ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: OracleServiceSps: 0, OPS: SOFTWARE\ORACLE\OSD9i\STARTDLL not found, loading START.DLL from path
Re: Unable to start the Oracle service in Windows [message #251669 is a reply to message #251657] Mon, 16 July 2007 00:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Remove (or rename) this entry from registry as well as CMDLL and IODLL if you have them.

Regards
Michel
Re: Unable to start the Oracle service in Windows [message #251725 is a reply to message #251657] Mon, 16 July 2007 04:48 Go to previous messageGo to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
There was no entry in the registry. Also I have renamed the specified DLLs. It did not help still. Sad
Re: Unable to start the Oracle service in Windows [message #251758 is a reply to message #251725] Mon, 16 July 2007 10:13 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
delete the servie and recreate it

CMD>oradim -delete -sid mydb

and recreate

CMD>oradim -new -sid mydb -srvc oracleservicemydb -startmode auto -intpwd manager -pfile pathofpfile
Re: Unable to start the Oracle service in Windows [message #251778 is a reply to message #251758] Mon, 16 July 2007 11:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the relation with the DLL or registry entry?

Regards
Michel
Re: Unable to start the Oracle service in Windows [message #251783 is a reply to message #251778] Mon, 16 July 2007 11:34 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
I guess it would delete and recreate the dll for service.
Previous Topic: problem with tnslsnr.exe
Next Topic: Plss Help me, ORA-12560 TNS :Protocol Adapter Error
Goto Forum:
  


Current Time: Thu Apr 18 10:56:02 CDT 2024