Parallel slave terminated with error
From: Lok P <loknath.73_at_gmail.com>
Date: Sat, 2 Jul 2022 01:13:49 +0530
Message-ID: <CAKna9VY5CwQKjOYuVFbm2yXk7nijvCH1OoS0sYUY6tTuKFV23Q_at_mail.gmail.com>
Hello All, We are seeing below error for one of our procedure execution and later the rerun completing successfully. It happened many times. The error says one of the parallel slave getting terminated but doesn't say anything about what exact Ora- error caused the parallel slave to terminate.
Date: Sat, 2 Jul 2022 01:13:49 +0530
Message-ID: <CAKna9VY5CwQKjOYuVFbm2yXk7nijvCH1OoS0sYUY6tTuKFV23Q_at_mail.gmail.com>
Hello All, We are seeing below error for one of our procedure execution and later the rerun completing successfully. It happened many times. The error says one of the parallel slave getting terminated but doesn't say anything about what exact Ora- error caused the parallel slave to terminate.
We were thinking if we will get the parallel slave failure details automatically logged in the trace, but we didn't see anything in the trace file either when searched with *12801*. Any way to find the exact cause of this failure here?
ORA-20001: ORA-12801: error signaled in parallel query server P005, instance db01.App1.com:App1u Error Code: -12801
ORA-06512: at "APP_USER.APP1_SP", line 881
ORA-06512: at line 2
The line-881 in the procedure is pointing to inside 'raise application error', so it doesn't state the exact statement which failed, but anyway even if we will get the statement we need to understand what exact error is causing the parallel slave to get terminated.
--http://www.freelists.org/webpage/oracle-l Received on Fri Jul 01 2022 - 21:43:49 CEST