.bash profile oracle

From Robs_Wiki
Jump to: navigation, search
#*****************************************************************
# Keyboard
#*****************************************************************
stty erase ^?
set -o vi

#*****************************************************************
# Standard UNIX Prompt
#*****************************************************************
ORACLE_SID=OEMDB; export ORACLE_SID
PS1="
 `hostname`*\${ORACLE_SID}-\${PWD}
$"
export PS1

#*****************************************************************
# Aliases
#*****************************************************************
alias sp='sqlplus "/as sysdba"'
alias pmon='ps -ef|grep pmon|grep -v grep'

#*****************************************************************
# Oracle OEMDB database settings
#*****************************************************************
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/12.1.0/OEMDB
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=American_America
export ORACLE_TERM=sun
export EDITOR=vi
export DISPLAY=localhost:1
export TMP=/tmp
export HISTFILE=${HOME}/.sh_history
export HISTSIZE=200
export JAVA_HOME=/usr/bin/java

# export OMS_HOME=/u01/app/oracle/product/MiddleWare/MiddleWare/oms
# export AGENT_HOME=/u01/app/oracle/product/MiddleWare/MiddleWare/agent/core/12.1.0.1.0

#****************************************************************
# Final settings
#****************************************************************
export PATH=$ORACLE_HOME/bin:/usr/bin:/usr/X11/bin:/usr/openwin/bin