cat >> /etc/profile
cat >> ~/.bash_profile
cat >> ~/.bashrc
RAC
alias sqln="rlwrap sqlplus / nolog"
alias rman="rlwrap rman target /"
alias dba="rlwrap sqlplus / as sysdba"
alias pmon="ps -ef | grep pmon"
alias ohome="cd $ORACLE_HOME"
alias obase="cd $ORACLE_BASE"
alias dbs="cd $ORACLE_HOME/dbs"
alias tns="cd $ORACLE_HOME/network/admin"
alias cdump="cd $ORACLE_BASE/diag/rdbms/${ORACLE_SID:0:$((${#ORACLE_SID}-1))}/$ORACLE_SID/trace"
单实例
alias sqln="rlwrap sqlplus / nolog"
alias rman="rlwrap rman target /"
alias dba="rlwrap sqlplus / as sysdba"
alias pmon="ps -ef | grep pmon"
alias ohome="cd $ORACLE_HOME"
alias obase="cd $ORACLE_BASE"
alias dbs="cd $ORACLE_HOME/dbs"
alias tns="cd $ORACLE_HOME/network/admin"
alias cdump="cd $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace"