runsql - liamlamth/blog GitHub Wiki

PATH=/bin:/usr/bin:/usr/local/bin
GRPNAME=`groups ${LOGNAME} | grep dba | wc -l`

if [ ${LOGNAME} != 'oracle' ] && [ "${GRPNAME}" = "0" ] ; then
   echo This script can only be run by 'oracle' or 'dba' group user!
   exit 1
fi

if [ "${ORACLE_SID}" = "" ] ; then
   echo No ORACLE_SID is defined!
   exit 1
fi

ORACLE_HOME=`/usr/local/bin/dbhome ${ORACLE_SID}`
if [ "${ORACLE_HOME}" = "" ] ; then
   echo Cannot locate ORACLE_HOME for SID: ${ORACLE_SID}!
   exit 1
fi

PATH=${ORACLE_HOME}/bin:${PATH}
if [ "$1" = "" ] ; then
   echo Usage: runsql [SQL script in $ORACLE_HOME/sql]
   echo  e.g.: runsql freespace
   exit 1
fi

if [ ! -f ${ORACLE_HOME}/sql/${1}.sql ] ; then
   echo Cannot find ${1}.sql under ${ORACLE_HOME}/sql directory!
   exit 1
fi

${ORACLE_HOME}/bin/sqlplus -s "sys/syspassword as sysdba" @${ORACLE_HOME}/sql/$1 $2 $3 $4 $5


              


           
⚠️ **GitHub.com Fallback** ⚠️