4 Replies Latest reply on Aug 13, 2018 2:28 AM by Beauty_and_dBest

    EBS 12.2.7 ADOP prepare error

    Beauty_and_dBest

      EBS 12.2.7

      12c

      OL6

       

      Hi ALL,

       

      I am applying a patch, so I run the first step >  adop phase=prepare

      But I got error below:

       

      ===========================================================================

      ADOP (C.Delta.10)

      Session ID: 7

      Node: test01

      Phase: prepare

      Log: /u02/apppsar/PSAR/fs_ne/EBSapps/log/adop/7/20180810_182847/adop.log

      ===========================================================================

       

      Validating configuration on node: [test01].

          Log: /u02/apppsar/PSAR/fs_ne/EBSapps/log/adop/7/20180810_182847/prepare/validate/test01

          [ERROR]: At least one Oracle inventory check has failed.

          [WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.

          [WARNING]: Either some of the required entries in /etc/hosts file might be missing (e.g. localhost or hostname) OR the file /etc/hosts could not be read.

          [UNEXPECTED]Error occurred running "perl /u02/apppsar/PSAR/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u02/apppsar/PSAR/fs2/inst/apps/PSAR_test01/appl/admin/PSAR_test01.xml -patchctxfile=/u02/apppsar/PSAR/fs1/inst/apps/PSAR_test01/appl/admin/PSAR_test01.xml -phase=prepare -logloc=/u02/apppsar/PSAR/fs_ne/EBSapps/log/adop/7/20180810_182847/prepare/validate/test01 -promptmsg=hide"

          [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on test01

       

       

      [STATEMENT] Please run adopscanlog utility, using the command

       

      [apppsar@test01 ContentsXML]$ cat /etc/hosts

      127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

      ::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

      10.22.5.66      test01.oraclecloud.com  test01

       

      [apppsar@test01 ContentsXML]$ hostname

      test01.oraclecloud.com

       

       

      I am trying to read the /etc/hosts using this appl user (apppsar) and I can read it.

      Could it be possible the old hostname was changed?

       

       

      Please help.....

       

       

       

      KInd regards,

      jc

        • 1. Re: EBS 12.2.7 ADOP prepare error
          mdtaylor

          Hi jc,

           

          Please post anything else from the log:

           

          /u02/apppsar/PSAR/fs_ne/EBSapps/log/adop/7/20180810_182847/adop.log

           

          There should be something more indicative of the validation failure.  Also look at /etc/oraInst.loc and ensure the inventory_loc points to a valid 12.2 oraInventory.

           

          Regards,

          Michael

          • 2. Re: EBS 12.2.7 ADOP prepare error
            Beauty_and_dBest

            Thanks Michael,

             

            I can edit inventory.xml using appl owner:

             

            [opc@test01 ~]$ sudo su - apppsar

             

              E-Business Suite Environment Information

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

              RUN File System           : /u02/apppsar/PSAR/fs2/EBSapps/appl

              PATCH File System         : /u02/apppsar/PSAR/fs1/EBSapps/appl

              Non-Editioned File System : /u02/apppsar/PSAR/fs_ne

             

              DB Host: test01.oraclecloud.com  Service/SID: PSAR

             

              Sourcing the RUN File System ...

             

            [apppsar@test01 ~]$ cat /etc/oraInst.loc

            inventory_loc=/u01/install/APPS/oraInventory

            inst_group=oinstall

            [apppsar@test01 ~]$ cd /u01/install/APPS/oraInventory

            [apppsar@test01 oraInventory]$ ls -l

            total 100

            drwxrwxrwx 102 oracle oinstall  4096 Jul 12 13:18 backup

            drwxrwxrwx   2 oracle oinstall  4096 Jul  8 22:19 Contents

            drwxrwxrwx   2 oracle oinstall  4096 Aug 10 18:34 ContentsXML

            -rwxrwxrwx   1 oracle oinstall    37 Jul  9 01:37 install.platform

            drwxrwxrwx   2 oracle oinstall 73728 Jul 12 13:16 logs

            -rwxrwxrwx   1 oracle oinstall   311 Jul  4 02:18 oraInstaller.properties

            drwxrwxrwx   2 oracle oinstall  4096 Jul  8 22:19 oui

            [apppsar@test01 oraInventory]$ cd ContentsXML

            [apppsar@test01 ContentsXML]$ ls

            comps.xml  home  home2  inventory2.xml  inventory.bak3  inventory.bak4  inventory.xml  libs.xml

            [apppsar@test01 ContentsXML]$ ls -l inventory.xml

            -rwxrwxrwx 1 oracle oinstall 9937 May 13 14:02 inventory.xml

            [apppsar@test01 ContentsXML]$ vi inventory.xml

             

            Adop.LOG

            ==============

            [apppsar@test01 ContentsXML]$ cat /u02/apppsar/PSAR/fs_ne/EBSapps/log/adop/7/20180810_182847/adop.log

            [STATEMENT] Inside createPatchCtxFile().

            [START 2018/08/10 18:28:48] Arguments passed to adop

                phase=prepare

            [END   2018/08/10 18:28:48] Arguments passed to adop

            [STATEMENT] Verifying parameters

            [STATEMENT] Sourcing Run edition environment /u02/apppsar/PSAR/fs2/EBSapps/appl/APPSPSAR_test01.env

             

             

            [EVENT]     Validating system setup.

                [STATEMENT] Checking for required environment

                [PROCEDURE] Running: adpawc -nodisp

                [STATEMENT]  Using 4 workers (Default: 4, Recommended maximum limit: 78)

                [PROCEDURE] [START 2018/08/10 18:29:22] Identifying Admin server node

                [STATEMENT] Admin node : "test01"

                [PROCEDURE] [END   2018/08/10 18:29:23] Identifying Admin server node

                [EVENT]     Node registry is valid.

                [PROCEDURE] [START 2018/08/10 18:29:23] Performing database sanity checks

                [WARNING]   ETCC: The following required database fixes have not been applied to node test01:

                              23125826

                              25305405

                              26336977

                              26654363

                              26911000

                              26742604

                            Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.

                [WARNING]   MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh.

                [PROCEDURE] [END   2018/08/10 18:29:23] Performing database sanity checks

            [PROCEDURE] [START 2018/08/10 18:29:23] Acquiring lock on sessions table

            [STATEMENT] Locking ad_adop_sessions table for test01 with wait interval of 60 seconds and number of tries 2

             

             

            [PROCEDURE] [END   2018/08/10 18:29:23] Acquiring lock on sessions table

             

             

            [EVENT]     Checking for existing adop sessions.

                [PROCEDURE] [START 2018/08/10 18:29:23] Checking for any pending sessions

                [EVENT]     Checking for pending hotpatch session.

                    [PROCEDURE] [START 2018/08/10 18:29:23] Checking active hotpatch session

                    [STATEMENT] Fetching number of incomplete cycles for test01 having appltop_id=196.

                    [STATEMENT] value of incomplete_session: "0"

                    [PROCEDURE] [END   2018/08/10 18:29:24] Checking active hotpatch session

                [EVENT]     Checking for pending cleanup session.

                    [PROCEDURE] [START 2018/08/10 18:29:24] Checking for active cleanup session

                    [PROCEDURE] [END   2018/08/10 18:29:24] Checking for active cleanup session

                [STATEMENT] Master Session ID: "7"

                Continuing with existing session [Session ID: 7].

                [STATEMENT] Master Node: "test01"

                [STATEMENT] Check for incomplete patching cycle with session ID 7 on hostname test01

                [STATEMENT] SQL output: "1"

                [STATEMENT] Fetching information for incomplete or failed session with session ID: 7

                [STATEMENT] output: "7,N,N,N,N,F"

                [PROCEDURE] [START 2018/08/10 18:29:24] Displaying session status

                    Session Id            :   7

                    Prepare phase status  :   NOT COMPLETED

                    Apply phase status    :   NOT COMPLETED

                    Cutover  phase status :   NOT COMPLETED

                    Abort phase status    :   NOT COMPLETED

                    Session status        :   FAILED

                [PROCEDURE] [END   2018/08/10 18:29:24] Displaying session status

                [STATEMENT] Continuing with previous session.

                [PROCEDURE] [START 2018/08/10 18:29:24] Obtaining inputs for previous session

                [STATEMENT] Key: "admin_node"       Value: "test01"

                [STATEMENT] Key: "phase_hash"       Value: "HASH(0xda1628)"

                [STATEMENT] Key: "initial_cutover_status"   Value: "N"

                [STATEMENT] Key: "abortmode"        Value: "0"

                [STATEMENT] Key: "LOG_LEVEL_VALUES" Value: "HASH(0xda0f20)"

                [STATEMENT] Key: "num_tries"        Value: "2"

                [STATEMENT] Key: "workers"  Value: "4"

                [STATEMENT] Key: "max_workers"      Value: "78"

                [STATEMENT] Key: "hostname" Value: "test01"

                [STATEMENT] Key: "phase_seq_hash"   Value: "HASH(0xda16a0)"

                [STATEMENT] Key: "run_admin_status" Value: "1"

                [STATEMENT] Key: "logidentmode"     Value: "SUBROUTINE"

                [STATEMENT] Key: "LOG_LEVEL"        Value: "HASH(0xda0d40)"

                [STATEMENT] Key: "hotpatch" Value: "0"

                [STATEMENT] Key: "logfile"  Value: "adop.log"

                [STATEMENT] Key: "appltop_type"     Value: "dual"

                [STATEMENT] Key: "exec_id"  Value: ""

                [STATEMENT] Key: "prompt"   Value: "1"

                [STATEMENT] Key: "allnodes" Value: "1"

                [STATEMENT] Key: "patchcontextfile" Value: "/u02/apppsar/PSAR/fs1/inst/apps/PSAR_test01/appl/admin/PSAR_test01.xml"

                [STATEMENT] Key: "downtime" Value: "0"

                [STATEMENT] Key: "session_id"       Value: "7"

                [STATEMENT] Key: "recom_workers"    Value: "4"

                [STATEMENT] Key: "skipsyncerror"    Value: "No"

                [STATEMENT] Key: "lock_wait_interval"       Value: "60"

                [STATEMENT] Key: "interim_cutover_desc"     Value: "ARRAY(0xda1598)"

                [STATEMENT] Key: "loglevel" Value: "event"

                [STATEMENT] Key: "patchtop" Value: "/u02/apppsar/PSAR/fs_ne/EBSapps/patch"

                [STATEMENT] Key: "merge"    Value: "no"

                [STATEMENT] Key: "phase"    Value: "prepare"

                [STATEMENT] Key: "adpatch_interactive"      Value: "yes"

                [STATEMENT] Key: "fileloglevel"     Value: "disable"

                [STATEMENT] Key: "allowcoredump"    Value: "No"

                [STATEMENT] Key: "super_node"       Value: "HASH(0xda17a8)"

                [STATEMENT] Key: "sync_mode"        Value: "patch"

                [STATEMENT] Key: "diskspace"        Value: "10"

                [STATEMENT] Key: "multi_node"       Value: "0"

                [STATEMENT] Key: "dbloglevel"       Value: "disable"

                [STATEMENT] Key: "mtrestart"        Value: "1"

                [STATEMENT] Key: "is_master"        Value: "1"

                [STATEMENT] Key: "analytics"        Value: "0"

                [STATEMENT] Key: "force"    Value: "0"

                [STATEMENT] Key: "nodbaction"       Value: "0"

                [STATEMENT] Key: "appsusername"     Value: "APPS"

                [STATEMENT] Key: "appltop_id"       Value: "196"

                [STATEMENT] Key: "runcontextfile"   Value: "/u02/apppsar/PSAR/fs2/inst/apps/PSAR_test01/appl/admin/PSAR_test01.xml"

                [PROCEDURE] [END   2018/08/10 18:29:24] Obtaining inputs for previous session

            [PROCEDURE] [START 2018/08/10 18:29:24] Unlocking sessions table

            [STATEMENT] Unlocking ad_adop_sessions table for test01 with wait interval of 60 seconds and number of tries 2

             

             

            [PROCEDURE] [END   2018/08/10 18:29:24] Unlocking sessions table

            [PROCEDURE] [START 2018/08/10 18:29:24] Running adzdoptl.pl

             

             

            ===========================================================================

            ADOP (C.Delta.10)

            Session ID: 7

            Node: test01

            Phase: prepare

            Log: /u02/apppsar/PSAR/fs_ne/EBSapps/log/adop/7/20180810_182847/adop.log

            ===========================================================================

            [STATEMENT] Patch file system context file exists

            [PROCEDURE] [START 2018/08/10 18:29:25] Checking status of phase

            [STATEMENT] SQL statement: "  select count(1)

              from  ad_adop_sessions

              where  adop_session_id=7 and (prepare_status in ('N','R')) and node_name='test01'

            "

            [STATEMENT] SQL Output: "1".

             

             

            [EVENT]     Validating configuration on node: [test01].

                [STATEMENT] Calling task: "Executing txkADOPValidation script on test01"; script: "/u02/apppsar/PSAR/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl"; args: " -contextfile=/u02/apppsar/PSAR/fs2/inst/apps/PSAR_test01/appl/admin/PSAR_test01.xml -patchctxfile=/u02/apppsar/PSAR/fs1/inst/apps/PSAR_test01/appl/admin/PSAR_test01.xml -phase=prepare -logloc=/u02/apppsar/PSAR/fs_ne/EBSapps/log/adop/7/20180810_182847/prepare/validate/test01 -promptmsg=hide"

                [PROCEDURE] [START 2018/08/10 18:29:25] Executing txkADOPValidation script on test01

                [PROCEDURE] Calling: /u02/apppsar/PSAR/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl

                [EVENT]     Log: /u02/apppsar/PSAR/fs_ne/EBSapps/log/adop/7/20180810_182847/prepare/validate/test01

                [UNEXPECTED]Error occurred running "perl /u02/apppsar/PSAR/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u02/apppsar/PSAR/fs2/inst/apps/PSAR_test01/appl/admin/PSAR_test01.xml -patchctxfile=/u02/apppsar/PSAR/fs1/inst/apps/PSAR_test01/appl/admin/PSAR_test01.xml -phase=prepare -logloc=/u02/apppsar/PSAR/fs_ne/EBSapps/log/adop/7/20180810_182847/prepare/validate/test01 -promptmsg=hide"

                [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on test01

            [PROCEDURE] [START 2018/08/10 18:30:17] Unlocking sessions table

            [STATEMENT] Unlocking ad_adop_sessions table for test01 with wait interval of 60 seconds and number of tries 2

             

            [PROCEDURE] [END   2018/08/10 18:30:17] Unlocking sessions table

            [PROCEDURE] [START 2018/08/10 18:30:17] Updating adop session status

            [STATEMENT] SQL statement : "  update ad_adop_sessions

              set status='F'

               where adop_session_id = 7 and appltop_id = 196 and node_name='test01'

            "

            [PROCEDURE] [END   2018/08/10 18:30:17] Updating adop session status

            [apppsar@test01 ContentsXML]$

            • 3. Re: EBS 12.2.7 ADOP prepare error
              mdtaylor

              Hi jc,

               

              Please navigate to $ORACLE_HOME/oui/bin, as apppsar and type runInstaller, then Installed Products and verify you have 8 Oracle Homes.

               

              Screen Shot 2018-08-12 at 7.03.32 PM.png

              Regards,

              Michael

              • 4. Re: EBS 12.2.7 ADOP prepare error
                Beauty_and_dBest

                Thanks Michael,

                 

                 

                I will try that...brb