How to change diagnostic_dest path

Applies to

Oracle 11g and later.

Solution:

SQL> show parameter diag
NAME TYPE VALUE
------------------------------------ ----------- -----------------
diagnostic_dest string /home/oracle/app

SQL> !mkdir /home/oracle/app/indy

SQL> alter system set diagnostic_dest='/home/oracle/app/indy';
System altered.

SQL> show parameter diagnostic
NAME TYPE VALUE
-------------------------------- ----------- -----------------
diagnostic_dest string /home/oracle/app/indy

all sub directories will create automatically. 

1 comment: