Unable To Control A Patch Using Adctrl, Getting UNDEF For All Workers (Doc ID 1667094.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Patch is failing with error :

...

sqlplus -s APPS/***** @<$AR_TOP>/12.0.0/patch/115/sql/ar120girpu.sql &un_gl &batchsize 7 16
Connected.
DECLARE
*
ERROR at line 1:
ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 70

...

When opening adctrl to check the Patch status following error occures :

...

APPL_TOP is set to <physical Patch of $APPL_TOP>
Worker process 16 started.
AutoPatch error:
aijmgrStoreNodeName:Error while updating FND_INSTALL_PROCESSES
AutoPatch error:
ORA-01403: no data found
AutoPatch error:
Error: Calling aijmgrStoreNodeName():aijms1

 Status from adctrl:

Enter your choice [1] :


Control
Worker Code Context Filename Status
------ -------- ----------------- -------------------------- --------------
1 Quit UNDEF Wait
2 Quit UNDEF Wait
3 Quit UNDEF Wait
4 Quit UNDEF Wait
5 Quit UNDEF Wait
6 Quit UNDEF Wait
7 Quit UNDEF Wait
8 Quit UNDEF Wait
9 Quit UNDEF Wait
10 Quit UNDEF Wait
11 Quit UNDEF Wait
12 Quit UNDEF Wait
13 Quit UNDEF Wait
14 Quit UNDEF Wait
15 Quit UNDEF Wait
16 Quit UNDEF Wait

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

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms