S
S
sswwssww2020-11-02 09:26:04
Oracle
sswwssww, 2020-11-02 09:26:04

What causes the ORA-02002 error?

When importing a .dmp dump file into another database using the impdp utility, an error began to occur:

Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-02002: error while writing to audit trail
ORA-00600: internal error code, arguments: [ktliFlsToLobWrtCbk_4], [311], [1024], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SQL", line 1185
ORA-06512: at "SYS.KUPW$WORKER", line 22791
ORA-06512: at "SYS.KUPW$WORKER", line 21996
ORA-06512: at "SYS.KUPW$WORKER", line 21553
ORA-06512: at "SYS.KUPW$WORKER", line 4516
ORA-06512: at "SYS.KUPW$WORKER", line 12063
ORA-06512: at "SYS.KUPW$WORKER", line 2081
ORA-06512: at line 2
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 2 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-02002: error while writing to audit trail
ORA-00600: internal error code, arguments: [ktliFlsToLobWrtCbk_4], [331], [1061], [], [], [], [], [], [], [], [], []

Expanding the SYSTEM tablespace does not help.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
E
Eugene, 2020-11-02
@sswwssww

What DB version?
ORA-600 indicates a bug, apparently https://support.oracle.com/epmos/faces/DocumentDis... (Metalink access required).
Set the parameters
AUDIT_SYS_OPERATIONS = FALSE
AUDIT_TRAIL=NONE
for the duration of the import, and then return to the previous values. You may need to restart the instance.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question