#!/bin/csh -f
setenv ORACLE_HOME $2

source ${ORACLE_HOME}/.cshrc

setenv ORACLE_SID $1
set PS="$3"

$PS | grep  pmon_${ORACLE_SID} | grep -v grep
if ( "$status" != "0" ) then
	sqlplus -S /nolog << EOF
	set pause off
	connect / as sysdba
	startup
	exit
EOF
else
	exit 0
endif
$PS | grep  pmon_${ORACLE_SID} | grep -v grep
if ( "$status" != "0" ) then
   exit 1  
endif
exit 0
