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.
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