How to change adrci diagnostics destination in 11g.
Steps :
- sqlplus as sysdba
- check current diagonostic destination
sql> show parameter diag
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest string /ora01/oracle
- Change diagnostic_dest
alter system set diagnostic_dest=’ /oradump/oracle’ scope=both sid=’*’;
Note : This will create directories and subdirectories under /oradump/oracle, such as
/oradump/oracle/diag/rdbms/demo
- check changed diagonostic destination
sql> show parameter diag
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest string /oradump/oracle
Hope this help. Regards Rupam
