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

 

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

 Issue# 32:

While running 12.2.6 patch

ATTENTION: All workers either have failed or are waiting:

 

                   FAILED: file OE_ORDERORG_GTT.sql on worker  1.

                   FAILED: file OE_SCHEDULE_LINES_TEMP.sql on worker  2.

 

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

 

 

Worker log:

sqlplus -s APPS/***** @/oracle/12.2/DPRO/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/oracle/12.2/DPRO/fs1/EBSapps/appl/ont/12.0.0/patch/115/sql/OE_ORDERORG_GTT.sql &un_ont'

Connected.

 

PL/SQL procedure successfully completed.

 

DECLARE

*

ERROR at line 1:

ORA-01403: no data found

ORA-06512: at "SYSTEM.AD_DDL", line 188

ORA-06512: at line 33

 

 

sqlplus -s APPS/***** @/oracle/12.2/DPRO/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/oracle/12.2/DPRO/fs1/EBSapps/appl/ont/12.0.0/patch/115/sql/OE_SCHEDULE_LINES_TEMP.sql &un_ont'

Connected.

 

PL/SQL procedure successfully completed.

 

DECLARE

*

ERROR at line 1:

ORA-01403: no data found

ORA-06512: at "SYSTEM.AD_DDL", line 188

ORA-06512: at line 33

 

Solution:

SQL> conn apps/apps

Connected.

SQL> select install_group_num from apps.fnd_oracle_userid where oracle_username ='APPS';

 

INSTALL_GROUP_NUM

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

                                0

 

SQL> update fnd_oracle_userid set install_group_num=1 where oracle_username = 'APPS';

 

1 row updated.

 

SQL> commit;

 

Commit complete.

 

SQL>

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

 Issue# 31:

While applying AD or TXK patches after enabling online patching:

 

sh: module: line 1: syntax error: unexpected end of file

sh: error importing function definition for `BASH_FUNC_module'

 

Solution:

R12.2 Errors Running adadminsrvctl.sh with 'sh: module: line 1: Syntax Error: Unexpected End Of File' or 'Importing Function Definition for `BASH_FUNC_module'' On Oracle Linux 6 64-bit (Doc ID 1595052.1)

 

Connect as root:

mv /etc/profile.d/modules.sh /etc/profile.d/modules.sh.bkup