Re: simplifying database startup

Brian,
You didn't mention OS platform in your post so I am assuming a UNIX flavor.

One possibility is to create a shell script that gets the SIDs and Y/N startup flag from the /etc/oratab file. Next, loop through the SIDs for which you want to start instances by doing the following:

1. Set ORACLE_SID and ORACLE_HOME using the oraenv procedure
2. Run line-mode Server Manager which will connect to an idle instance
3. Connect as INTERNAL
4. Issue appropriate startup command

The /etc/oratab file is what is read by dbstart upon system boot. All SIDs should be defined in this file along with appropriate ORACLE_HOME and a flage of Y or N indicating automatic startup.

Hope this helps!

-- 
Thomas W. Vanya
Oracle and OracleRdb Database Administrator
Eastman Chemical Company

Brian Gastineau <bgastine_at_giveblood.org> wrote in article
<01bc4aac$7e9ed4e0$b90110ac_at_gastineau1.giveblood.org>...


> I would like to simplify the process of starting multiple instances.  I

> found the "dbstart" utility which appears to closely match my

 requirements.


>  I don't want to use it directly because I don't want the instances to

> start during the host boot.  I am thinking of making a copy of this

> utility, then adapting it to only start the instances that I am

 interested


> in.

> 

> My discomfort comes from the warning in the comments of the utility that

 it


> should only be run during the boot process.  Do you know why this warning

> is issued?

> 

> Thanks,

> Brian

> 

>