Rel 12.2 Driver fails at pydccore.sql

ATTENTION: All workers either have failed or are waiting:

                  FAILED: file pydccore.sql on worker  3.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Start time for file is: Fri Mar 31 2023 14:07:52

sqlplus -s APPS/***** @/dodiapps/rgp6/rgp6apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql ‘/dodiapps/rgp6/rgp6apps/fs1/EBSapps/appl/pay/12.0.0/patch/115/sql/pydccore.sql &un_pay &pw_pay &index_tspace’

Connected.

PL/SQL procedure successfully completed.

declare

*

ERROR at line 1:

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

ORA-06512: at “SYS.DBMS_SQL”, line 1134

ORA-06512: at line 563

FIX: Checked blocking sessions in the database and found NONE. Restarted Failed Worker using adctrl option 2 Tell worker to restart a failed job and it completed  

Unknown's avatar

Published by heemasatapathy

Heema is an Oracle Ace Pro, IEEE Senior Member, and experienced speaker at both local and international IT conferences. With two decades of hands-on experience as a senior DBA and Solution Architect, Heema is adept at database administration and eager to embrace new technologies. Known for being customer-focused, organized, and self-motivated, Heema has a strong track record in managing technical projects and communicating solutions effectively. His global IT experience spans India, Japan, Malaysia, Singapore, Switzerland, and the USA. He holds a Bachelor of Engineering degree with Honors.

Leave a comment