export ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1 export ORACLE_BASE=/opt/oracle export TNS_ADMIN=/opt/oracle/product/11.2.0/dbhome_1/network/admin export SQLPATH=/home/oracle/sql ORIG_PATH=$PATH # setzen einer DB setdb () { echo "bisherige Oracle_Sid=$ORACLE_SID" a=${1-$ORACLE_SID} if [ -z "$1" ] then echo "zulaessige DB's : 1=EXEC01 2=client 3=: [$ORACLE_SID] >\c" read a a=${a:=$ORACLE_SID} fi A=`echo "$a"|tr "[a-z]" "[A-Z]"` case "$A" in 1 | EXEC01 ) ORACLE_SID=EXEC01 ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1;; 2 | client ) ORACLE_HOME=/opt/oracle/product/11.2.0/client_1 ORACLE_SID=;; *) echo "falsche Eingabe: $a ($A)" ;; esac export ORACLE_SID export ORACLE_HOME export PATH=$ORIG_PATH:$ORACLE_HOME/bin echo "die neue Oracle_Sid=$ORACLE_SID unter dem Home $ORACLE_HOME" } whichdb() { echo "die Oracle_Sid=$ORACLE_SID" }