Changing value of DIAGNOSTIC_DEST in a NON-RAC Oracle Database.
Problem Summary
---------------------------------------------------
How do we change DIAGNOSTIC_DEST for alert, cdump, incident and trace without shutdown / restart
Problem Description
---------------------------------------------------
The DIAGNOSTIC_DEST is /u01/app/oracle/diag/rdbms/bob/bob
Our trace, alert and dump files are in subdirectories under this.
We need to change the location of DIAGNOSTIC_DEST so that our trace, alert, dump files are written to this new location.
New location: /u02/bob
Under /u02/bob we have created trace, alert, incident and cdump subdirectories.
IF we issue the command:
"alter system set diagnostic_dest = '/u02/bob' scope=both;"
Will this change the DIAGNOSTIC_DEST for our CDB and PDBs ???