#!/bin/bash

sid=$1

oh=`/usr/local/bin/dbhome $sid`
if [ "$?" == "0" ]; then
	export ORACLE_HOME=${oh}
else
	end=`expr length ${sid} - 1`
	nsid=${sid:0:$end}
	oh=`/usr/local/bin/dbhome $nsid`
	if [ "$?" == "0" ]; then
		export ORACLE_HOME=${oh}
	else
		echo "fail"
		exit
	fi
fi

SRCDIR=/home/oracle/em7_mon
SRCFILE=$SRCDIR/em7_tps.sql

RPTDIR=/var/log/oracle
RPTFILE=$RPTDIR/tps$sid.rpt

export ORACLE_SID=${sid}

$ORACLE_HOME/bin/sqlplus -s /nolog << EOS >> $RPTFILE
connect /as sysdba
@$SRCFILE
EOS

exit
