Issue while running the export command:
Export: Release 11.2.0.3.0 - Production on Wed Sep 30 19:34:01 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-00600: internal error code, arguments: [kokle_lob2lob13:input mismatch], [1], [], [], [], [], [], [], [], [], [], []
ORA-39097: Data Pump job encountered unexpected error -600
Export: Release 11.2.0.3.0 - Production on Wed Sep 30 19:34:01 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-00600: internal error code, arguments: [kokle_lob2lob13:input mismatch], [1], [], [], [], [], [], [], [], [], [], []
ORA-39097: Data Pump job encountered unexpected error -600
Cause: JOB_QUEUE_PROCESSES was set to 0
show parameter JOB_QUEUE_PROCESSES
job_queue_processes integer
0
Solution: Modified the parameter and restarted the database.
alter system set JOB_QUEUE_PROCESSES=2 scope=spfile;
show parameter JOB_QUEUE_PROCESSES
job_queue_processes integer
2
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 4710043648 bytes
Fixed Size 2236248 bytes
Variable Size 3758096552 bytes
Database Buffers 838860800 bytes
Redo Buffers 110850048 bytes
Database mounted.
Database opened.
SQL>
Retest the issue it should resolve the expdp error.
No comments:
Post a Comment