• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 490
  • Last Modified:

How to config the oracle database to start up automatically after an automatic system reboot?

I have Oracle 9i databases in Windows Server 2003 system.

I am wondering how to set up the configuration for the oracle databases so that when server is rebooted automatically (through e.g., windows updates), the databases can be restarted automatically after server is up as well.

I'll really appreciate any help!

Thanks,

Jing
0
hanjgr
Asked:
hanjgr
4 Solutions
 
sdstuberCommented:
control panel,  administrative tools, services

find your oracle service ,  change Startup Type to Automatic


you'll probably want to have the listener service startup automatically too
0
 
Pra4444Commented:
Please look in the services(administrative tools->services) and find the Oracle service for your database. Change the startup type to automatic. So when the system reboots, the oracle service will be started automatically.
0
 
slightwv (䄆 Netminder) Commented:
Restarted is easy:  Set the Service to automatic.

Shutdown on Windows is a little more problematic.  The 'default' Windows shutdown does not gracefully shut down Oracle.  You will need a shudtown script:
http://technet.microsoft.com/en-us/library/cc739591(v=ws.10).aspx
0
 
DavidSenior Oracle Database AdministratorCommented:
Jing, I'm not a WinServer person, but I seem to recall it simply takes placing the executable in the startup menu.
0
 
sdstuberCommented:
why the B?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now