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

 

 

 

arrow
arrow
    全站熱搜

    DanBrother 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