| Problem starting the Oracle Sid service [message #362955] |
Thu, 04 December 2008 11:56  |
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 #364439 is a reply to message #363028] |
Mon, 08 December 2008 08:56  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
