My Oracle Support Banner

Configuration Controls Governor 5.5.x - Change Tracking Triggers Disable/Delete (Doc ID 1083861.1)

Last updated on OCTOBER 10, 2023

Applies to:

Oracle Configuration Controls Governor - Version 5.5.1 and later
Information in this document applies to any platform.

Goal

This document addresses the general guidelines and steps to be taken for Configuration Controls Governor (CCG) triggers while implementing database patches in Oracle R12.1 environment.

Question:
In order to properly implement database patches in a Oracle R12.1 environment, all triggers need to be removed. The Configuration Controls Governor (CCG) change tracking process creates triggers on the tables that are to be monitored. As a result, the patching process will require the removal of all CCG change tracking triggers, and then reapply them once the environment is back online. What is the best practice for removal and recreation of these CCG triggers?


Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.