Re: Cron scripts

From: Stephen Harris <sweh_at_mpn.com>
Date: 6 Jun 1999 10:39:34 GMT
Message-ID: <7jdj56$2sq$3@nebula.mpn.com>

GDN (gert.deneve_at_advalvas.be) wrote:

: 	. /etc/profile	
: 	. $HOME/.profile

Here's a little ksh function I find useful. From it I can do "sid xyzzy" and it will set the oracle_home, oracle_sid, LD_LIBRARY_PATH and PATH variables based on the entry in /etc/oratab or /var/opt/oracle/oratab

This was written for Solaris, but appears to work on Linux and HPUX as well.

sid()
{
  typeset s h o

  if [ ! -z "$1" ]
  then
    if [ -f /etc/oratab ]
    then
      o=/etc/oratab
    else
      o=/var/opt/oracle/oratab
    fi

    s=$1
    h=$(awk -F: '/^'$s':/{printf("%s",$2)}' $o 2>/dev/null)     if [ -z "$h" ]
    then

      echo $0: Error - can not find ORACLE_HOME entry for $s in $o
      return

    fi

    export ORACLE_HOME=$h
    export ORACLE_SID=$s
    export PATH=$h/bin:$(echo "$PATH\c" | tr : '\012' | grep -v oracle | tr '\012' :)

    export LD_LIBRARY_PATH=$(echo "$LD_LIBRARY_PATH\c" | tr : '\012' | grep -v oracle | grep -v '^$' | tr '\012' :)     if [ -z "$LD_LIBRARY_PATH" ]
    then
      export LD_LIBRARY_PATH=$h/lib
    else
      export LD_LIBRARY_PATH=$h/lib:$LD_LIBRARY_PATH     fi
  fi

  echo ORACLE_SID=${ORACLE_SID:-"No SID assigned"}   echo ORACLE_HOME=${ORACLE_HOME:-"No HOME assigned"}   echo PATH=$PATH
  echo LD_LIBRARY_PATH=$LD_LIBRARY_PATH } Received on Sun Jun 06 1999 - 05:39:34 CDT