Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

 Issue# 33:

When restarting 12.2.6 upgrade patch:

*******FATAL ERROR*******

PROGRAM : (/oracle/12.2/DPRO/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)

TIME    : Mon Apr 24 22:32:40 2017

FUNCTION: ADOP::GlobalVars::_GetMandatoryArgs [ Level 1 ]

ERRORMSG: Cannot identify any valid application tier nodes in

          ADOP_VALID_NODES table. Ensure AutoConfig has been run on all nodes.

 

Solution:

Restarting 12.2.X patch fails with "ERRORMSG: Cannot identify any valid application tier nodes/ORA-01400: Cannot Insert NULL Into ("APPLSYS"."FND_NODES"."NODE_NAME")" (Doc ID 2112122.1)

 

SQL> conn apps/apps

Connected.

SQL>

 

SQL> drop synonym apps.fnd_nodes;

 

Synonym dropped.

 

SQL> create synonym apps.fnd_nodes for applsys.fnd_nodes;

 

Synonym created.

 

SQL> drop synonym apps.fnd_oam_context_files;

 

Synonym dropped.

 

SQL> create synonym apps.fnd_oam_context_files for applsys.fnd_oam_context_files;

 

Synonym created.

 

SQL>

 

-          Restart the patch

{ echo apps; echo manager; echo weblogic1; }|adop phase=apply apply_mode=downtime patches=21900901 restart=yes abandon=no