Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle service orcl not found in windows services

650105Jan 22 2010 — edited Jan 25 2010
hello
i'm facing a very serious problem. MY server ORacleserviceorcl not found in services. all services currently up and running. but ORCL service not show there and my database is down how i start my database. i found this problem first time. plz help me how to Start oracle. my ORacle version 10g on windows server 2003

Comments

G777
Maybe ORADIM has some option to check/repair it.
Look also at the System/application event logs for any problems related to that service.
650105
How i check oradim? i did not find ORACLE.exe in bin folder. i think antivirus delete this exe. how can i create it. plz help how can i star service orcl.
650105
plz help me how to Run oracle in this situation any idea plz i dont have backup. any idea any thing to run oracle
650105
plz help i'm waiting for ur response anyone can help me. i'm fuly disable. plz help how i run oracle???
Niall Litchfield
Oracle Studnet wrote:
How i check oradim? i did not find ORACLE.exe in bin folder. i think antivirus delete this exe. how can i create it. plz help how can i star service orcl.
Well if you don't have a complete Oracle Install you'll need to install the same software again - I'd suggest in a new Oracle Home. Once you've done that you can create the service with oradim from the new home and then move the initialisation parameter file to the new home and start the service up.

That all said I very, very much doubt the AV would delete oracle unless you have already succumbed to a virus, in which case you'll need to deal with that appropriately first.

Niall
650105
i have install Oracle complete. every thing was fine last nite but in morning developer told me we are not able to connect with database. when i check i found in services ORacle Service orcl not present i tried very hard to recover but fail. if u can give me favour i gave u my server live ip u can connect to my server by just giving IP in remote admin and check my server i'm really greatfull to u.
Niall Litchfield
Oracle Studnet wrote:
i have install Oracle complete. every thing was fine last nite but in morning developer told me we are not able to connect with database. when i check i found in services ORacle Service orcl not present i tried very hard to recover but fail. if u can give me favour i gave u my server live ip u can connect to my server by just giving IP in remote admin and check my server i'm really greatfull to u.
In a word No. You absolutely should not let people you've never met onto your systems over the internet. Ever.

Niall Litchfield
http://www.orawin.info/
Charles Hooper
Niall,

Do you think that the OP should try the following command to re-create the service: 
C:\> ORADIM -NEW -SID ORCL
As far as I have been able to determine, that command will not cause an issue, and will return an error if the service already exists.

To the OP: It is possible that a utility, such as HiJackThis, was used to remove the service, the Windows registry is corrupt, someone used ORADIM to delete the service, someone was hacking away in the registry and accidentally removed the entry for the service, or any number of other possibilities (I am not sure if MSCONFIG will remove a service when that program disables the service, but that might be another possibility, and dropping the database is another possibility).

Charles Hooper
Co-author of "Expert Oracle Practices: Oracle Database Administration from the Oak Table"
http://hoopercharles.wordpress.com/
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.

Edited by: Charles Hooper on Jan 22, 2010 10:42 AM
Added the note about dropping the database as a possible cause - see if the datafiles still exist.
user6383385
If you know the name of the service, you should be able to recreate the service with the following command:

oradim -new -sid orcl -startmode auto -srvcstart system -shutmode immediate

for more information on oradim, just open a cmd window and type oradim and hit <enter>

I could not agree more with Niall Litchfield, never allow anyone you do not know to connect to your servers. May be this is why the service is missing first place.

See, the oradim command can be used to create an instance but also to delete an instance.

The problem you are facing usually happens when you restore your system to a point in time where the database was not installed. This means that the database itself could still be available on disk, however, the registry entries are gone.

Therefore, by using the oradim command, you should be able to recreate the instance.

Daniel Da Meda
Niall Litchfield
Charles Hooper wrote:
Niall,

Do you think that the OP should try the following command to re-create the service: 
C:\> ORADIM -NEW -SID ORCL
As far as I have been able to determine, that command will not cause an issue, and will return an error if the service already exists.
Hi Charles

