# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

export ORACLE_HOME=/u01/19.22
export ORACLE_SID=ora19

#export CV_ASSUME_DISTID=8.2

export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

export DISPLAY=`who am i | awk '{print $5}'| sed 's/[^0-9.]//g'|awk '{print $1":0.0"}'`

#modprobe -r pcspkr

export SQL_ALERT="select 'rm ~/alert*.log; ln -s ' || a.VALUE ||'/alert_' ||b.instance_name ||'.log ~/' alert_path from V\$DIAG_INFO a,v\$instance b where a.name='Diag Trace';"

function SET_SID {
export ORACLE_SID=$1
}

alias ls='ls --color=none'
alias ll='ls -la --color=none'

alias p='rlwrap sqlplus "/ as sysdba"'
alias r='rlwrap rman target=/'
alias d='rlwrap dgmgrl /'
alias h='cd $ORACLE_HOME'
alias st='lsnrctl status'
alias l='ps -ef | grep lgwr'
alias e='env | grep ORA'
alias op='$ORACLE_HOME/OPatch/opatch'
alias al='echo $SQL_ALERT | sqlplus -s "/ as sysdba"'
alias adr='rlwrap adrci'
alias sid='SET_SID'
alias glog='vi $ORACLE_HOME/sqlplus/admin/glogin.sql'