Oracle in our Office: Unable to flush restart file in aiurof()

While doing adpatch for HRMS RUP 6 patch (16000686) in R12.1.3 instance, I could see that the patch session was frozen.

I tried the usual checks on the database node to see if there was any space issue or if the archive log destination is full, but there were no problem from that side.

I then looked at adctrl

Adctrl was bringing the below.

Enter your choice [1] :

Control

Worker Code Context Filename Status

------ -------- ----------------- -------------------------- --------------

1 Run AutoPatch R120 Wait

2 Run AutoPatch R120 Wait

3 Run AutoPatch R120 Wait

4 Run AutoPatch R120 Wait

5 Run AutoPatch R120 Wait

6 Run AutoPatch R120 Wait

7 Run AutoPatch R120 Wait

8 Run AutoPatch R120 Wait

9 Run AutoPatch R120 Wait

10 Run AutoPatch R120 Wait

11 Run AutoPatch R120 Wait

12 Run AutoPatch R120 Wait

13 Run AutoPatch R120 Wait

14 Run AutoPatch R120 Wait

15 Run AutoPatch R120 Wait

16 Run AutoPatch R120 Wait

17 Run AutoPatch R120 Wait

18 Run AutoPatch R120 Wait

19 Run AutoPatch R120 Wait

20 Run AutoPatch R120 Wait

21 Run AutoPatch R120 Wait

22 Run AutoPatch R120 Wait

23 Run AutoPatch R120 Wait

24 Run AutoPatch R120 Wait

25 Run AutoPatch R120 Wait

26 Run AutoPatch R120 Wait

27 Run AutoPatch R120 Wait

28 Run AutoPatch R120 Wait

29 Run AutoPatch R120 Wait

30 Run AutoPatch R120 Wait

31 Run AutoPatch R120 Wait

32 Run AutoPatch R120 gh52doup.pkb Assigned

I looked at what is there in the worker 32.

cd $APPL_TOP/admin/$TWO_TASK/log

tail -100 adwork032.log | more

Below is the log.

Time when worker started job: Wed Jul 17 2013 17:16:01

Start time for file is: Wed Jul 17 2013 17:16:01

package /u01/PATC/oracle/apps/apps_st/appl/ben/12.0.0/patch/115/sql/bendsgel.pkb

Done deactivating PL/SQL compilation.

Statement executed.

Done resetting PL/SQL compilation.

Time when worker completed job: Wed Jul 17 2013 17:16:01

Time when worker started job: Wed Jul 17 2013 17:16:02

AD Worker error:

Unable to flush restart file in aiurof()

Error opening worker restart file in aijwro().

Time when worker failed: Wed Jul 17 2013 17:16:02

AD Worker is complete.

Errors and warnings are listed in the log file

/u01/PATC/oracle/apps/apps_st/appl/admin/EBSPATCH/log/adwork032.log

and in other log files in the same directory.

-------------------

So, I went back to adctrl, and did the command to restart the worker 32.

AD Controller Menu

---------------------------------------------------

1. Show worker status

2. Tell worker to restart a failed job

3. Tell worker to quit

4. Tell manager that a worker failed its job

5. Tell manager that a worker acknowledges quit

6. Restart a worker on the current machine

7. Exit

Enter your choice [1] : 6

You chose 6 - Restart a worker on the current machine.

Before you enter the worker number below, make sure that there is no

worker process already running with that worker number.

Enter the worker number(s)/range(s) or 'all' for all workers,

or press [Return] to go back to the menu : 32

Control code changed to 'Startup' for worker 32.

Review the messages above, then press [Return] to continue.