Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC)

MOSC Banner

Howto enable DIAG when marked as disabled in V$DIAG_INFO?

Howto enable DIAG when marked as disabled in V$DIAG_INFO?

  1* select * from V$DIAG_INFO

SQL> /

   INST_ID NAME                 VALUE                                        CON_ID

---------- -------------------- ---------------------------------------- ----------

         1 Diag Enabled         FALSE                                             0

         1 ADR Base                                                               0

         1 ADR Home                                                               0

         1 Diag Trace           C:\ORACLE\PRODUCT\12.1.0.2\RDBMS\TRACE            0

         1 Diag Alert           C:\ORACLE\PRODUCT\12.1.0.2\RDBMS\TRACE            0

         1 Diag Incident                                                          0

         1 Diag Cdump           E:\BUKAI\diag\rdbms\bukai\bukai\trace             0

         1 Health Monitor                                                         0

         1 Default Trace File                                                     0

         1 Active Problem Count                                                   0

         1 Active Incident Coun                                                   0

   INST_ID NAME                 VALUE                                        CON_ID

---------- -------------------- ---------------------------------------- ----------

           t

11 rows selected.

SQL> show parameter diag

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

diagnostic_dest                      string      E:\BUKAI

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