Yes that's the correct command to use, however if oracle.exe doesn't exist in %ORACLE_HOME%\bin then the install is, to put it technically, somewhat hosed. This sort of situation really does require someone who knows what they are doing (Oracle Support spring to mind) to take a look. If the service has gone and the binaries are missing then some sort of recovery is in order (and I'd want to be confident about the server state first).

Niall
650105
i tried this command but i get following error
ORADIM -NEW -SID ORCL
Instance created.
DIM-00019: create service error
O/S-Error: (OS 2) The system cannot find the file specified.

Edited by: Oracle Studnet on Jan 22, 2010 8:23 AM
Charles Hooper
Oracle Studnet wrote:
i tried this command but i get following error
ORADIM -NEW -SID ORCL
Instance created.
DIM-00019: create service error
O/S-Error: (OS 2) The system cannot find the file specified.
I think that what you posted above is related to the concern expressed by Niall. The message that the instance was created means that the Windows service was successfully added. After the service is created, it should attempt to start, and in the process open the database. I am assuming that the message returned by the operating system means that the control file or one (or more) of the other files needed by the database could not be found (was deleted or moved, which cannot happen on Windows when the database is open). Check the alert log for the database, and review the activity.

Charles Hooper
Co-author of "Expert Oracle Practices: Oracle Database Administration from the Oak Table"
http://hoopercharles.wordpress.com/
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
650105
all files present at thier locations no file deleted or move. there is no error in alter log
Charles Hooper
Oracle Studnet wrote:
all files present at thier locations no file deleted or move. there is no error in alter log
So, are you able to connect to the database now?

I suggested reviewing the alert log, not necessarily to see if there was an error, but that is certainly something you would want to check. Another thing to check is when (and why) the database went down.

You might also want to review the oradim.log file in the database directory of the Oracle home. Something caused the operating system to return the file not found error, so hopefully more detail will be found in a log.

Charles Hooper
Co-author of "Expert Oracle Practices: Oracle Database Administration from the Oak Table"
http://hoopercharles.wordpress.com/
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
Niall Litchfield
Charles Hooper wrote:
Oracle Studnet wrote:
i tried this command but i get following error
ORADIM -NEW -SID ORCL
Instance created.
DIM-00019: create service error
O/S-Error: (OS 2) The system cannot find the file specified.
I think that what you posted above is related to the concern expressed by Niall. The message that the instance was created means that the Windows service was successfully added. After the service is created, it should attempt to start, and in the process open the database. I am assuming that the message returned by the operating system means that the control file or one (or more) of the other files needed by the database could not be found (was deleted or moved, which cannot happen on Windows when the database is open).
Hi Charles,

I expect that the service creation has failed (or maybe created a disabled service). Part of the service definition is the path to the oracle executable. ImagePath from memory. Unless the OP has reinstalled then we already know that this file does not exist, and the error is a create service O/S error not a start service error.

Hi Studnet

You really do sound like you need to get some professional level support in from either Oracle, your IT dept or an external provider ( I work for one, but I'd find one local to you). This really is unlikely to be a forum question (other than some of the odd error messages being illuminating as to Oracle on Windows internals)

Niall
Marco Gralike
AFAIK Windows is nasty and never got it a 100% bullit proof.

If the service for the instance exist try to remove it via a
oradim -delete -sid ORCL
but ONLY if you have stopped the service beforehand. Not doing so will leave a disabled service or residu on the filesystem.

Service leftovers in the registry could be removed via the SC command (http://www.liberidu.com/blog/?p=304).

File residu is most of the time the orapw{ORCL}.ora file (your password file for the instance).

If you try to recreate a instance with the orapw{SID}.ora still file in place (in %ORACLE_HOME%/dbs/orapwORCL.ora), you create ORADIM statement will fail with the mentioned error messages. In short, it will create the instance, but it can not create the link between the instance registry entry and startup commands due to the existence of the orapw{SID}.ora password file.

The orapw{SID}.ora file will be created, by default on Windows, in %ORACLE_HOME%/dbs. Rename that file or make a backup after you have deleted the instance. Then try again while using (at least thats what I always do) the full syntax of ORADIM (by heart: "oradim -new -sid ORCL -startmode auto -pfile d:\oracle\......\initORCL.ora" etc or use a spfile syntax)
Niall Litchfield
Marco Gralike wrote:
AFAIK Windows is nasty and never got it a 100% bullit proof.

If the service for the instance exist try to remove it via a
oradim -delete -sid ORCL
but ONLY if you have stopped the service beforehand. Not doing so will leave a disabled service or residu on the filesystem.

Service leftovers in the registry could be removed via the SC command (http://www.liberidu.com/blog/?p=304).

File residu is most of the time the orapw{ORCL}.ora file (your password file for the instance).

If you try to recreate a instance with the orapw{SID}.ora still file in place (in %ORACLE_HOME%/dbs/orapwORCL.ora), you create ORADIM statement will fail with the mentioned error messages. In short, it will create the instance, but it can not create the link between the instance registry entry and startup commands due to the existence of the orapw{SID}.ora password file.

The orapw{SID}.ora file will be created, by default on Windows, in %ORACLE_HOME%/dbs. Rename that file or make a backup after you have deleted the instance. Then try again while using (at least thats what I always do) the full syntax of ORADIM (by heart: "oradim -new -sid ORCL -startmode auto -pfile d:\oracle\......\initORCL.ora" etc or use a spfile syntax)
Hi Marco

Thanks for the prompt to verify this. I did the following tests on my laptop 11gR1 - I have an instance DB11GR1 on this machine.

first testing my theory rename oracle.exe to oracle.exe.old 
C:\Windows\system32>oradim -new -sid test
Instance created.
The Oracle test VSS Writer Service service is starting.
The Oracle test VSS Writer Service service was started successfully.

DIM-00019: create service error
O/S-Error: (OS 2) The system cannot find the file specified.
then rename back. 
C:\Windows\system32>oradim -new -sid test2
Instance created.
The Oracle test2 VSS Writer Service service is starting.
The Oracle test2 VSS Writer Service service was started successfully.
next with PWDdb11gr1.ORA in place and the service in place 
C:\Windows\system32>oradim -new -sid db11gr1
DIM-00019: create service error
O/S-Error: (OS 1073) The specified service already exists.
delete the service with sc - so PWD remains - I took a copy just in case 
C:\Windows\system32>sc delete oracleservicedb11gr1
[SC] DeleteService SUCCESS

C:\Windows\system32>dir c:\oracle\product\db\11.1.0.7\database\PWD*
 Volume in drive C is Vista
 Volume Serial Number is 52B2-1DD0

 Directory of c:\oracle\product\db\11.1.0.7\database

25/01/2010  12:38             1,536 PWDdb11gR1 - Copy.ora
25/01/2010  12:38             1,536 PWDdb11gR1.ora
now try to recreate the service 
C:\Windows\system32>oradim -new -sid db11gr1
Instance created.
The Oracle db11gr1 VSS Writer Service service is starting.
The Oracle db11gr1 VSS Writer Service service was started successfully.
so in this case I'm pretty sure that it's a missing oracle.exe rather than a pre-existing password file that's the culprit.

cheers

Niall Litchfield
http://www.orawin.info/
Niall Litchfield
and a nice side effect of this test is that I discovered that oradim - delete in 11g also removes the volume shadow copy support service that now gets installed for each database.

regards

Niall Litchfield
Oracle DBA

http://www.orawin.info/
Marco Gralike
You got way to much time at your hands Niall :-)

Anyway. You could be right (and of course you are right in your situation). More information about the issue can most of the time be deducted from the %ORACLE_HOME%/dbs/oradim.log file or an sqlnet.log file created in %ORACLE_HOME%/dbs. As usual on Windows, getting useful info is very difficult. Oradim.log is very sparse regarding error issues.

The info given was based on the initial request of "Oracle Studnet"
1 - 19
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 22 2010
Added on Jan 22 2010
#general-database-discussions
19 comments
70,520 views