AGILE9_STARTUP_TRG Is Not Compiled When Upgrading Oracle Database to 12c (Doc ID 2155274.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Agile PLM Framework - Version 9.3.3.0 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior

When upgrading Database from 11g to 12c, AGILE9_STARTUP_TRG would not be compiled as part of the ulrp utility (which is a utility to compile all invalid objects in the data dictionary).
This will cause Oracle Database fail to start.


Expected Behavior

When upgrading Database from 11g to 12c, AGILE9_STARTUP_TRG trigger to be compiled properly.
If the trigger itself is unneeded, have the trigger to be removed or disabled from Agile schema

Steps to Reproduce

1. On Agile database server, upgrade Oracle Database from 11g to 12c
2. Check the status of AGILE9_STARTUP_TRG in Agile schema

Changes

 Upgraded Oracle Database to 12c

Cause

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