#!/bin/ksh


. ${ENV}/oracle_env.ksh

****I WANT TO SSH AT THIS POINT AND CONTINUE WITH REMAINDER OF SCRIPT BELOW ****

DB_NAME=cidw2
TOTAL_RC=0

export TOTAL_RC DB_NAME 

# Shutdown ${DB_NAME} database on INDITF2 
echo "*********************** Bouncing the database ***************************"

ORACLE_SID=${DB_NAME}
export ORACLE_SID
EOF
sqlplus internal << EOF 
whenever sqlerror exit failure;
whenever oserror exit failure;
--ALTER SYSTEM ARCHIVE LOG CURRENT;
--ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
shutdown abort
exit
EOF

RC=$?
TOTAL_RC=`expr ${TOTAL_RC} + ${RC}`
export TOTAL_RC

rm $ORACLE_HOME/dbs/orapw${DB_NAME}
orapwd file=$ORACLE_HOME/dbs/orapw${DB_NAME} password=change_on_install entries=10

RC=$?
TOTAL_RC=`expr ${TOTAL_RC} + ${RC}`
export TOTAL_RC

sqlplus internal << EOF
whenever sqlerror exit failure;
whenever oserror exit failure;
startup nomount
exit
EOF


RC=$?
TOTAL_RC=`expr ${TOTAL_RC} + ${RC}`
export TOTAL_RC

if [ ${TOTAL_RC} -eq 0 ]
then
        echo "###################################################"
        echo "#####   Database ${DB_NAME} started nomount   #####"
        echo "###################################################"
        exit 0
else
        echo "#######################################################"
        echo "##### DATABASE ${DB_NAME} FAILED TO START NOMOUNT #####"
        echo "#######################################################"
        echo "CIDW2 STARTUP NOMOUNT FAILED" >> ${APP_TEMP}/error_check.log
        exit 1
fi