'ORA-04023: Object SYS.AQ$_REG_INFO could not be validated or authorized
I am using Oracle 19c version 19.3.0.0.0, trying to import a dumpfile from a 12c, using impdp. The 19c is divided in three pluggable databases, but only one is showing the given error.
impdp ****/***@db1 schemas=SCHEMANAME dumpfile=DUMPNAME.dmp logfile=LOGNAME.dmp.log directory=DIRNAME;
When I run the import on this database it gives the error below:
Import: Release 19.0.0.0.0 - Production on Thu Dec 16 14:47:13 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_IMPORT_SCHEMA_01 for user MYUSER
ORA-06512: at "SYS.KUPV$FT", line 1142
ORA-06512: at "SYS.KUPV$FT", line 1744
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 1099
ORA-04045: errors during recompilation/revalidation of SYS.KUPC$QUE_INT
ORA-04023: Object SYS.AQ$_REG_INFO could not be validated or authorized
ORA-06508: PL/SQL: could not find program unit being called: "SYS.KUPC$QUE_INT"
ORA-06512: at "SYS.KUPC$QUEUE_INT", line 493
ORA-06512: at "SYS.KUPV$FT_INT", line 981
ORA-06512: at "SYS.KUPV$FT", line 1646
ORA-06512: at "SYS.KUPV$FT", line 1103
I couldn't find a solution yet, and have already tried failed attempts:
@$ORACLE_HOME/rdbms/admin/catdph.sql
@$ORACLE_HOME/rdbms/admin/dbmspump.sql
@$ORACLE_HOME/rdbms/admin/catdpb.sql
@$ORACLE_HOME/rdbms/admin/dbmspump.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
@$ORACLE_HOME/rdbms/admin/catqueue.sql
@$ORACLE_HOME/rdbms/admin/utlrp.sql
And several attempts end up in the same error as the title of this post.
I would appreciate some help.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|