Home » RDBMS Server » Server Administration » Problem starting the Oracle Sid service (Oracle 9.2.0.8.0, Windows 2003)
Problem starting the Oracle Sid service [message #362955] Thu, 04 December 2008 11:56 Go to next message
shekharnegi12
Messages: 52
Registered: October 2008
Member
On Monday I was trying to apply a patch #7394394 and it failed. So I had to rollback the patch changes. Before I could apply the patch I had to stop the Oracle service (Obviously). Now after rollback I tried to open the SID service and it wont open. I deleted the old sid service "oradim -delete -sid servicename"
and it got deleted and then I created a new service with the same name using "oradim -new -sid "servicename" -intpwd password -startmode AUTO -pfile pfilepath\pfile\init.ora", the service gets created but it threw "DIM-00019: Create Service Error." error message. And now if try to manually start it the service it wont start.

The above was using command prompt, when I try to open it using the windows services i.e. services.msc, I get the following error message
"Could not start the OracleService service on the Local Computer.
Error 1053: The service did not respond to the start or control request in a timely fashion"


I read through many forums and everywhere I saw that people said that its privilege issue. I'm the domain admin and the service is using the local admin account. I also tried using my username (I'm Domain Admin and in ORA_DBA group) but it wont work with that either. Please help!
Re: Problem starting the Oracle Sid service [message #362983 is a reply to message #362955] Thu, 04 December 2008 13:35 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


1. Try to remove old instance

2. Re-Start your OS

3. Again Try to create.

Babu

[Updated on: Thu, 04 December 2008 16:27]

Report message to a moderator

Re: Problem starting the Oracle Sid service [message #363028 is a reply to message #362983] Thu, 04 December 2008 16:42 Go to previous messageGo to next message
shekharnegi12
Messages: 52
Registered: October 2008
Member
Thank you for your response! I've done that already. After deleting the service I rebooted the machine and then created the new service (with same and different names) and still it didnt work.
Re: Problem starting the Oracle Sid service [message #364439 is a reply to message #363028] Mon, 08 December 2008 08:56 Go to previous message
shekharnegi12
Messages: 52
Registered: October 2008
Member
Hello,

I checked the listener.log file and it give me the following error:

TNSLSNR for 32-bit Windows: Version 9.2.0.8.0 - Production on 05-DEC-2008 15:18:20

Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.

System parameter file is Orahome\network\admin\listener.ora
Log messages written to Orahome\network\log\listener.log
Trace information written to Orahome\network\trace\listener.trc
Trace level is currently 0

Started with pid=****
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fl-vs5.pecs.com)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
08-DEC-2008 09:01:44 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME="servicename")(CID=(PROGRAM=C:\Program?Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=FL-VS5)(USER= "Username"))) * (ADDRESS=(PROTOCOL=tcp)(HOST=***.**.**.***)(PORT=1620)) * establish * "servicename" * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 2: No such file or directory
08-DEC-2008 09:01:54 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME="servicename")(CID=(PROGRAM=C:\Program?Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=FL-VS5)(USER= "Username"))) * (ADDRESS=(PROTOCOL=tcp)(HOST=***.**.**.***)(PORT=1622)) * establish * "servicename" * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 2: No such file or directory


I do not understand this error message. Can someone help?

Thanks,
SN
Previous Topic: very confusing situation
Next Topic: creating database with 8K block size in oracle 9i - ORA-00058
Goto Forum:
  


Current Time: Fri Dec 02 20:39:54 CST 2016

Total time taken to generate the page: 0.10073 seconds