Location of diagnostic directories in 11g
Posted by John Hallas on April 3, 2009
Since the advent of 11g and the use of diagnostic_dest there is no requirement to create the bdump/cdump/udump and other directories required for oracle trace and admin files. Well, that is true if you are happy to accept the default location under $ORACLE_BASE. However the path to the trace area where alert logs and dump files are kept is a long one and I prefer to use an alias to get there.
In the .profile I set up two aliases to point to the trace areas for ASM and whichever database my current SID is set to
alias diagdest=’cd $ORACLE_BASE/`adrci exec=”show homes” | grep $ORACLE_SID`/trace’
alias diagdestasm=’cd $ORACLE_BASE/`adrci exec=”show homes” | grep ASM`/trace’
I am sure there are other ways of setting a similar alias and I am happy to hear of any that others use