Change Location of Alert Log/Trace File Oracle 11g

SQL> show parameter diag

Above command will show the Alert file and trace location.

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest                      string      /oracle/app/oracle

SQL> Alter System Set Diagnostic_Dest=' /oracle/app/oracle/tracedest';

It will change the Trace Files location.

SQL> show parameter diag

 NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest                      string      /oracle/app/oracle/tracedest

Comments