2013. 12. 10. 14:15 오라클
oracle profile
* Oracle 환경변수 (for 11g RAC)
umask 022
export ORACLE_OWNER=oracle
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0
export GRID_HOME=/oragrid/product/11.2.0
export ORACLE_SID=RAC1
export ORACLE_TERM=vt100
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG=American_America.KO16KSC5601
export PATH=$ORACLE_HOME/bin:/bin:/sbin:.:$PATH:$ORACLE_HOME/OPatch
export SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib:$ORACLE_HOME/rdbms/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib
export PS1=[`whoami`:'$PWD']#
export AIXTHREAD_SCOPE=S
alias ss='sqlplus "/as sysdba"'
stty erase ^H
-----------------------------------------
* Oracle 환경변수 (HP-UX)
umask 022
export ORACLE_OWNER=oracle
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/ora10
export ORACLE_SID=ORA10
export ORACLE_TERM=vt100
#export TMPDIR=$ORACLE_BASE/tmp
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=American_America.KO16KSC5601
export PATH=$ORACLE_HOME/bin:/bin:/sbin:.:$PATH:$ORACLE_HOME/OPatch/bin
export SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib:$ORACLE_HOME/rdbms/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib
export PS1=[`whoami`:'$PWD']#
alias ss='sqlplus "/as sysdba"'
stty erase ^H
-----------------------------------------
* Oracle 환경변수 (Linux)
umask 022
export ORACLE_OWNER=oracle
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/db
export GRID_HOME=/oragrid/app/grid
export ORACLE_SID=TEST1
export ORACLE_TERM=vt100
#export TMPDIR=$ORACLE_BASE/tmp
export TNS_ADMIN=$ORACLE_HOME/network/admin
#export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=American_America.UTF8
export PATH=$ORACLE_HOME/bin:/bin:/sbin:.:$PATH:$ORACLE_HOME/OPatch
export SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib:$ORACLE_HOME/rdbms/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib
export PS1=[`whoami`:'$PWD']#
export LANG=C
#export LD_ASSUME_KERNEL=2.4.1
alias sp='sqlplus "/as sysdba"'
stty erase ^H
-----------------------------------------
* Oracle 환경변수 (AIX)
umask 022
export ORACLE_OWNER=oracle
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0
export ORACLE_SID=ILMOA
export ORACLE_TERM=vt100
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=AMERICAN_AMERICA.UTF8
export PATH=$ORACLE_HOME/bin:/bin:/sbin:.:$PATH:$ORACLE_HOME/OPatch
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib
export PS1="`whoami`@`hostname`:[\${PWD}]#>"
export LIBPATH=$ORACLE_HOME/lib:/usr/lib
export AIXTHREAD_SCOPE=S
export LANG=en_US
stty erase ^H
alias ss='sqlplus "/as sysdba"'
