Saluting. Start - Stop script
articles:
It is an English word that sounds very funny in Spanish, almost unreal.
Well, just wanted to brand the blog with a first entry to introduce myself.
I work as an Oracle and SQL Server DBA (mixed profile, they call it -
concerns twice for the same pay, on me).
Here I will write "how to" articles as they emerge in my day to day.
If you can read Spanish, check out the blog I maintain for a little more time http://blog.davidlozanolucas.com/.
Here is a script to start/stop Oracle databases running in Unix:
# ================================================================================================
# Performs stop/start of instance (MYDB for this example).
# Parameters:
# 1) start | stop
#
#
# ================================================================================================
if [ $# -ne 1 ]; then
exit 99
fi
accion=$1
export ORACLE_SID=MYDB
case "$accion" in
'start')
sqlplus "/ as sysdba" <<HOLA
startup
HOLA
tail -n 200 $ORACLE_BASE/admin/MYDB/bdump/alert_MYDB.log > /tmp/backup_replica.alert.tmp
grep -i "Completed: ALTER DATABASE OPEN" /tmp/backup_replica.alert.tmp
cod1=$?
grep -i "Starting ORACLE instance (normal)" /tmp/backup_replica.alert.tmp
cod2=$?
if [ $cod1 -ne 0 ] || [ $cod2 -ne 0 ]; then
exit 1
fi
# -------- LISTENER ---------
lsnrctl start LISTENER
if [ $? -ne 0 ]; then
exit 2
fi
;;
'stop')
# -------- LISTENER ---------
lsnrctl stop LISTENER
if [ $? -ne 0 ]; then
exit 2
fi
# ------- BASE DE DATOS ----
sqlplus "/ as sysdba" <<HOLA
shutdown immediate
HOLA
tail -n 200 $ORACLE_BASE/admin/MYDB/bdump/alert_MYDB.log > /tmp/backup_replica.alert.tmp
grep -i "ALTER DATABASE DISMOUNT" /tmp/backup_replica.alert.tmp
cod1=$?
grep -i "Completed: ALTER DATABASE DISMOUNT" /tmp/backup_replica.alert.tmp
cod2=$?
echo "cod1 $cod1 -- cod2 $cod2"
if [ $cod1 -ne 0 ] || [ $cod2 -ne 0 ]; then
exit 1
fi
;;
*)
echo " " >/dev/null 2>&1
;;
esac
exit 0
# ================================================================================================
»
- David Lozano Lucas's blog
- Log in to post comments
