[Oracle] -- 配置Oracle環境變數

Michael-JOE發表於2020-12-11

1、Oracle客戶端

source /root/.cshrc

# .cshrc

#alias rm 'rm -i'
#alias cp 'cp -i'
#alias mv 'mv -i'

export LANG=en_US
export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/local/lib:$LD_LIBRARY_PATH:.
export TNS_ADMIN=$ORACLE_HOME
export PATH=$PATH:$ORACLE_HOME/bin:.
export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"

export ORACLE_SID=ORA11

2、Oracle服務端

source ~/.bash_profile

ORACLE_BASE=/oracle/app/oracle
ORACLE_HOME=/oracle/app/oracle/product/12.2.0
oraInventory=/oracle/app/oracle/oraInventory

export ORACLE_BASE ORACLE_HOME
export PATH=$PATH:$OARCLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/oracm/lib:/lib:/usr/lib:/usr/local/lib

unmask 022
echo "oracle 12.2.0.1 env is set"
export ORACLE_SID=ormpdb

 

相關文章