Hello Everyone,
impdp giving below error.I have checked oracle documentation 1907256.1 and 308388.1.
No invalid objects, still getting issues.Please help.
UDI-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3905
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5203
ORA-06512: at line 1
SQL> SELECT comp_name, status, version
FROM dba_registry; 2
COMP_NAME STATUS VERSION
----------------------------------- --------- ------------
Oracle Database Vault VALID 12.1.0.2.0
Oracle Label Security VALID 12.1.0.2.0
Spatial VALID 12.1.0.2.0
Oracle Multimedia VALID 12.1.0.2.0
Oracle Text VALID 12.1.0.2.0
Oracle Workspace Manager VALID 12.1.0.2.0
Oracle XML Database VALID 12.1.0.2.0
Oracle Database Catalog Views VALID 12.1.0.2.0
Oracle Database Packages and Types VALID 12.1.0.2.0
JServer JAVA Virtual Machine VALID 12.1.0.2.0
Oracle XDK VALID 12.1.0.2.0
COMP_NAME STATUS VERSION
----------------------------------- --------- ------------
Oracle Database Java Packages VALID 12.1.0.2.0
OLAP Analytic Workspace VALID 12.1.0.2.0
Oracle OLAP API VALID 12.1.0.2.0
Oracle Real Application Clusters VALID 12.1.0.2.0
SQL> select * from all_errors where OWNER='SYS' and NAME like 'AQ$%';
no rows selected
SQL> show parameter aq_tm_processes
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
SQL>
SQL>
SQL> show parameter streams_pool_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size big integer 1G
SQL>
SQL>
SQL> show parameter cluster_database
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
SQL>