SCRIPT: Additional De-installation Instructions for DBMS_AUDIT_MGMT
(Doc ID 731019.1)
Last updated on OCTOBER 10, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
You have applied <patch 6023472> or any of the other patches that introduce the DBMS_AUDIT_MGMT package for the first time but then you want to do a rollback, however there is no proper procedure for reverting the changes to the data dictionary. The deinstallation instructions in the associated READMEs may instruct to run some scripts (?/rdbms/admin/catamgt.sql, ?/rdbms/admin/dbmsamgt.sql, ?/rdbms/admin/prvtamgt.plb) but these files will not exist after a rollback with opatch.
As of database version 11.1.0.7 the DBMS_AUDIT_MGMT is part of the installed pl/sql packages and so it cannot be de-installed anymore.
Changes
You want to de-install the DBMS_AUDIT_MGMT package rolling back any patch that installed it such as Patch 6023472.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |