5 Replies Latest reply on Apr 11, 2019 10:16 AM by Kanda-Oracle

    Apply the Latest AD and TXK Release Update Packs for Release 12.2

    Beauty_and_dBest

      Ugrading 12.0.6 to 12.2.7

      Db is already 12.1.0.2

       

       

       

      Hi ALL,

       

      We have finished installing 12.2.0

       

      We are now in steps:

       

       

      Preparation steps to Upgrade EBS 12.2.0 to 12.2.7

       

      Set the following database parameter,

      SQL> alter system set optimizer_adaptive_features=false;

      Run adgrants.sql and recreate grants and synonyms

      Execute adgrants.sql from patch 27405878 and then recreate grants and synonyms from adadmin (Choose option 4 and then 2 from adadmin)

      (Source RUN file system env)

      Apply the Latest AD and TXK Release Update Packs for Release 12.2:

      Upgrade AD to latest code level (R12.AD.C.Delta.10),

      Patch 25820806 (R12.AD.C.Delta.10)

      Patch 26720905:R12.AD.C

      $ cd /crpapp/crp/apps/fs_ne/EBSapps/patch

      $ unzip /crpapp/patches/patches_1227_prereq/p25820806_R12.AD.C_R12_LINUX.zip

      $ unzip /crpapp/patches/patches_1227_prereq/p26720905_R12.AD.C_R12_GENERIC.zip

       

      Apply both AD patches

      Start adminserver from run fs

      $ cd $ADMIN_SCRIPTS_HOME

      $ adadminsrvctl.sh start

      Apply AD patches separately,

      $ cd /crpapp/crp/apps/fs_ne/EBSapps/patch

      $ adop phase=apply patches=25820806 hotpatch=yes

      $ adop phase=apply patches=26720905 hotpatch=yes

       

       

      Patch  25820806 is successful,  but patch 26720905 has error

       

      [applmgr@oraapps UPGRADE_PATCH_APP]$ adop phase=apply patches=26720905 hotpatch=yes patchtop=/mnt/UPGRADE_PATCH_APP

       

      Enter the APPS password:

      Enter the SYSTEM password:

      Enter the WLSADMIN password:

       

      Validating credentials.

       

      Initializing.

          Run Edition context  : /mnt/applmgr/PPAPROD/fs1/inst/apps/PPAPROD_oraapps/appl/admin/PPAPROD_oraapps.xml

          Patch edition context: /mnt/applmgr/PPAPROD/fs2/inst/apps/PPAPROD_oraapps/appl/admin/PPAPROD_oraapps.xml

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

      PROGRAM : (/mnt/applmgr/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)

      TIME    : Thu Apr 11 16:52:25 2019

      FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]

      MESSAGES:

      SQLPLUS error: buffer=

       

      SQL*Plus: Release 10.1.0.5.0 - Production on Thu Apr 11 16:52:25 2019

       

      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

       

      SQL> SQL> Connected.

      SQL>     from fnd_nodes fn, adop_valid_nodes avn

                                 *

      ERROR at line 3:

      ORA-00942: table or view does not exist

       

       

      Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

       

       

       

      STACK TRACE

      at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168

          TXK::Error::abort('TXK::Error', 'HASH(0x1a45e68)') called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299

          TXK::Common::doError('TXK::SQLPLUS=HASH(0x3eeb558)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...', undef) called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314

          TXK::Common::setError('TXK::SQLPLUS=HASH(0x3eeb558)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...') called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832

          TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x3eeb558)', 0) called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 234

          TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x3eeb558)', 'HASH(0x42475b8)') called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 618

          TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x3a57678)', '      select count(1)  from\x{a}      ( select distinct fn.host\x{a} ...') called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 573

          TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x3a57678)', '      select count(1)  from\x{a}      ( select distinct fn.host\x{a} ...') called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 1219

          ADOP::GlobalVars::_GetMandatoryArgs() called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 3112

          ADOP::GlobalVars::ValidateArgs('ADOP::GlobalVars') called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/AdopMain.pm line 1842

          ADOP::AdopMain::adopMain('ADOP::AdopMain') called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 148

       

       

      [STATEMENT] Please run adopscanlog utility, using the command

       

      "adopscanlog -latest=yes"

       

       

       

      $  sqlplus / as sysdba

       

      SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 11 17:09:07 2019

       

      Copyright (c) 1982, 2014, Oracle.  All rights reserved.

       

       

      Connected to:

      Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

       

      SQL> select * from dba_objects where object_name = 'ADOP_VALID_NODES';

       

      no rows selected

       

      SQL>

       

       

       

       

       

      Please help....

       

       

      Kind regards,

      jc

        • 1. Re: Apply the Latest AD and TXK Release Update Packs for Release 12.2
          Beauty_and_dBest

          Hi ALL,

           

          My adop_valid_nodes.xdf version is:

           

           

          [applmgr@oraapps xdf]$ head -rwxr-xr-x 1 applmgr dba 22530 Apr 11 16:42 adop_valid_nodes.xdf

          head: invalid option -- 'r'

          Try `head --help' for more information.

          [applmgr@oraapps xdf]$ head adop_valid_nodes.xdf

          <?xml version="1.0"?>

          <!-- +======================================================================+ -->

          <!-- |    Copyright (c) 2014, 2016 Oracle and/or its affiliates.            | -->

          <!-- |                         All rights reserved.                         | -->

          <!-- |                           Version 12.0.0                             | -->

          <!-- +======================================================================+ -->

          <!-- $Header: adop_valid_nodes.xdf 120.0.12020000.6 2016/04/18 10:16:37 seetsing noship $ -->

          <!--

          The following dbdrv hint(s) are auto-generated by the FndXdfGen utility.

          If you need additional dbdrv hints or wish to modify the existing hints

          [applmgr@oraapps xdf]$ pwd

          /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/fnd/12.0.0/patch/115/xdf

           

           

          I also searched which patch has it:

           

          [applmgr@oraapps UPGRADE_PATCH_APP]$ find . -name adop_valid_nodes.xdf -print

          ./25828573/fnd/patch/115/xdf/adop_valid_nodes.xdf

          ./25820806/fnd/patch/115/xdf/adop_valid_nodes.xdf

          [applmgr@oraapps UPGRADE_PATCH_APP]$ head ./25828573/fnd/patch/115/xdf/adop_valid_nodes.xdf

          <?xml version="1.0"?>

          <!-- +======================================================================+ -->

          <!-- |    Copyright (c) 2014, 2014 Oracle and/or its affiliates.            | -->

          <!-- |                         All rights reserved.                         | -->

          <!-- |                           Version 12.0.0                             | -->

          <!-- +======================================================================+ -->

          <!-- $Header: adop_valid_nodes.xdf 120.0.12020000.3 2014/03/25 10:06:30 sbandla noship $ -->

           

          <!--

          The following dbdrv hint(s) are auto-generated by the FndXdfGen utility.

          [applmgr@oraapps UPGRADE_PATCH_APP]$ head ./25820806/fnd/patch/115/xdf/adop_valid_nodes.xdf

          <?xml version="1.0"?>

          <!-- +======================================================================+ -->

          <!-- |    Copyright (c) 2014, 2016 Oracle and/or its affiliates.            | -->

          <!-- |                         All rights reserved.                         | -->

          <!-- |                           Version 12.0.0                             | -->

          <!-- +======================================================================+ -->

          <!-- $Header: adop_valid_nodes.xdf 120.0.12020000.6 2016/04/18 10:16:37 seetsing noship $ -->

          <!--

          The following dbdrv hint(s) are auto-generated by the FndXdfGen utility.

          If you need additional dbdrv hints or wish to modify the existing hints

          [applmgr@oraapps UPGRADE_PATCH_APP]$

           

           

          Please help....

           

          Kind regards,

          • 2. Re: Apply the Latest AD and TXK Release Update Packs for Release 12.2
            Kanda-Oracle

            Hi JC,

             

            It could be due to the online enablement patch failures ..Did you have any such failures during adpatch?

             

            Thanks


            N Kandasamy

            • 3. Re: Apply the Latest AD and TXK Release Update Packs for Release 12.2
              Beauty_and_dBest

              Hi ALL,

               

              I tried to recreate the table ADOP_VALID_NODES using > ADOP Exiting With Status = 9 (Fail) ORA-04043 On ADOP_VALID_NODES Table (Doc ID 2230021.1)

               

              adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp applsys <Password> apps <Password> thin \

              <hostname>:<db_port>:<db_sid> table $FND_TOP/patch/115/xdf/adop_valid_nodes.xdf $FND_TOP/patch/115/xdf/xsl changedb=yes logfile=/tmp/FndXdfCmp.out

               

              But I got error:

              Error: Editions are not enabled for table owner "APPLSYS", but the table "ADOP_VALID_NODES" definition contains revised columns.

               

               

              Please help...

               

               

              Kind regards,

              • 4. Re: Apply the Latest AD and TXK Release Update Packs for Release 12.2
                Beauty_and_dBest

                Hi Kanda,

                 

                We encountered several failures on same issue:

                 

                sqlplus -s APPS/***** @/mnt/applmgr/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/mnt/applmgr/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsstats.sql '

                Connected.

                 

                PL/SQL procedure successfully completed.

                 

                declare

                *

                ERROR at line 1:

                ORA-20000: ORA-20001: APPS.GL_DSC_ACRONYM is an invalid identifier Error while

                executing

                FND_STATS.GATHER_SCHEMA_STATISTICS package.

                ORA-06512: at line 98

                 

                 

                And we just skip the failed worker

                 

                 

                Kind regards,

                • 5. Re: Apply the Latest AD and TXK Release Update Packs for Release 12.2
                  Kanda-Oracle

                  Hi JC

                   

                  To get a clue if any failures cause this issue; Can you look for "Errors" in the log file.

                   

                  • Can you grep (with adop_valid_nodes) the adpatch & adwork logs files
                  • Can you grep (with adop) the adpatch & adwork logs files

                   

                  Thanks!