Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

TimeZone fails - Is it possible to plug database

Hi,

I upgrade database from

11.2.0.9 --> 19.13

when upgrading timezone it fails on (trigger for apex module

Table list: "APEX_040200"."WWV_FLOW_FEEDBACK"

DECLARE

*

ERROR at line 1:

ORA-04098: trigger 'APEX_040200.WWV_FLOW_FEEDBACK_T1' is invalid and failed

SQL> select PROPERTY_NAME,property_value value FROM DATABASE_PROPERTIES

 WHERE PROPERTY_NAME LIKE 'DST%' ORDER BY PROPERTY_NAME;

 PROPERTY_NAME   VALUE

--------------------------------------------------------------------------------

DST_PRIMARY_TT_VERSION   32

DST_SECONDARY_TT_VERSION  10  <<<<

DST_UPGRADE_STATE   UPGRADE

**/

is it possible to progress and to plug database as PDB and later I reexecute upgrade timezone programme


regards

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center