Start/Shutdown of Oracle Databases in Unix
Date: 1996/08/26
Message-ID: <500fkc$2co_at_client3.news.psi.net>#1/1
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.
- su - oracle
- set environment variables (ORACLE_SID is the one that will need to change each time i need to startup a differnet database.
- sqldba lmode=y inside the sqldba i then type
- connect internal
- 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 Received on Mon Aug 26 1996 - 00:00:00 CEST