OracleServiceSID fails to start

[Former Member]

We have installed a solman 7.0 system but the OracleServiceSID does not start. We saw that we get the ORA-12560 error.

1. We checked note 441518 and failure of OracleServiceSID is mentioned as one of the reasons.

2. We tried recreating the service. But while recreating, it gave an error. On rebooting though we could see the OracleServiceSID again in the service list but it still does not start.

Can someone help?

OS is Win 2003 x64

DB is Ora 10.2.0.4 Patch 8

Thanks

[Former Member]

Hi Cons,

Can you please paste the error .

Can you please confim your listner service is running.

Thanks and regards,

Atil

[Former Member]

Hi Atil,

Error is:

Error 1053: The service did not respond to the start or control request in a timely fashion

The listener service was running until sometime back. But after manually shutting down, it refuses to start too (even after rebooting)

Error is:

Error 1067: The process terminated unexpectedly.

Thanks for your response

[former_member204746]

check in the windows Event Log, in the Application section for more info.

I betcha you moved an Oracle directory by mistake. This happens when you try to double-click on a directory but you move the move between the two clicks, it moves the directory in a sub-folder.

[Former Member]

Hai,

This might be due to the large listener.log file, due to this the service can get timeout.Remove the listener.log so Oracle will automatically create a new empty one.

Regards,

Yoganand.V

[Former Member]

>

> This might be due to the large listener.log file

Dear Eric and Yoganand,

My apologies for the delayed response since I do not have access to the server after office hours (and cant stay in the office for extended hours!)

Yoganand's hint was somewhat useful. We have resolved the Error 1067 listener problem - we had set the env vars as per note 441518 and listeners of other products installed on the same host had taken control of the solman listener.log file. Once we removed the env vars, the solman listener started successfully.

Now for Error 1053 can you tell me how can I stop the DB to recreate the service since it gives the ORA-12560 error (due to to oracleservicesid) when we try sqlplus "/as sysdba" and sqlplus "/nolog"

Thanks and Regards

[former_member204746]

to recreate service:

oradim -new -sid [SID] -startmode AUTO -pfile d:\oracle\[SID]\102\database\init[SID].ora