UDE-00008: operation generated ORACLE error 3113

Issue :- 
Export backup is failed due to below error.

Error:-
UDE-00008: operation generated ORACLE error 3113

ORA-03113: end-of-file on communication channel

Cause:-
The initialization parameter AQ_TM_PROCESSES is set to 0
Datapump uses  Advanced Queueing and needs this parameter to be set higher then 0.

Solution:-

Need to set advance queuing parameter to 1.

Also Make sure that you have enough RAM and paging space on your system

In my case , I had ran export using parallel=3 & faced above issue

if possible , Do not run export using parallel process.

Current Value for :-
NAME               TYPE        VALUE
------------------ ----------- -------
aq_tm_processes    integer     0

Updated Value:-
NAME               TYPE        VALUE
------------------ ----------- -------
aq_tm_processes    integer     1

No comments:

Post a Comment