OracleServiceSID does not start after installation

[Former Member]

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

this is the error we get when we try to manually start the service.

We have just installed PI7.1 using multiple oracle homes on a host where Solman 7.0 was installed.

After the installation, the solman OracleServiceSID refuses to start.

1. The listeners and sap services are all working.

2. The OracleServiceSID for PI is working fine

3. We have checked the environment variables...all are set correctly

4. tnsping <SID> has status "OK" for both products

5. We have not tried recreating the service as we are not sure of the related settings/configurations/procedures

I could not find any SAP note on this! Can someone help out with a solution?

Thanks

[Former Member]

I got this error when i tried to install one more instance in same server. I as trying to install one more database home. Unfortunately i couldn't cpmplete that. I restarted my system, i m getting this error when i manually strated the oracle service. I removed all the oracle software with universal uninstaller. then installed it again with the same file system as before. Applied patch too. Now my oracle is working fine.

Edited by: Aby Alex Kariyil on Jun 15, 2010 6:40 PM

[Former Member]

Couldn't solve this till the end...have uninstalled solman. Will try again in some time

[Former Member]

Hi,

There is some mismatch of service in windows registry. It is not recommended to change the values in registry.

You can delete the existing OracleServiceSID using following command

oradim -delete -sid <SID>

Then recreate the service by

oradim -new -sid SID -srvc OracleServiceSID -intpwd PASSWORD -pfile FILENAME

This will recreate the new entries in registry.

Regards,

Sachin Rane

[Former Member]

I tried re-creating the service. It deleted the service successfully (i think), but while creating it says:

OPW-00005: File with same name exists - please delete or rename
DIM-00019: create service error
O/S-Error: (OS 1073) The specified service already exists.

The command I gave was:

oradim -new -sid SM1 -srvc OracleServiceSM1 -intpwd qwerty12# -pfile C:\oracle\SM1\102\database\SPFILESM1.ora

I have renamed the exisitng spfile and also deleted the relevant registry entry but still get the same error. The service Oracle Service SM1 cannot be seen in the list of services though.

I tried to login to the DB with

sqlplus "/as sysdba"

and

sqlplus "/nolog"

but it gives me the

ORA-12560: TNS:protocol adapter error

. I checked note 441518 and have the settings intact.

What more can I do now?

Thanks

[Former Member]

I can see the OracleServiceSM1 after rebooting the machine! But it does not work though I try to start it manually.

The event logs have the following errors:

Timeout (30000 milliseconds) waiting for the OracleServiceSM1 service to connect.
The OracleServiceSM1 service failed to start due to the following error: 
The service did not respond to the start or control request in a timely fashion. 

But the timeout just happend in a second...why does it say that the timeout is 30seconds!

Can someone help?

Thanks

[Former Member]

Hai,

Check the listener.log file had grown very large or not, this can cause timeout as Oracle has to scan to the bottom of it to write.

Remove the listener.log so Oracle will automatically create a new empty one.

Just a try...:)

Regards,

Yoganand.V

[Former Member]

Hi Yoganand,

I renamed the listener.log file. It created a new log file just as you had mentioned but the problem persists.

Anything else to try?

Thanks

[Former Member]

>

> I tried re-creating the service. It deleted the service successfully (i think), but while creating it says:
> 
> OPW-00005: File with same name exists - please delete or rename
> DIM-00019: create service error
> O/S-Error: (OS 1073) The specified service already exists.

I have reolved the OPW-00005 error. It seems that we have to rename/delete the pwdSID.ora file. I got this idea from this thread - http://www.dbasupport.com/forums/archive/index.php/t-10737.html

Now the service has been created successfully but it still does not start:

Instance created.

DIM-00019: create service error

O/S-Error: (OS 1053) The service did not respond to the start or control request in a timely fashion.

Can anyone help?

Thanks

[Former Member]

Hai,

Check this Metalink note: 465289.1

Regards,

Yoganand.V

[Former Member]

Hi Yoganand,

Thanks for your response. I checked the note and saw that my user was not part of the ORA_SM1_DBA group. I added the privilege and recreated the service but still get the same error.

What else can I do?

Thanks

[Former Member]

HI Sachin,

I faced similar issue during my system copy procedure in SRM 5.0. I just deleted the oracle instance with command

oradim -delete -sid <SID>. I retried the SAP installation and it went fine without any more issues. There is no need to recreate the oracle instance. As I believe SAP installation takes care of creating the oracle instance.

Hope this helps.

Thanks & Regards,

Karthik,

Edited by: Karthik Iyer S on Dec 29, 2011 2:47 PM

[Former Member]

Hai,

Check the user which is used to start the service, it should be the admin user.

Workaround:

Set the registry key ORACLE_<SID>_Autostart to false.

The key can be found at:

HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/<Home of your 816 installation>

Refer Oracle Metalink note 132086.1

You can get the user id and password for metalink in SAP Note 758563.

Regards,

Yoganand.V

[Former Member]

Hi Yoganand,

Thanks for the info! That was quite helpful. But unfortunately my Oracle version is 10.2.0.4 and the said key is already set to False.

Can you suggest anything else?

Thanks