Skip to content

Instantly share code, notes, and snippets.

@ethnchao

ethnchao/oracle-bash_profile

Created May 30, 2018 07:58
Show Gist options
  • Save ethnchao/a7cc0600e6c394e59079295ffdc5ef3b to your computer and use it in GitHub Desktop.
Save ethnchao/a7cc0600e6c394e59079295ffdc5ef3b to your computer and use it in GitHub Desktop.
Download ZIP
Oracle RAC user Bash profile
Raw
oracle-bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
export ORACLE_SID=PROD1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1
export ORACLE_TERM=xterm
export ORACLE_UNQNAME=PROD
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin:/usr/bin:/bin:usr/bin/X11:/usr/local/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export TEMP=/tmp
export TMPDIR=/tmp
export DISPLAY=172.17.98.55:0.0
umask 022
Raw
oracle-grid-bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
export ORACLE_SID=+ASM1
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2.0.4/grid
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin:/usr/local/bin
export TEMP=/tmp
export TMP=/tmp
export TMPDIR=/tmp
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
export NLS_DATE_FORMAT="YYYY-MM-DD"
export DISPLAY=172.17.98.55:0.0
umask 022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment