Solved

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

Posted on 2012-04-09
5
473 Views
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!

Thanks,

Jing
0
Comment
Question by:hanjgr
5 Comments
 
LVL 73

Assisted Solution

by:sdstuber
sdstuber earned 150 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
0
 
LVL 12

Assisted Solution

by:Pra4444
Pra4444 earned 150 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.
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 100 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:
http://technet.microsoft.com/en-us/library/cc739591(v=ws.10).aspx
0
 
LVL 23

Assisted Solution

by:David
David earned 100 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.
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 37985861
why the B?
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

785 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