I cannot execute the adopt prepare, after cloning the environment.

[msantaana]

Hello Erman, can you help me with this issue.
I recently made a postclone of my environment, at the moment I want to run the adop phase = prepare, it generates the following error.

 [UNEXPECTED] Error occurred running "perl /u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile = / u01 / install / APPS / fs1 / inst / EBSPRE_sebscomp1lx / appl / admin / EBSPRE_sebscomp1lx.xml -phase = prepare -logloc = / u01 / install / apps / EBSPRE_sebscomp1lx / appl / admin / EBSPRE_sebscomp1lx.xml -patchctxfile = / u01 / install / Fs_ne / EBSapps / log / adopt / 75 / 20170116_183726 / prepare / validate / sebscomp1lx -promptmsg = hide "
    [UNEXPECTED] Error 1 occurred while Executing txkADOPValidation script on sebscomp1lx

Try attach all the directories with the command bellow, and the error is the same

--fs1

./runInstaller.sh -silent -attachhome ORACLE_HOME = / u01 / install / APPS / fs1 / EBSapps / 10.1.2 ORACLE_HOME_NAME = "EBSPRE_TOOLS__u01_install_APPS_fs1_EBSapps_10_1_2"
./runInstaller.sh -silent -attachhome ORACLE_HOME = / u01 / install / APPS / fs1 / FMW_Home / oracle_common ORACLE_HOME_NAME = 'FMW_oracle_common_fs1_OH'
./runInstaller.sh -silent -attachhome ORACLE_HOME = / u01 / install / APPS / fs1 / FMW_Home / webtier ORACLE_HOME_NAME = 'FMW_webtier_fs1_OH'
./runInstaller.sh -silent -attachhome ORACLE_HOME = / u01 / install / APPS / fs1 / FMW_Home / Oracle_EBS-app1 ORACLE_HOME_NAME = 'FMW_Oracle_EBS_app1_fs1_OH'

--fs2

./runInstaller.sh -silent -attachhome ORACLE_HOME = / u01 / install / APPS / fs2 / EBSapps / 10.1.2 ORACLE_HOME_NAME = "EBSPRE_TOOLS__u01_install_APPS_fs2_EBSapps_10_1_2"
./runInstaller.sh -silent -attachhome ORACLE_HOME = / u01 / install / APPS / fs2 / FMW_Home / oracle_common ORACLE_HOME_NAME = 'FMW_oracle_common_fs2_OH'
./runInstaller.sh -silent -attachhome ORACLE_HOME = / u01 / install / APPS / fs2 / FMW_Home / webtier ORACLE_HOME_NAME = 'FMW_webtier_fs2_OH'
./runInstaller.sh -silent -attachhome ORACLE_HOME = / u01 / install / APPS / fs2 / FMW_Home / Oracle_EBS-app1 ORACLE_HOME_NAME = 'FMW_Oracle_EBS_app1_fs2_OH'

My full log-work is this

su - applmgr

  E-Business Suite Environment Information
  ----------------------------------------
  RUN File System           : /u01/install/APPS/fs1/EBSapps/appl
  PATCH File System         : /u01/install/APPS/fs2/EBSapps/appl
  Non-Editioned File System : /u01/install/APPS/fs_ne


  DB Host: sdatcomp2lx.bancocredicoop.coop  Service/SID: EBSPRE


  Sourcing the RUN File System ...


[applmgr@sebscomp1lx ~]$ adop phase=prepare

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
    Run Edition context  : /u01/install/APPS/fs1/inst/apps/EBSPRE_sebscomp1lx/appl/admin/EBSPRE_sebscomp1lx.xml
    Patch edition context: /u01/install/APPS/fs2/inst/apps/EBSPRE_sebscomp1lx/appl/admin/EBSPRE_sebscomp1lx.xml
    Patch file system free space: 71.61 GB

Validating system setup.
    Node registry is valid.
    [WARNING]   ETCC: The following required database fixes have not been applied to node sdat2122lx:
                  21286665
                  22338374
                Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.
    [WARNING]   MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh.

Checking for existing adop sessions.
    No pending session exists.
    Starting new adop session.

===========================================================================
ADOP (C.Delta.8)
Session ID: 75
Node: sebscomp1lx
Phase: prepare
Log: /u01/install/APPS/fs_ne/EBSapps/log/adop/75/20170116_183726/adop.log
===========================================================================

