DanBrother的部落格

Fast switch to BDUMP (Background Dump or Diag Trace) Directory using Linux Function in Oracle RAC environment

/shared_dir/script/dba_functions
>>

# Switch to bdump directory
function tobdump {
lower_sid=$(echo "$ORACLE_UNQNAME" | tr '[:upper:]' '[:lower:]')
cd $ORACLE_BASE/diag/rdbms/$lower_sid/$ORACLE_SID/trace
pwd
}

/home/oracle/.bash_profile
>>
alias oradb1='export ORACLE_SID=DB11 export ORACLE_UNQNAME=DB1'
alias oradb2='export ORACLE_SID=DB21 export ORACLE_UNQNAME=DB2'

/home/oracle/.bashrc
>>
. /shared_dir/script/dba_functions

$ oradb1
$ tobdump
/oracle/diag/rdbms/db1/DB11/trace

$ oradb2
$ tobdump
/oracle/diag/rdbms/db2/DB21/trace