#! /bin/bash
#
sid=$1
export RPTDATE=`date '+%m%d'`
export SCRPTDIR=/home/oracle/SCN_patch/13498243/files/rdbms/admin
export RPTDIR=/home/oracle/SCN_patch/13498243/files/rdbms/admin
export OUTFILE=$RPTDIR/scncheck_out_$sid.spool
export ORACLE_SID=${sid}
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export PATH=$ORACLE_HOME/bin:/bin:/usr/local/bin:${PATH}

echo $ORACLE_SID
echo $ORACLE_HOME

sqlplus /nolog << EOF
connect / as sysdba
set pagesize 999
spool $OUTFILE
select instance_name from v\$instance;
@/home/oracle/SCN_patch/13498243/files/rdbms/admin/scnhealthcheck.sql
spool off
exit
EOF