My Oracle Support Banner

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

Last updated on DECEMBER 05, 2019

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.


Patch is failing with error :


sqlplus -s APPS user/password = <PASSWORD> @<$AR_TOP>/12.0.0/patch/115/sql/<SERVICE NAME>
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():nodename = <NODE NAME>

 Status from adctrl:

Enter your choice [1] :

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.





To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.