#!/bin/sh
###################################################################################
# Purpose: Oracle Clusterware Action Script Database MYDB
# Script: /u01/app/oracle/action_scripts/action_mydb.sh
# Logfile: $ORACLE_BASE/diag/crs/<server>/crs/trace/crsd_scriptagent_oracle.trc
###################################################################################

export ORACLE_SID=damt
export ORACLE_HOME=/u01/app/oracle/product/19/dbhome_1
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
export GRID_HOME=/u01/app/19/grid

case $1 in
'start')
echo "STARTUP DATATABASE $ORACLE_SID"
NODE_NAME=$(${GRID_HOME}/bin/olsnodes -l)
$ORACLE_HOME/bin/sqlplus -s / as sysdba << EOF
startup
alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=${NODE_NAME}-vip.example.de)(PORT=1521))))' scope=memory;
EOF
exit 0
;;

'stop')
echo "SHUTDOWN DATABASE $ORACLE_SID"
$ORACLE_HOME/bin/sqlplus -s / as sysdba << EOF
shutdown immediate
EOF
exit 0
;;

'clean')
echo "SHUTDOWN ABORT DATATABASE $ORACLE_SID"
$ORACLE_HOME/bin/sqlplus -s / as sysdba << EOF
shutdown abort
EOF
exit 0
;;

'check')
echo "CHECK STATUS DATABASE $ORACLE_SID"
NUM=`ps -ef | grep -i -w ora_pmon_${ORACLE_SID} | grep -v grep | wc -l`
if [ $NUM = 0 ]; then
exit 1
else
exit 0
fi
;;
esac