AGILE9_STARTUP_TRG Is Not Compiled When Upgrading Oracle Database to 12c
Last updated on MARCH 08, 2017
Applies to:Oracle Agile PLM Framework - Version 22.214.171.124 and later
Information in this document applies to any platform.
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.
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
Upgraded Oracle Database to 12c
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