Home » RDBMS Server » Server Administration » Auto Start Oracle 10G on windows 2003 Server
icon5.gif  Auto Start Oracle 10G on windows 2003 Server [message #335786] Wed, 23 July 2008 14:28 Go to next message
jren
Messages: 13
Registered: May 2008
Junior Member
We have Oracle 10G runnin on window 2003 server, and we found that the Oracle not started each time when we reboot the box on weekends, how we are able to set Oracle start automatically after reboot ? Thx.
Re: Auto Start Oracle 10G on windows 2003 Server [message #335787 is a reply to message #335786] Wed, 23 July 2008 14:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
google or search the docs for ORADIM
http://www.oracle.com/pls/db102/search?remark=quick_search&word=oradim&tab_id=&format=ranked
If the service is already created, check the properties of the service in control panel/services

[Updated on: Wed, 23 July 2008 14:35]

Report message to a moderator

Re: Auto Start Oracle 10G on windows 2003 Server [message #335814 is a reply to message #335787] Wed, 23 July 2008 17:21 Go to previous messageGo to next message
jren
Messages: 13
Registered: May 2008
Junior Member
The service in control panel is running , but we have to use sqlplus to start the instance manually, how we are able to start the intance automatically ? Thx.
Re: Auto Start Oracle 10G on windows 2003 Server [message #335815 is a reply to message #335814] Wed, 23 July 2008 17:47 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Chec the value of ORA_SID_AUTOSTART in the registry
Re: Auto Start Oracle 10G on windows 2003 Server [message #335822 is a reply to message #335786] Wed, 23 July 2008 18:43 Go to previous messageGo to next message
jren
Messages: 13
Registered: May 2008
Junior Member
That's the problem, we change it to TRUE, and it's working now, thanks a lot.
Re: Auto Start Oracle 10G on windows 2003 Server [message #335868 is a reply to message #335822] Thu, 24 July 2008 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But you could do it with oradim instead of hacking the registry if you read the link Raj provided.

Regards
Michel
Re: Auto Start Oracle 10G on windows 2003 Server [message #335891 is a reply to message #335868] Thu, 24 July 2008 01:54 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
And you could also use "Oracle Administration assistant for Windows" if you wanted...
Previous Topic: resize logfile (merged)
Next Topic: Table disappeared
Goto Forum:
  


Current Time: Sat Dec 03 00:53:29 CST 2016

Total time taken to generate the page: 0.04831 seconds