Database Administration (MOSC)

MOSC Banner

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 ???

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center