Oracle环境变量设置脚本

200次阅读

共计 1521 个字符，预计需要花费 4 分钟才能阅读完成。

每次都傻乎乎的往 bashrc 里面写环境变量，感觉不任性。于是，看了本书了解了 /etc/oratab 这个东东后，参考着书也写了一个设置 Oracle 环境变量的脚本。

在 /etc/ 下创建 oraset, 权限设置为 chown oracle:oinstall /etc/oraset

oraset 内容：

#!/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/oratab
elif [-f /var/opt/oracle/oratab]; then
OTAB=/var/opt/oracle/oratab
else
echo ‘oratab file not found.’
exit
fi
#
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
done
else
if egrep -v ‘#|\*’ ${OTAB} | grep -w “${1}:”>/dev/null; then
HOLD_SID=$1
else
echo “SID: $1 not found in $OTAB”
fi
shift
fi
#
ORACLE_SID=$HOLD_SID
export ORACLE_SID
export ORACLE_HOME=$(egrep -v ‘#|\*’ ${OTAB} | grep -w $ORACLE_SID:|cut -f2 -d:)
export ORACLE_BASE=${ORACLE_HOME%%/product*}
export TMP=$ORACLE_BASE/../tmp
export TMPDIR=$TMP
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ADR_BASE=$ORACLE_BASE/diag
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib