AGILE9_STARTUP_TRG Is Not Compiled When Upgrading Oracle Database to 12c
(Doc ID 2155274.1)
Last updated on MARCH 08, 2017
Oracle Agile PLM Framework - Version 220.127.116.11 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!