Validating configuration on node: [sebscomp1lx].
    Log: /u01/install/APPS/fs_ne/EBSapps/log/adop/75/20170116_183726/prepare/validate/sebscomp1lx
    [UNEXPECTED]Error occurred running "perl /u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u01/install/APPS/fs1/inst/apps/EBSPRE_sebscomp1lx/appl/admin/EBSPRE_sebscomp1lx.xml -patchctxfile=/u01/install/APPS/fs2/inst/apps/EBSPRE_sebscomp1lx/appl/admin/EBSPRE_sebscomp1lx.xml -phase=prepare -logloc=/u01/install/APPS/fs_ne/EBSapps/log/adop/75/20170116_183726/prepare/validate/sebscomp1lx -promptmsg=hide"
    [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on sebscomp1lx


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

Thank you for advanced.

[ErmanArslansOracleBlog]

Hi,

Send me the output of the following;

adopscanlog -latest=yes

[msantaana]

Hi, Thanks for your response, I send you the output of the adopscanlog -latest = yes


[applmgr@sebscomp1lx ~]$ adopscanlog -latest=yes

Scanning /u01/install/APPS/fs_ne/EBSapps/log/adop/75/ directory ...

/u01/install/APPS/fs_ne/EBSapps/log/adop/75/20170116_183726/adop.log:
---------------------------------------------------------------------

Lines #(78-83):
    [PROCEDURE] Calling: /u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl
    [EVENT]     Log: /u01/install/APPS/fs_ne/EBSapps/log/adop/75/20170116_183726/prepare/validate/sebscomp1lx
    [UNEXPECTED]Error occurred running "perl /u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u01/install/APPS/fs1/inst/apps/EBSPRE_sebscomp1lx/appl/admin/EBSPRE_sebscomp1lx.xml -patchctxfile=/u01/install/APPS/fs2/inst/apps/EBSPRE_sebscomp1lx/appl/admin/EBSPRE_sebscomp1lx.xml -phase=prepare -logloc=/u01/install/APPS/fs_ne/EBSapps/log/adop/75/20170116_183726/prepare/validate/sebscomp1lx -promptmsg=hide"
    [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on sebscomp1lx
[PROCEDURE] [START 2017/01/16 18:38:33] Unlocking sessions table
[STATEMENT] Unlocking ad_adop_sessions table for sebscomp1lx with wait interval of 60 seconds and number of tries 2

[ErmanArslansOracleBlog]

There may be a lock left on ad_adop_sessions..

First check the issue using the document below;

ORA-20010 Unable to acquire lock on ad_adop_sessions Table (Doc ID 1903316.1)

Do the throubleshooting steps documented in above note.

If you can fix your issue using Doc 1903316.1, then it is good for you.

If you can't fix your issue, then send me the required and detailed diagnostic info by following the Document: Script to Diagnose adop and Other AD-TXK Issues in Oracle E-Business Suite Release 12.2 [ Patch 19045166:R12.AD.C ] (Doc ID 1901242.1)

[msantaana]

Erman, I can't fix the issue with the (Doc ID 1903316.1)
I send by email the diagnostic file according to the document Doc ID 1901242.1

Thanks in advanced

[msantaana]

Erman, i attached diagnostic_info

Thanks

2017-01-17 10:26 GMT-03:00 ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] <[hidden email]>:

There may be a lock left on ad_adop_sessions..

First check the issue using the document below;

ORA-20010 Unable to acquire lock on ad_adop_sessions Table (Doc ID 1903316.1)

Do the throubleshooting steps documented in above note.

If you can fix your issue using Doc 1903316.1, then it is good for you.

If you can't fix your issue, then send me the required and detailed diagnostic info by following the Document: Script to Diagnose adop and Other AD-TXK Issues in Oracle E-Business Suite Release 12.2 [ Patch 19045166:R12.AD.C ] (Doc ID 1901242.1)

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/I-cannot-execute-the-adopt-prepare-after-cloning-the-environment-tp1922p1935.html

To unsubscribe from I cannot execute the adopt prepare, after cloning the environment., click here.
NAML

[ErmanArslansOracleBlog]

Gathered info from the diagnostics file:

Use of uninitialized value $result in split at /u01/install/APPS/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1291.
No such file or directory at /u01/install/APPS/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 230.

[ErmanArslansOracleBlog]

Hi,

The same error reported in Error "Use of uninitialized value $result in split" In File txkADOPValidations.error When Running fs_clone (Doc ID 2090393.1).

Please follow the steps document in "Error "Use of uninitialized value $result in split" In File txkADOPValidations.error When Running fs_clone (Doc ID 2090393.1)".

Update me with the outcome.

[msantaana]

Erman,
The steps of the document Id 2090393.1 worked correctly.
Thank you so much.
regards