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

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

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.

Leave a Reply