Grid
export PS1='\[\e[1;31m\][\u@\h \W]\$\[\e[0m\] ' export ORACLE_SID=$(cat /etc/oratab| grep -i asm | grep -v "^#" |awk -F: '{print $1}' ) export ORAENV_ASK=NO . oraenv export ORAENV_ASK=YES alias sqlplus='rlwrap sqlplus' alias lsnrctl='rlwrap lsnrctl' alias rman='rlwrap rman' alias asmcmd='rlwrap asmcmd' alias adrci='rlwrap adrci' alias dgmgrl='rlwrap dgmgrl'
Oracle:
export PS1='\[\e[1;32m\][\u@\h \W]\$\[\e[0m\] ' export EDITOR=vim export ORACLE_SID=$(cat /etc/oratab | grep -v "^#" | grep -iv asm |grep -v -e '^$' | awk -F: '{print $1}' ) export ORAENV_ASK=NO . oraenv export ORAENV_ASK=YES alias sqlplus='rlwrap sqlplus' alias lsnrctl='rlwrap lsnrctl' alias rman='rlwrap rman' alias asmcmd='rlwrap asmcmd' alias adrci='rlwrap adrci' alias dgmgrl='rlwrap dgmgrl'