Re: Start/Shutdown of Oracle Databases in Unix
Date: 1996/08/28
Message-ID: <500ugn$qh5_at_scel.sequent.com>#1/1
Check out $ORACLE_HOME/bin/dbstart.
This is an Oracle supplied script which you put into the system startup file (/etc/rc or your local equivalent, check your manuals or ask your Sys Admin). It will start up any instance which is documented in the /etc/oratab file, containing a 'Y' in the third field.
The file $ORACLE_HOME/bin/dbshut, when placed in your system shutdown script will shutdown all these databases.
You will need to manually add any startup scripts for SQL*Net, Oracle*Mail, etc.
Regards,
Pete
trazz_at_interaccess.com wrote:
> Does anyone have any unix shell scripts to startup and shutdown
> multiple databases in unix. i have to do the following manually and it
> gets boring every time.
> 1. su - oracle
> 2. set environment variables (ORACLE_SID is the one that will need to
> change each time i need to startup a differnet database.
> 3. sqldba lmode=y
> inside the sqldba i then type
> 4. connect internal
> 5. startup or shutdown immediate
> 6 . exit
> I have to repeat that process each time for every database on the
> server. how can i make it automatically in a shell script do all of
> those things without the need for user intervention. i want to start
> and stop it from cron as well. I need it to be able to change to a
> different database name each time and be able to start or stop all or
> some of them.
> We are running on Sun OS 5.4/Solaris 2.4
> Oracle 7.1.4 & Oracle 7.3 &
> SQL*DBA: Release 7.2.2.3.0 - Production on Tue Aug 27 22:46:23 1996
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
> Oracle7 Server Release 7.2.2.3.0 - Production Release
> With the distributed and parallel query options
> PL/SQL Release 2.2.2.3.0 - Production
> SQLDBA>
> Thanks,
> Trazz
-- Peter Moore. DBA, IS Ops, Sequent Computer Systems Ltd, Weybridge, UK.Received on Wed Aug 28 1996 - 00:00:00 CEST