LISTING 11: This script, godb, is called by dbAdmCron.sh (Listing 10). It changes the IPC connection to the target database if there are multiple databases on the same UNIX host.

#!/bin/ksh 
# filename : godb			change (go) to another Oracle database (db)
# Author   : Julius J.Y. Lin  	01/08/96
# ==============================================================
if [ $# -lt 1 ] ; then
   echo '\n usage : . godb ORACLE_SID '
   echo '   eg. : . godb LAWT 	# or '
   echo '   eg. : . godb lawt '
   echo ' The dot before godb is significant, lowercase will become CAPITAL \n'
   exit
fi  

oldSID=$ORACLE_SID
# SID=`echo $1 | tr a-z A-Z`
typeset -u SID=$1
export ORACLE_SID=$SID
export ORAENV_ASK=NO
. oraenv
export OH=$ORACLE_HOME
# Oenv is alias in .kshrc or in /usr/contrib/bin
if [ $# = 2 ] ; then
   if [ "$2" = "-v" ] ; then
      Oenv
   fi
else
   echo "\t Change ORACLE_SID from $oldSID to '$ORACLE_SID'" 
fi