UNIX Shell ScriptDatabase Shutdown |
Simple database shutdown script. Gets the ORACLE_HOME from /etc/oratab. This script is an alternative to the Oracle supplied dbstart and dbstop scripts.
$1 (MANDATORY) - ORACLE_SID of the database to
stop
$2 (OPTIONAL) - The mode to stop the database in i.e (NORMAL -
default, IMMEDIATE,TRANSACTIONAL, ABORT)
#!/bin/ksh DATABASE=$1 MODE=$2 # Check that we have a database if [ -z "${DATABASE}" ] then echo echo "No Database Specified !" echo echo "Usage : ora_stop.ksh" echo echo "where ORACLE_SID (Mandatory) - SID of database to start" echo " SHUTDOWN MODE - (OPTIONAL, DEFAULT NORMAL) NORMAL,IMMEDIATE,ABORT, TRANSACTIONAL echo echo " e.g. $ dbstop.ksh PROD NORMAL" echo exit 1 fi # Get the ORACLE_HOME from the oratab file ORACLE_HOME=`cat /etc/oratab | grep $DATABASE | awk -F: '{print $2}'` if [ ! -d "${ORACLE_HOME}" ] then echo echo "$ORACLE_HOME does not exist !" echo exit 1 fi ORACLE_SID=$DATABASE export ORACLE_SID PATH=.:$ORACLE_HOME/bin:$PATH; export PATH echo " " echo "Shutting down Database" $DATABASE "in" $MODE "mode" echo " " sqlplus << EOF connect / as sysdba shutdown ${MODE} EOF exit 0
Return to Index of SQL Scripts
Home
|
Company Profile
|
Services
|
Contact Us
|
SQL scripts and tips
|
Quiz
|