Search
j0ke.net Open Build Service
>
Projects
>
SUSE
:
Manager
:
1.2
>
oracle-config
> oraenv
Sign Up
|
Log In
Username
Password
Cancel
Overview
Repositories
Revisions
Requests
Users
Advanced
Attributes
Meta
File oraenv of Package oracle-config
#!/bin/sh # # $Header: oraenv.sh.pp 16-jun-2005.10:46:09 mlfallon Exp $ oraenv.sh.pp Copyr (c) 1991 Oracle # ################################### # # usage: . oraenv # # This routine is used to condition a user's environment for access to # an ORACLE database. It will prompt for the value of the new SID unless # the variable ORAENV_ASK is set to NO, in which case it will use the # current value of ORACLE_SID. # The character "*" denotes a null SID. # # NOTE: Due to constraints of the shell in regard to environment # ----- variables, the command MUST be prefaced with ".". If it # is not, then no permanent change in the user's environment # can take place. # ##################################### case ${ORACLE_TRACE:-""} in T) set -x ;; esac # # Determine how to suppress newline with echo command. # N= C= if echo "\c" | grep c >/dev/null 2>&1; then N='-n' else C='\c' fi # # Set minimum environment variables # # ensure that OLDHOME is non-null if [ ${ORACLE_HOME:-0} = 0 ]; then OLDHOME=$PATH else OLDHOME=$ORACLE_HOME fi case ${ORAENV_ASK:-""} in #ORAENV_ASK suppresses prompt when set NO) NEWSID="$ORACLE_SID" ;; *) case "$ORACLE_SID" in "") ORASID=$LOGNAME ;; *) ORASID=$ORACLE_SID ;; esac echo $N "ORACLE_SID = [$ORASID] ? $C" read NEWSID case "$NEWSID" in "") ORACLE_SID="$ORASID" ;; *) ORACLE_SID="$NEWSID" ;; esac ;; esac export ORACLE_SID ORAHOME=`dbhome "$ORACLE_SID"` case $? in 0) ORACLE_HOME=$ORAHOME ;; *) echo $N "ORACLE_HOME = [$ORAHOME] ? $C" read NEWHOME case "$NEWHOME" in "") ORACLE_HOME=$ORAHOME ;; *) ORACLE_HOME=$NEWHOME ;; esac ;; esac export ORACLE_HOME # # Reset LD_LIBRARY_PATH # case "$LD_LIBRARY_PATH" in *$OLDHOME/lib*) LD_LIBRARY_PATH=`echo $LD_LIBRARY_PATH | \ sed "s;$OLDHOME/lib;$ORACLE_HOME/lib;g"` ;; *$ORACLE_HOME/lib*) ;; "") LD_LIBRARY_PATH=$ORACLE_HOME/lib ;; *) LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH ;; esac export LD_LIBRARY_PATH # # Put new ORACLE_HOME in path and remove old one # case "$OLDHOME" in "") OLDHOME=$PATH ;; #This makes it so that null OLDHOME can't match esac #anything in next case statement case "$PATH" in *$OLDHOME/bin*) PATH=`echo $PATH | \ sed "s;$OLDHOME/bin;$ORACLE_HOME/bin;g"` ;; *$ORACLE_HOME/bin*) ;; *:) PATH=${PATH}$ORACLE_HOME/bin: ;; "") PATH=$ORACLE_HOME/bin ;; *) PATH=$PATH:$ORACLE_HOME/bin ;; esac export PATH # # Install any "custom" code here # # Locate "osh" and exec it if found ULIMIT=`LANG=C ulimit 2>/dev/null` if [ $? = 0 -a "$ULIMIT" != "unlimited" ] ; then if [ "$ULIMIT" -lt 2113674 ] ; then if [ -f $ORACLE_HOME/bin/osh ] ; then exec $ORACLE_HOME/bin/osh else for D in `echo $PATH | tr : " "` do if [ -f $D/osh ] ; then exec $D/osh fi done fi fi fi