Thursday, March 14, 2013

Oradim -edit -sid gives Unable to start service, OS Error 1056



Every Time i restart the system, i need to bring up the Oracle instance service either from services.msc or using netstart.

So i have decided to make it auto start whenever i restart the system.

##########################
#   Errors 
##########################

Unable to start service, OS Error 1056

##########################
#   Command Used  
##########################

oradim -edit -sid orawin -startmode auto -srvcstart system


##########################
#   Informations  
##########################

I have used this command before in 10g but it didnt give any errors, But when i tried it in 11.2.0.1.0 version of database, getting this error. This seems to be Bug 9584383 and its expected if a service is edited when its running.

But in my case, i have tried by stopping the service also still  the error comes. So whether a service is running or not running, when we try to modify the startmode of a service we will get an error.

##########################
 Solution 
##########################

  We don't have to worry about the error because eventhough we get an error while modifying the service startmode, the command does it purpose, Instance Service startmode gets changed when we issue the command. 

This bug is fixed in.
  • 12.1 (Future Release)
  • 11.2.0.2 (Server Patch Set)
  • 11.2.0.1 Patch 2 on Windows Platforms
Change the Database Service Startmode from Manual to Automatic.

oradim -edit -sid orawin -startmode auto -srvcstart system




Change the Database Service Startmode from Automatic to Manual.

oradim -edit -sid orawin -startmode manual -srvcstart demand



Below Link will be useful if you want start the service using commands like oradim and net start.




No comments: