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

Posted on 2012-04-09
Medium Priority
Last Modified: 2012-05-18
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!


Question by:hanjgr
LVL 74

Assisted Solution

sdstuber earned 450 total points
ID: 37823360
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
LVL 12

Assisted Solution

Pra4444 earned 450 total points
ID: 37823363
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.
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 300 total points
ID: 37823371
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:
LVL 23

Assisted Solution

David earned 300 total points
ID: 37823383
Jing, I'm not a WinServer person, but I seem to recall it simply takes placing the executable in the startup menu.
LVL 74

Expert Comment

ID: 37985861
why the B?

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question