Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

DBMS_AQ_SYS_IMP_INTERNAL invalid after converting 19.13 noncdb to 21.x pdb

edited Nov 30, 2022 2:15PM in Database Install/Upgrade/Opatch (MOSC) 2 commentsQuestion

We are migrating from 19.13 to 21c. The 19.13 DB is a noncdb. The 21c is a CDB.

We are using the following steps:

1) CREATE PLUGGABLE DATABASE FROM DB@clone_link

2) catctl.pl

3) noncdb_to_pdb.sql

4) utlrp.sql


Everything is fine after the migration, except for DBMS_AQ_SYS_IMP_INTERNAL:

alter package DBMS_AQ_SYS_IMP_INTERNAL compile body;

Warning: Package Body altered with compilation errors.

show errors

Errors for PACKAGE BODY DBMS_AQ_SYS_IMP_INTERNAL:

LINE/COL ERROR

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

2344/4 PL/SQL: SQL Statement ignored

2353/37 PL/SQL: ORA-00932: inconsistent datatypes: expected NUMBER got

TIMESTAMP WITH TIME ZONE


DBMS_AQ_SYS_IMP_INTERNAL is VALID in the source database.

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