ORA-39014, ORA-39029, ORA-31671 and ORA-00600 errors in 12c expdp/impdp operations

 

In the 12c databases, ORA-39014 ORA-39029 ORA-31671 and ORA-00600 errors can be received during expdp or impdp operation.

In such a case, existing processes are terminated and errors similar to the following will appear in the alert log file.

“DW00 terminating with fatal err=600”

The possible errors in export and import are as follows.

To solve the problem, the value of the open_cursors parameter should be increased and the value of the parameter “_optimizer_cost_based_transformation” should be set to off.

After the parameter change, the operations will be completed successfully.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

2 comments

  1. Thanks a lot ……. it greatly helps me.

    I faced this while migration from 11.2.0.4 to 12.1.0.2 PDB database , while at the time of importing into 12.1.

Leave a Reply

Your email address will not be published. Required fields are marked *