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

MOSC Banner

Regarding ADRCI Retention Policy

Hi Oracle..!

Am trying to change the retention policy for short_policy and long_policy in ADRCI. After changing the retention still default values are reflecting when execute show control from ADRCI >

adrci> set home diag\tnslsnr\XXXXXXX\listener

adrci>

adrci> show control

ADR Home = e:\oracle\diag\tnslsnr\XXXXXXXX\listener:

*************************************************************************

ADRID                SHORTP_POLICY        LONGP_POLICY         LAST_MOD_TIME                            LAST_AUTOPRG_TIME                        LAST_

MANUPRG_TIME                        ADRDIR_VERSION       ADRSCHM_VERSION      ADRSCHMV_SUMMARY     ADRALERT_VERSION     CREATE_TIME

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

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

----------

595276086            720                  8760                 2011-10-27 12:59:19.961000 -04:00

                                    1                    2                    76                   1                    2011-10-27 12:59:19.961000 -04

:00

1 rows fetched

adrci> set control (SHORTP_POLICY=1440);

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