1 2 Previous Next 16 Replies Latest reply on Oct 18, 2018 3:03 AM by #MVivek

    adop phase=fs_clone    error

    Beauty_and_dBest

      Hi ALL,

       

      After applying RUP 12.2.6,  I run > adop phase=fs_clone.

      But I got error below:

       

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

      ADOP (C.Delta.10)

      Session ID: 4

      Node: oraapps-2

      Phase: fs_clone

      Log: /u01/oracle/PPAPROD/fs_ne/EBSapps/log/adop/4/20181005_133450/adop.log

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

       

      Validating configuration on node: [oraapps-2].

          Log: /u01/oracle/PPAPROD/fs_ne/EBSapps/log/adop/4/20181005_133450/fs_clone/validate/oraapps-2

          [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.

        [ERROR]: The value of s_ohs_installed is incorrect.

          [UNEXPECTED]Error occurred running "perl /u01/oracle/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u01/oracle/PPAPROD/fs1/inst/apps/PPAPROD_oraapps-2/appl/admin/PPAPROD_oraapps-2.xml -patchctxfile=/u01/oracle/PPAPROD/fs2/inst/apps/PPAPROD_oraapps-2/appl/admin/PPAPROD_oraapps-2.xml -phase=fs_clone -logloc=/u01/oracle/PPAPROD/fs_ne/EBSapps/log/adop/4/20181005_133450/fs_clone/validate/oraapps-2 -promptmsg=hide"

          [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on oraapps-2

       

       

      [STATEMENT] Please run adopscanlog utility, using the command

       

      "adopscanlog -latest=yes"

       

      to get the list of the log files along with snippet of the error message corresponding to each log file.

       

      Log: /u01/oracle/PPAPROD/fs_ne/EBSapps/log/adop/4/20181005_133450/adop.log

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

      [STATEMENT] Patch file system context file exists

       

      [EVENT]     Validating configuration on node: [oraapps-2].

          [STATEMENT] Calling task: "Executing txkADOPValidation script on oraapps-2"; script: "/u01/oracle/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl"; args: " -contextfile=/u01/oracle/PPAPROD/fs1/inst/apps/PPAPROD_oraapps-2/appl/admin/PPAPROD_oraapps-2.xml -patchctxfile=/u01/oracle/PPAPROD/fs2/inst/apps/PPAPROD_oraapps-2/appl/admin/PPAPROD_oraapps-2.xml -phase=fs_clone -logloc=/u01/oracle/PPAPROD/fs_ne/EBSapps/log/adop/4/20181005_133450/fs_clone/validate/oraapps-2 -promptmsg=hide"

          [PROCEDURE] [START 2018/10/05 13:35:36] Executing txkADOPValidation script on oraapps-2

          [PROCEDURE] Calling: /u01/oracle/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl

          [EVENT]     Log: /u01/oracle/PPAPROD/fs_ne/EBSapps/log/adop/4/20181005_133450/fs_clone/validate/oraapps-2

          [UNEXPECTED]Error occurred running "perl /u01/oracle/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u01/oracle/PPAPROD/fs1/inst/apps/PPAPROD_oraapps-2/appl/admin/PPAPROD_oraapps-2.xml -patchctxfile=/u01/oracle/PPAPROD/fs2/inst/apps/PPAPROD_oraapps-2/appl/admin/PPAPROD_oraapps-2.xml -phase=fs_clone -logloc=/u01/oracle/PPAPROD/fs_ne/EBSapps/log/adop/4/20181005_133450/fs_clone/validate/oraapps-2 -promptmsg=hide"

          [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on oraapps-2

      [PROCEDURE] [START 2018/10/05 13:36:30] Unlocking sessions table

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

       

      [PROCEDURE] [END   2018/10/05 13:36:30] Unlocking sessions table

      [PROCEDURE] [START 2018/10/05 13:36:30] Updating adop session status

      [STATEMENT] SQL statement : "  update ad_adop_sessions

        set status='F'

         where adop_session_id = 4 and appltop_id = 3194 and node_name='oraapps-2'

      "

      [PROCEDURE] [END   2018/10/05 13:36:30] Updating adop session status

       

       

      Can you share me what value should context_file  > s_ohs_installed?

      Our current value is >  <config_option type="techstack" oa_var="s_ohs_installed">false</config_option>

       

       

       

       

      Please help....

       

       

      Kind regards,

      jc

        • 1. Re: adop phase=fs_clone    error
          Beauty_and_dBest

          Hi ALL,

           

          I tried this solution:

           

           

          1) Take backup of  fnd_nodes, adop_valid_nodes, and fnd_oam_context_files.

              create table fnd_nodes_bak as select * from fnd_nodes;

              create table adop_valid_nodes_bak as select * from adop_valid_nodes;

              create table fnd_oam_context_files_bak as select * from fnd_oam_context_files;

           

          2) Delete the tables.

              delete fnd_nodes;

              delete adop_valid_nodes;

              delete fnd_oam_context_files;

           

          3) Run AutoConfig on DB tier and then on apps tier (Run & Patch FS).

           

           

          Then rerun > adop phase=fs_clone

           

          But I have new error

           

          Validating credentials.

           

          Initializing.

              Run Edition context  : /u01/oracle/PPAPROD/fs1/inst/apps/PPAPROD_oraapps-2/appl/admin/PPAPROD_oraapps-2.xml

              Patch edition context: /u01/oracle/PPAPROD/fs2/inst/apps/PPAPROD_oraapps-2/appl/admin/PPAPROD_oraapps-2.xml

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

          PROGRAM : (/u01/oracle/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)

          TIME    : Fri Oct  5 16:33:25 2018

          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.

           

           

          [STATEMENT] Please run adopscanlog utility, using the command

           

          "adopscanlog -latest=yes"

           

           

          Please help....

           

           

          Kind regards,

          • 2. Re: adop phase=fs_clone    error
            Beauty_and_dBest

            For Error above, I checked >

             

            And the parameter has already correct value

             

              <TIER_NODE oa_var="s_isConc">YES</TIER_NODE>

             

             

            Please help...

            • 3. Re: adop phase=fs_clone    error
              Beauty_and_dBest

              Hi ALL,

               

              I also tried using this note, but to no avail

               

              But Nodes are still not properly populated after doing above setup.

               

              select NAME,VERSION,PATH, STATUS from FND_OAM_CONTEXT_FILES

               

              NAME            VERSION PATH                                          STATUS

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

              PPAPROD_oraapps-2120.401.1202 /u01/oracle/PPAPROD/fs2/inst/apps/PPAPROD_oraapps- S
              0000.9.12020 2/appl/admin/PPAPROD_oraapps-2.xml
              10.10

               

              TEMPLATE        120.401.1202 /u01/oracle/PPAPROD/fs2/EBSapps/appl/ad/12.0.0/adm S
              0000.9.12020 in/template/adxmlctx.tmp
              10.10

               

              METADATA        120.230.1202 /u01/oracle/PPAPROD/fs2/EBSapps/appl/ad/12.0.0/adm S
              0000.9  in/template/adctxinf.tmp

               

              PPAPROD_oradb-2 120.52.12020 /mnt/data/d01/oracle/PPAPROD/db/tech_st/12.1.0.2/a S
              000.11  ppsutil/PPAPROD_oradb-2.xml

               

              TEMPLATE        120.52.12020 /mnt/data/d01/oracle/PPAPROD/db/tech_st/12.1.0.2/a S
              000.11  ppsutil/template/adxdbctx.tmp

               

              METADATA        120.31.12020 /mnt/data/d01/oracle/PPAPROD/db/tech_st/12.1.0.2/a S
              000.9   ppsutil/template/adxdbinf.tmp

               

              PPAPROD_oraapps-2120.401.1202 /u01/oracle/PPAPROD/fs1/inst/apps/PPAPROD_oraapps- S
              0000.68 2/appl/admin/PPAPROD_oraapps-2.xml

               

              TEMPLATE        120.401.1202 /u01/oracle/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/adm S
              0000.68 in/template/adxmlctx.tmp

               

              METADATA        120.230.1202 /u01/oracle/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/adm S
              0000.46 in/template/adctxinf.tmp

               

              9 rows selected.

               

              SQL>

               

               

               

              select node_id, platform_code, support_db D, support_cp C, support_admin A, support_forms F, support_web W, node_name, server_id,

              server_address, domain, webhost, virtual_ip, status  from fnd_nodes order by node_id;

               

                 NODE_ID PLAT D C A F W NODE_NAME  SERVER_I SERVER_ADDRESS  DOMAIN          WEBHOST VIRTUAL_IP   STATUS

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

              24129 226  Y N N N N ORADB-2                             prompt.ppa                   oradb-2 Y
              24130 226  N Y Y Y Y ORAAPPS-2  77788BBA 10.10.1.72 prompt.ppa      oraapps-2.pr         Y
              5BE76983                                 ompt.ppa
              E0534901
              0A0A0249
              12132522
              13107601
              29762317
              39519133

               

              24131 226  N N N N N AUTHENTICATION  SECURE   *

               

               

               

              Please help...

               

              Kind regards,

              • 4. Re: adop phase=fs_clone    error
                Althaf Khan-Oracle

                Provide this

                 

                select owner,SYNONYM_NAME,TABLE_OWNER,TABLE_NAME from dba_synonyms where SYNONYM_NAME IN ('FND_NODES','FND_OAM_CONTEXT_FILES','ADOP_VALID_NODES')

                • 5. Re: adop phase=fs_clone    error
                  Beauty_and_dBest

                  Hi Althaf,

                   

                  SQL> select owner||', '||SYNONYM_NAME||', '||TABLE_OWNER||', '||TABLE_NAME from dba_synonyms where SYNONYM_NAME IN ('FND_NODES','FND_OAM_CONTEXT_FILES','ADOP_VALID_NODES');

                   

                  OWNER||','||SYNONYM_NAME||','||TABLE_OWNER||','||TABLE_NAME

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

                  APPS, ADOP_VALID_NODES,      APPLSYS, ADOP_VALID_NODES#

                  APPS, FND_NODES,             APPLSYS, FND_NODES#

                  APPS, FND_OAM_CONTEXT_FILES, APPLSYS, FND_OAM_CONTEXT_FILES#

                   

                  SQL>

                   

                   

                   

                  Kind regards,

                  • 6. Re: adop phase=fs_clone    error
                    Althaf Khan-Oracle

                    Provide this:-

                     

                    1) desc apps.ADOP_VALID_NODES

                    2)desc applsys.ADOP_VALID_NODES

                     

                    Regards,

                    Althaf

                     

                    • 7. Re: adop phase=fs_clone    error
                      Beauty_and_dBest

                      Thanks,

                       

                       

                      SQL> desc apps.ADOP_VALID_NODES

                      Name                                                                     Null?    Type

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

                      NODE_NAME                                                                NOT NULL VARCHAR2(256)

                      CONTEXT_NAME                                                             NOT NULL VARCHAR2(50)

                      ZD_EDITION_NAME                                                          NOT NULL VARCHAR2(30)

                      ZD_SYNC                                                                  NOT NULL VARCHAR2(30)

                       

                      SQL> desc applsys.ADOP_VALID_NODES

                      Name                                                                     Null?    Type

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

                      NODE_NAME                                                                         VARCHAR2(30)

                      CONTEXT_NAME                                                             NOT NULL VARCHAR2(50)

                      ZD_EDITION_NAME                                                          NOT NULL VARCHAR2(30)

                      ZD_SYNC                                                                  NOT NULL VARCHAR2(30)

                      NODE_NAME#1                                                              NOT NULL VARCHAR2(256)

                       

                      SQL>

                      • 8. Re: adop phase=fs_clone    error
                        Althaf Khan-Oracle

                        Also provide this

                         

                        1 )desc apps.fnd_oam_context_files

                         

                        2) desc applsys.fnd_oam_context_files

                         

                        3) select * from fnd_oam_context_files;

                        • 9. Re: adop phase=fs_clone    error
                          Beauty_and_dBest

                          Hi Althaf and all,

                           

                          Any updates please.....

                           

                           

                          Kind regards,

                          • 10. Re: adop phase=fs_clone    error
                            Beauty_and_dBest

                            Hi Althaf,

                             

                            SQL> desc apps.fnd_oam_context_files

                            Name                                                                     Null?    Type

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

                            NAME                                                                     NOT NULL VARCHAR2(512)

                            VERSION                                                                  NOT NULL VARCHAR2(30)

                            PATH                                                                     NOT NULL VARCHAR2(1024)

                            LAST_SYNCHRONIZED                                                        NOT NULL DATE

                            TEXT                                                                     NOT NULL CLOB

                            LAST_UPDATE_DATE                                                         NOT NULL DATE

                            LAST_UPDATED_BY                                                          NOT NULL NUMBER(15)

                            CREATION_DATE                                                            NOT NULL DATE

                            CREATED_BY                                                               NOT NULL NUMBER(15)

                            LAST_UPDATE_LOGIN                                                        NOT NULL NUMBER(15)

                            NODE_NAME                                                                NOT NULL VARCHAR2(256)

                            STATUS                                                                            VARCHAR2(1)

                            SERIAL_NUMBER                                                                     NUMBER

                            EDIT_COMMENTS                                                                     VARCHAR2(2000)

                            CTX_TYPE                                                                 NOT NULL VARCHAR2(1)

                             

                            SQL> desc applsys.fnd_oam_context_files

                            Name                                                                     Null?    Type

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

                            NAME                                                                     NOT NULL VARCHAR2(512)

                            VERSION                                                                  NOT NULL VARCHAR2(30)

                            PATH                                                                     NOT NULL VARCHAR2(1024)

                            LAST_SYNCHRONIZED                                                        NOT NULL DATE

                            TEXT                                                                     NOT NULL CLOB

                            LAST_UPDATE_DATE                                                         NOT NULL DATE

                            LAST_UPDATED_BY                                                          NOT NULL NUMBER(15)

                            CREATION_DATE                                                            NOT NULL DATE

                            CREATED_BY                                                               NOT NULL NUMBER(15)

                            LAST_UPDATE_LOGIN                                                        NOT NULL NUMBER(15)

                            NODE_NAME                                                                         VARCHAR2(30)

                            STATUS                                                                            VARCHAR2(1)

                            SERIAL_NUMBER                                                                     NUMBER

                            EDIT_COMMENTS                                                                     VARCHAR2(2000)

                            CTX_TYPE                                                                 NOT NULL VARCHAR2(1)

                            NODE_NAME#1                                                              NOT NULL VARCHAR2(256)

                             

                            SQL> select * from fnd_oam_context_files;

                             

                            NAME                 VERSION      PATH                                               LAST_SYNCHRONIZ

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

                            TEXT                                                                             LAST_UPDATE_DAT LAST_UPDATED_BY CREATION_DATE

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

                            CREATED_BY LAST_UPDATE_LOGIN NODE_NAME       STATUS     SERIAL_NUMBER

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

                            EDIT_COMMENTS

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

                            C

                            -

                            PPAPROD_oraapps-2    120.401.1202 /u01/oracle/PPAPROD/fs2/inst/apps/PPAPROD_oraapps- 05-OCT-18

                                                 0000.9.12020 2/appl/admin/PPAPROD_oraapps-2.xml

                                                 10.10

                            <?xml version = '1.0'?>                                                          05-OCT-18                     5 05-OCT-18

                            <!-- $Header: adxmlctx.tmp 120.401.12020000.9.1202010.

                            10

                                    -1                -1 oraapps-2       S

                             

                            A

                             

                            TEMPLATE             120.401.1202 /u01/oracle/PPAPROD/fs2/EBSapps/appl/ad/12.0.0/adm 05-OCT-18

                                                 0000.9.12020 in/template/adxmlctx.tmp

                                                 10.10

                            <?xml version="1.0"?><!-- $Header: adxmlctx.tmp 120.401.12020000.9.1202010.10    05-OCT-18                    -1 05-OCT-18

                            20

                                    -1                -1 oraapps-2       S

                             

                            A

                             

                            METADATA             120.230.1202 /u01/oracle/PPAPROD/fs2/EBSapps/appl/ad/12.0.0/adm 05-OCT-18

                                                 0000.9       in/template/adctxinf.tmp

                            <?xml version="1.0"?>                                                            05-OCT-18                     5 05-OCT-18

                            <!-- $Header: adctxinf.tmp 120.230.12020000.9 2013/01/22

                            1

                                    -1                -1 oraapps-2       S

                             

                            A

                             

                            PPAPROD_oradb-2      120.52.12020 /mnt/data/d01/oracle/PPAPROD/db/tech_st/12.1.0.2/a 05-OCT-18

                                                 000.11       ppsutil/PPAPROD_oradb-2.xml

                            <?xml version = '1.0'?><!-- $Header: adxdbctx.tmp 120.52.12020000.11 2017/05/1   05-OCT-18                    -1 05-OCT-18

                            0

                                    -1                -1 oradb-2         S

                             

                            D

                             

                            TEMPLATE             120.52.12020 /mnt/data/d01/oracle/PPAPROD/db/tech_st/12.1.0.2/a 05-OCT-18

                                                 000.11       ppsutil/template/adxdbctx.tmp

                            <?xml version="1.0"?><!-- $Header: adxdbctx.tmp 120.52.12020000.11 2017/05/10    05-OCT-18                    -1 05-OCT-18

                            12

                                    -1                -1 oradb-2         S

                             

                            D

                             

                            METADATA             120.31.12020 /mnt/data/d01/oracle/PPAPROD/db/tech_st/12.1.0.2/a 05-OCT-18

                                                 000.9        ppsutil/template/adxdbinf.tmp

                            <?xml version="1.0" ?><!-- $Header: adxdbinf.tmp 120.31.12020000.9 2017/05/10    05-OCT-18                    -1 05-OCT-18

                            12

                                    -1                -1 oradb-2         S

                             

                            D

                             

                            PPAPROD_oraapps-2    120.401.1202 /u01/oracle/PPAPROD/fs1/inst/apps/PPAPROD_oraapps- 05-OCT-18

                                                 0000.68      2/appl/admin/PPAPROD_oraapps-2.xml

                            <?xml version = '1.0'?>                                                          05-OCT-18                     5 05-OCT-18

                            <!-- $Header: adxmlctx.tmp 120.401.12020000.68 2017/05

                            /1

                                    -1                -1 oraapps-2       S

                             

                            A

                             

                            TEMPLATE             120.401.1202 /u01/oracle/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/adm 05-OCT-18

                                                 0000.68      in/template/adxmlctx.tmp

                            <?xml version="1.0"?><!-- $Header: adxmlctx.tmp 120.401.12020000.68 2017/05/19   05-OCT-18                    -1 05-OCT-18

                            0

                                    -1                -1 oraapps-2       S

                             

                            A

                             

                            METADATA             120.230.1202 /u01/oracle/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/adm 05-OCT-18

                                                 0000.46      in/template/adctxinf.tmp

                            <?xml version="1.0"?>                                                            05-OCT-18                     5 05-OCT-18

                            <!-- $Header: adctxinf.tmp 120.230.12020000.46 2017/05/1

                            9

                                    -1                -1 oraapps-2       S

                             

                            A

                             

                             

                            9 rows selected.

                             

                            SQL>

                            • 11. Re: adop phase=fs_clone    error
                              Althaf Khan-Oracle

                              Try this document again and follow carefully.

                               

                              . Note 2064223.1 - How to Synchronize FND_NODES, ADOP_VALID_NODES, and FND_OAM_CONTEXT_FILES in 12.2 When ADOP Phase=Prepare Fails with Error 'not able to detect any valid application tier nodes in ADOP_VALID_NODES table. '

                               

                              As table's looks fine

                              • 12. Re: adop phase=fs_clone    error
                                Beauty_and_dBest

                                I already tried it but still no value populated.

                                • 13. Re: adop phase=fs_clone    error
                                  Althaf Khan-Oracle

                                  Re-run fs_clone again in force mode

                                   

                                  adop phase=fs_clone force=yes

                                  • 14. Re: adop phase=fs_clone    error
                                    Beauty_and_dBest

                                    Hi Althaf,

                                     

                                    I the same repeated error below, even if I use :

                                    adop phase=fs_clone force=yes

                                     

                                     

                                     

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

                                    ADOP (C.Delta.10)

                                    Session ID: 4

                                    Node: oraapps-2

                                    Phase: fs_clone

                                    Log: /u01/oracle/PPAPROD/fs_ne/EBSapps/log/adop/4/20181005_205705/adop.log

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

                                     

                                    Validating configuration on node: [oraapps-2].

                                        Log: /u01/oracle/PPAPROD/fs_ne/EBSapps/log/adop/4/20181005_205705/fs_clone/validate/oraapps-2

                                        [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.

                                        [ERROR]: The value of s_ohs_installed is incorrect.

                                        [UNEXPECTED]Error occurred running "perl /u01/oracle/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u01/oracle/PPAPROD/fs1/inst/apps/PPAPROD_oraapps-2/appl/admin/PPAPROD_oraapps-2.xml -patchctxfile=/u01/oracle/PPAPROD/fs2/inst/apps/PPAPROD_oraapps-2/appl/admin/PPAPROD_oraapps-2.xml -phase=fs_clone -logloc=/u01/oracle/PPAPROD/fs_ne/EBSapps/log/adop/4/20181005_205705/fs_clone/validate/oraapps-2 -promptmsg=hide"

                                        [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on oraapps-2

                                     

                                    [STATEMENT] Please run adopscanlog utility, using the command

                                     

                                    "adopscanlog -latest=yes"

                                     

                                    to get the list of the log files along with snippet of the error message corresponding to each log file.

                                     

                                    adop exiting with status = 1 (Fail)

                                     

                                     

                                    Why does it always say > The value of s_ohs_installed is incorrect.???

                                     

                                     

                                    Kind regards,

                                    1 2 Previous Next