#!/bin/bash# Sets Oracle environment variables.# Setup: 1. Put oraset file in /etc(Linux), in /var/opt/oracle(Solaris)#        2. Ensure /etc or /var/opt/oracle is in $PATH# Usage: batch mode: . oraset <SID>#        menu mode: . oraset#=======================================================if [ -f /etc/oratab ]; then    OTAB=/etc/oratabelif [ -f /var/opt/oracle/oratab ]; then    OTAB=/var/opt/oracle/oratabelse    echo ‘oratab file not found.‘    exitfi#if [ -z $1 ]; then    SIDLIST=$(egrep -v ‘#|\*‘ ${OTAB} | cut -f1 -d:)    # PS3 inmdicates the prompt to be used for the Bash select command.    PS3=‘SID?‘    select sid in ${SIDLIST}; do        if [ -n $sid ]; then            HOLD_SID=$sid            break;        fi    doneelse    if egrep -v ‘#|\*‘ ${OTAB} | grep -w "${1}:">/dev/null; then        HOLD_SID=$1    else        echo "SID: $1 not found in $OTAB"    fi    shiftfi#ORACLE_SID=$HOLD_SIDexport ORACLE_SIDexport ORACLE_HOME=$(egrep -v ‘#|\*‘ ${OTAB} | grep -w $ORACLE_SID:|cut -f2 -d:)export ORACLE_BASE=${ORACLE_HOME%%/product*}export TMP=$ORACLE_BASE/../tmpexport TMPDIR=$TMPexport TNS_ADMIN=$ORACLE_HOME/network/adminexport ADR_BASE=$ORACLE_BASE/diagexport PATH=$PATH:$ORACLE_HOME/binexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib