SCRIPT: Additional De-installation Instructions for DBMS_AUDIT_MGMT

(Doc ID 731019.1)

Last updated on NOVEMBER 09, 2015

Applies to:

Oracle Server - Enterprise Edition - Version:
Information in this document applies to any platform.


You have applied <> 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 the DBMS_AUDIT_MGMT is part of the installed pl/sql packages and so it cannot be de-installed anymore.


You want to de-install the DBMS_AUDIT_MGMT package rolling back any patch that installed it such as Patch 6023472.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms