Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cron scripts
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
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