Re: How to setup automatic DB startup after cold boot?

Take your mouse and hold down the left cursor over START, then Settings then Control Panel. Double click left mouse button twice on Services icon.

Place your left mouse button on the scroll bar and hold down. Scroll until you see OracleStartORCL (assuming this is a default installation of Oracle--if not a default installation OracleStartYYYY where YYYY is your database SID). Click your left mouse button over the line containing OracleStartORCL to highlight it. Click left mouse button once over Startup Button. Click your left mouse button once in Automatic. Click left mouse button once on OK. Look at line containing OracleStartORCL. Under Startup Column, it should say Automatic. Now click left mouse button once on Close. You are done.

This assumes that you have a command file, created by the utility OradimNM, where NM is your version (80 = 8.0, 73 = 7.3) called strtORCL.cmd which contains valid startup information. If the database does not start automatically when you cold boot, we can track down the problem then.

The service OracleStartORCL starts the service OracleServiceORCL if not already started and starts the database.

You probably want to set the service OracleTNSListener for automatic startup as well.

Peter Fullbright (pfullbright_at_hotmail.com) wrote:
: Folks

: I am new to administering Oracle on NT. What settings are required to
: automatically startup the database after a cold reboot of the NT machine
: running Oracle? Thanks

: -PF

-- Received on Mon Nov 09 1998 - 11:38:45 CST