Tuesday, February 08, 2011

diagnostic_dest, ADR_BASE_LISTENER, ADR_BASE


Changing the default location of logs and trace files in 11g

setting the diagnostic destination for 11gR2 servers to /oramisc01/oracle -

Make the following changes:

/ora01/oracle/admin/network/sqlnet.ora - added the line 'ADR_BASE=/oramisc01/oracle'
/ora01/oracle/admin/network/listener.ora - added the line 'ADR_BASE_LISTENER=/oramisc01/oracle'  
   (may not take effect until the listener is restarted or reloaded)
ASM instance - set the init value 'diagnostic_dest='/oramisc01/oracle'
Database – set the init value 'diagnostic_dest='/oramisc01/oracle'

Agent11gHome/network/admin/sqlnet.ora - added the line 'ADR_BASE=/oramisc01/oracle'

Hope this helps! Rupam