Error in adop phase=prepare post Cloning

[Emmanuel Sanabria]

I have this problem in a cloned environment:

adop phase=prepare
Initializing.
    Run Edition context  : /u01/install/APPS/fs2/inst/apps/OEBT1N_sebs4101lx/appl/admin/OEBT1N_sebs4101lx.xml
    Patch edition context: /u01/install/APPS/fs1/inst/apps/OEBT1N_sebs4101lx/appl/admin/OEBT1N_sebs4101lx.xml
    Patch file system free space: 98.31 GB

Validating system setup.
    [UNEXPECTED]Duplicate rows found for host sebs4101lx in FND_OAM_CONTEXT_FILES table
*******FATAL ERROR*******
PROGRAM : (/u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME    : Thu Feb  2 11:50:20 2017
FUNCTION: ADOP::CommonUtil::getAppltopId [ Level 1 ]
ERRORMSG: Duplicate rows found for host sebs4101lx in FND_OAM_CONTEXT_FILES table
[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 = 255 (Fail)

adopscanlog -latest=yes
Lines #(129-134):
    [PROCEDURE] Calling: /u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl
    [EVENT]     Log: /u01/install/APPS/fs_ne/EBSapps/log/adop/70/20170201_130234/prepare/validate/sebs4101lx
    [UNEXPECTED]Error occurred running "perl /u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u01/install/APPS/fs2/inst/apps/OEBT1N_sebs4101lx/appl/admin/OEBT1N_sebs4101lx.xml -patchctxfile=/u01/install/APPS/fs1/inst/apps/OEBT1N_sebs4101lx/appl/admin/OEBT1N_sebs4101lx.xml -phase=prepare -logloc=/u01/install/APPS/fs_ne/EBSapps/log/adop/70/20170201_130234/prepare/validate/sebs4101lx -promptmsg=hide"
    [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on sebs4101lx
[PROCEDURE] [START 2017/02/01 13:03:10] Unlocking sessions table
[STATEMENT] Unlocking ad_adop_sessions table for sebs4101lx with wait interval of 60 seconds and number of tries 2

################################################################################################
I do step by step the note ID 2090393.1 But in step 4 it gives error:

SQL> select distinct(PATH) from FND_OAM_CONTEXT_FILES where NAME not in ('TEMPLATE','METADATA','config.txt') and CTX_TYPE='A' and (status is null or upper(status) in ('S','F')) and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'patch';
select distinct(PATH) from FND_OAM_CONTEXT_FILES where NAME not in ('TEMPLATE','METADATA','config.txt') and CTX_TYPE='A' and (status is null or upper(status) in ('S','F')) and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'patch'
                           *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL>

[Emmanuel Sanabria]

I pass the output of these commands:
backup FND_OAM_CONTEXT_FILES
create table FND_OAM_CONTEXT_FILES_BK as select * from FND_OAM_CONTEXT_FILES;
Clear data from FND_OAM_CONTEXT_FILES table.
delete from FND_OAM_CONTEXT_FILES;
Execute autoconfig from all nodes. (including db )

SQL> create table FND_OAM_CONTEXT_FILES_BK as select * from FND_OAM_CONTEXT_FILES;
create table FND_OAM_CONTEXT_FILES_BK as select * from FND_OAM_CONTEXT_FILES
                                                       *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL>

[ErmanArslansOracleBlog]

FND_OAM_CONTEXT_FILES is in APPLSYS schema.

SQL> select owner,table_name from dba_tables where table_name='FND_OAM_CONTEXT_FILES';

OWNER                          TABLE_NAME
------------------------------ ------------------------------
APPLSYS                        FND_OAM_CONTEXT_FILES


So, use APPLSYS as the schema owner, as shown below;

create table FND_OAM_CONTEXT_FILES_BK as select * from APPLSYS.FND_OAM_CONTEXT_FILES;

[Emmanuel Sanabria]

Hi Erman. Thanks. Now this error:
adopscanlog -latest=yes
[PROCEDURE] Calling: /u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl
    [EVENT]     Log: /u01/install/APPS/fs_ne/EBSapps/log/adop/70/20170203_115305/prepare/validate/sebs4101lx
    [UNEXPECTED]Error occurred running "perl /u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u01/install/APPS/fs2/inst/apps/OEBT1N_sebs4101lx/appl/admin/OEBT1N_sebs4101lx.xml -patchctxfile=/u01/install/APPS/fs1/inst/apps/OEBT1N_sebs4101lx/appl/admin/OEBT1N_sebs4101lx.xml -phase=prepare -logloc=/u01/install/APPS/fs_ne/EBSapps/log/adop/70/20170203_115305/prepare/validate/sebs4101lx -promptmsg=hide"
    [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on sebs4101lx
[PROCEDURE] [START 2017/02/03 11:53:39] Unlocking sessions table
[STATEMENT] Unlocking ad_adop_sessions table for sebs4101lx with wait interval of 60 seconds and number of tries 2

In the database execute:
SQL> select * from applsys.ad_adop_sessions where edition_name='LOCK' ;

no rows selected

begin
   applsys.AD_ZD_ADOP.UNLOCK_SESSIONS_TABLE('<sebs4101lx>',60,2);
   end;
   /  2    3    4  
   applsys.AD_ZD_ADOP.UNLOCK_SESSIONS_TABLE('<sebs4101lx>',60,2);
   *
ERROR at line 2:
ORA-06550: line 2, column 4:
PLS-00201: identifier 'APPLSYS.AD_ZD_ADOP' must be declared
ORA-06550: line 2, column 4:
PL/SQL: Statement ignored

SQL>
 

[ErmanArslansOracleBlog]

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

2)This may be related with "Use of uninitialized value $result in split" In File txkADOPValidations.error"
But it needs to be checked from the logs..
Anyways if it is related with it, you will be following -> "Error "Use of uninitialized value $result in split" In File txkADOPValidations.error When Running fs_clone (Doc ID 2090393.1)".


A similar issue was reported to me earlier: here -> http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/I-cannot-execute-the-adopt-prepare-after-cloning-the-environment-td1922.html

[Emmanuel Sanabria]

Erman, Good Day. Watch this. Run on the applications node:

/u01/install/APPS/fs2/EBSapps/comn/util/jdk32/jre/bin/java oracle.apps.ad.autoconfig.oam.CtxSynchronizer action=upload contextfile=/u01/install/APPS/fs2/inst/apps/SIDO_nodoappl/appl/admin/OEBT1N_sebs4101lx.xml logfile=/tmp/patchctxupload.log

patchctxupload.log: ---------------------------------------------------------------
                   ADX Database Utility                        
---------------------------------------------------------------

getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=nodooracle)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SID)))'
    Trying to connect using APPS_JDBC_URL
    Connection obtained.

-------------------ADX Database Utility Finished---------------


---------------------------------------------------------------
                   ADX Database Utility                        
---------------------------------------------------------------

getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=nodooracle)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SID)))'
    Trying to connect using APPS_JDBC_URL
    Connection obtained.

-------------------ADX Database Utility Finished---------------

But, in the database no register:

sqlplus applsys/password

select distinct(PATH) from FND_OAM_CONTEXT_FILES where NAME not in ('TEMPLATE','METADATA','config.txt') and CTX_TYPE='A' and (status is null or upper(status) in ('S','F')) and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'patch';

no rows selected

Previously I ran adautoconfig in the database and application

[ErmanArslansOracleBlog]

"Connection obtained"? So what? It means jdbc connection is obtained..
Anything else in the logs?

[ErmanArslansOracleBlog]

And you are checking file_edition_type = patch?

Which document are you following?

Did you set the patch environment before uploading the context file to db ?
(. EBSapps.env patch)

[Emmanuel Sanabria]

Only that
 Document ID 2090393.1.

---------------------------------------------------------------
                   ADX Database Utility                        
---------------------------------------------------------------

getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=nodeoralce)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SID)))'
    Trying to connect using APPS_JDBC_URL
    Connection obtained.

-------------------ADX Database Utility Finished---------------


---------------------------------------------------------------
                   ADX Database Utility                        
---------------------------------------------------------------

getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=nodeoracle)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SID))'
    Trying to connect using APPS_JDBC_URL
    Connection obtained.

-------------------ADX Database Utility Finished----------

[Emmanuel Sanabria]

In production, the query has output:
select distinct(PATH) from FND_OAM_CONTEXT_FILES where NAME not in ('TEMPLATE','METADATA','config.txt') and CTX_TYPE='A' and (status is null or upper(status) in ('S','F')) and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'patch';

PATH
--------------------------------------------------------------------------------
/u01/install/APPS/fs2/inst/apps/SIDPRO_appsprod/appl/admin/SIDPROD_appsprod.x
ml

[ErmanArslansOracleBlog]

Is this your "patch" filesystem context file? -> /u01/install/APPS/fs2/inst/apps/SIDO_nodoappl/appl/admin/OEBT1N_sebs4101lx.xml

Did you set the "run" environment before executing CtxSynchronizer?

[ErmanArslansOracleBlog]

Do this;

"Upload the Patch file system context file to the Database"

$ . ./u01/install/APPS/EBSapps.env patch

$ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer action=upload
contextfile=<full path to patch context file> logfile=/tmp/patchctxupload.log

Reference: Oracle E-Business Suite Release 12.2 Configuration in a DMZ (Doc ID 1375670.1) - Section 5.1.2.4.5: Execute AutoConfig On the External Application Tier Node

Attention! I set patch filesystem above, so you also set patch fs.
use "$ADJVAPRG" not directly "java".

[Emmanuel Sanabria]

Yes. Mi context file patch is: /u01/install/APPS/fs2/inst/apps/SIDO_nodoappl/appl/admin/OEBT1N_sebs4101lx.xml
and before upload this context file, set "run" environment.

[Emmanuel Sanabria]

If I do this step, then throw me the duplicate registration error and I have to delete the FND_OAM_CONTEXT_FILES table and generate it again with autoconfig

[ErmanArslansOracleBlog]

1) Are the following statements true for your case?

So, if you set run edition and invoke CtxSynchronizer with the patch edition Context file, then you get no rows registered for patch fs in FND_OAM_CONTEXT_FILES.
So, if you set patch edition and invoke CtxSynchronizer with the patch edition Context file, then you get duplicate registration error.

2) What is the value of "file_edition_type" in your Patch context file XML?
--open the context file using vi, and search for file_edition_type, what is the value of it?

3)There may be some inconsistency between  FND_NODES, ADOP_VALID_NODES, and FND_OAM_CONTEXT_FILES. Maybe that 's what prevents ctxsynchronizer.

Reference:  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. ' (Doc ID 2064223.1)


For uploading Context file, you can also run an autoconfig on Patch file system.

To be able to run autoconfig on patch filesystem , you should disable the trigger named ebs_logon trigger as documented in the note above.


Do the following action plan and have a clean situation:

*. Backup the fnd_oam_context_files, fnd_nodes, and adop_valid_nodes tables in the EBS env:
      sqlplus applsys/pwd

      create table fnd_oam_context_files_bkp as select * from fnd_oam_context_files;
      create table fnd_nodes_bk as select * from fnd_nodes;
        create table adop_valid_nodes_bk as select * from adop_valid_nodes;

*. Truncate the following tables:

      truncate table fnd_oam_context_files;

      truncate table fnd_nodes;

      truncate table adop_valid_nodes;

*.  Run AutoConfig on the DB tier
        Confirm Autoconfig completes successfully

*.  Run Autoconfig on the run file system.
        Confirm Autoconfig completes successfully

*.  Run Autoconfig on the patch file system

Due to the method required for "cleaning out" / "re-synchronizing" the following tables, it is EXPECTED / REQUIRED that the Applications have been shutdown.

The only thing running should be the Database Tier.

 Before running Autoconfig on the patch file system the ebs_login trigger MUST be disabled
After the successful completion of Autoconfig the ebs_login trigger MUST be re-enabled.

This needs to be done as the SYSTEM schema user.

**. Disable the ebs_login trigger using the following SQL.

    SQL> alter trigger ebs_logon disable;

       At this time Run autoconfig with the patch env sourced. (SOURCE PATH ENV and run AUTOCONFIG)
       Make sure Autoconfig completes ok

**. Enable the ebs_login trigger using the following SQL.

    SQL> alter trigger ebs_logon enable;

*.  After Autoconfig has been run successfully on all nodes, run the following two (2) queries in order to verify the tables have been correctly populated:

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;
SQL>
        select NAME,VERSION,PATH, STATUS
          from FND_OAM_CONTEXT_FILES;

[Emmanuel Sanabria]

Hi Erman

1-) YES

2-) The CtxSynchronizer runs fine, but invoking adopt phase = prepare throws me the error of duplicate registration error

3-) Eh correctly followed the steps, step by step, and I continue with the same error:

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

adopscanlog -latest=yes
Lines #(129-134):
    [PROCEDURE] Calling: /u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl
    [EVENT]     Log: /u01/install/APPS/fs_ne/EBSapps/log/adop/70/20170207_115820/prepare/validate/sebs4101lx
    [UNEXPECTED]Error occurred running "perl /u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u01/install/APPS/fs2/inst/apps/OEBT1N_sebs4101lx/appl/admin/OEBT1N_sebs4101lx.xml -patchctxfile=/u01/install/APPS/fs1/inst/apps/OEBT1N_sebs4101lx/appl/admin/OEBT1N_sebs4101lx.xml -phase=prepare -logloc=/u01/install/APPS/fs_ne/EBSapps/log/adop/70/20170207_115820/prepare/validate/sebs4101lx -promptmsg=hide"
    [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on sebs4101lx
[PROCEDURE] [START 2017/02/07 11:59:22] Unlocking sessions table
[STATEMENT] Unlocking ad_adop_sessions table for sebs4101lx with wait interval of 60 seconds and number of tries 2

[ErmanArslansOracleBlog]

Okay...
we are going back to where we have started.

Earlier I recommend you to take a look at the log files and implement the following;

-->
This may be related with "Use of uninitialized value $result in split" In File txkADOPValidations.error"
But it needs to be checked from the logs..
Anyways if it is related with it, you will be following -> "Error "Use of uninitialized value $result in split" In File txkADOPValidations.error When Running fs_clone (Doc ID 2090393.1)".

check this link, similar issue : here -> http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/I-cannot-execute-the-adopt-prepare-after-cloning-the-environment-td1922.html 

[Emmanuel Sanabria]

Same result. After executing the CtxSynchronizer on the base there is no data.

select distinct(PATH) from FND_OAM_CONTEXT_FILES where NAME not in ('TEMPLATE','METADATA','config.txt') and CTX_TYPE='A' and (status is null or upper(status) in ('S','F')) and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'patch';

no rows selected

[ErmanArslansOracleBlog]

We need more debug on ctxSynchronizer...
This is a java program.
We need to enable debug on java.

We have static final boolean c_bDebugMode = Boolean.getBoolean("DEBUG_MODE"); for enabling debug in these classes.


so if we execute this java classes with -DDEBUG_MODE=true , we will get the debug info written in our logfile.

* So , please run your command with -DDEBUG_MODE=true  and upload the result *, as shown in the example below.

Example:

[applmgr@daroratestappsrv1 util]$ $ADJVAPRG -DDEBUG_MODE=true oracle.apps.ad.autoconfig.oam.CtxSynchronizer action=upload  contextfile=$CONTEXT_FILE logfile=/tmp/patchctxupload.log
Enter the APPS password:
DEBUG: InDbCtxFile.InDbCtxFileException() : Calling strd proc BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;
DEBUG: InDbCtxFile.InDbCtxFileException() : Calling strd proc BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;
DEBUG: InDbCtxFile.InDbCtxFileException() : Calling strd proc BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;
DEBUG: InDbCtxFile.InDbCtxFileException() : Calling strd proc BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;
DEBUG: InDbCtxFile.InDbCtxFileException() : Calling strd proc BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;
DEBUG: InDbCtxFile.InDbCtxFileException() : Calling strd proc BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;
DEBUG: InDbCtxFile.InDbCtxFileException() : Calling strd proc BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;
DEBUG: InDbCtxFile.InDbCtxFileException() : Calling strd proc BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;
DEBUG: InDbCtxFile.uploadCtx() : Calling strd proc BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;
with params:
        file: /u01/install/APPS/fs2/inst/apps/ORATEST_daroratestappsrv1/appl/admin/ORATEST_daroratestappsrv1.xml
        sContextType: APPS
        sFileType: CONTEXT
DEBUG: InDbCtxFile.InDbCtxFileException() : '/u01/install/APPS/fs2/inst/apps/ORATEST_daroratestappsrv1/appl/admin/ORATEST_daroratestappsrv1.xml' uploaded successfully!

[Emmanuel Sanabria]

Hi erman

[applmgr@sebs4101lx ~]$ $ADJVAPRG -DDEBUG_MODE=true oracle.apps.ad.autoconfig.oam.CtxSynchronizer action=upload  contextfile=/u01/install/APPS/fs2/inst/apps/OEBT1N_sebs4101lx/appl/admin/OEBT1N_sebs4101lx.xml logfile=/tmp/patchctxupload.log
Enter the APPS password:
DEBUG: InDbCtxFile.InDbCtxFileException() : Calling strd proc BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;
DEBUG: InDbCtxFile.InDbCtxFileException() : Calling strd proc BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;
DEBUG: InDbCtxFile.InDbCtxFileException() : Calling strd proc BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;
DEBUG: InDbCtxFile.InDbCtxFileException() : Calling strd proc BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;
DEBUG: InDbCtxFile.InDbCtxFileException() : Calling strd proc BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;
DEBUG: InDbCtxFile.InDbCtxFileException() : Calling strd proc BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;
DEBUG: InDbCtxFile.InDbCtxFileException() : Calling strd proc BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;
DEBUG: InDbCtxFile.InDbCtxFileException() : Calling strd proc BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;
DEBUG: InDbCtxFile.uploadCtx() : Calling strd proc BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;
with params:
        file: /u01/install/APPS/fs2/inst/apps/OEBT1N_sebs4101lx/appl/admin/OEBT1N_sebs4101lx.xml
        sContextType: APPS
        sFileType: CONTEXT
DEBUG: InDbCtxFile.InDbCtxFileException() : '/u01/install/APPS/fs2/inst/apps/OEBT1N_sebs4101lx/appl/admin/OEBT1N_sebs4101lx.xml' uploaded successfully!
[applmgr@sebs4101lx ~]$

""""""
SQL> select distinct(PATH) from FND_OAM_CONTEXT_FILES where NAME not in ('TEMPLATE','METADATA','config.txt') and CTX_TYPE='A' and (status is null or upper(status) in ('S','F')) and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'patch';

no rows selected


######

adopscanlog -latest=yes
Lines #(136-141):
    [PROCEDURE] Calling: /u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl
    [EVENT]     Log: /u01/install/APPS/fs_ne/EBSapps/log/adop/70/20170209_164742/prepare/validate/sebs4101lx
    [UNEXPECTED]Error occurred running "perl /u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u01/install/APPS/fs2/inst/apps/OEBT1N_sebs4101lx/appl/admin/OEBT1N_sebs4101lx.xml -patchctxfile=/u01/install/APPS/fs1/inst/apps/OEBT1N_sebs4101lx/appl/admin/OEBT1N_sebs4101lx.xml -phase=prepare -logloc=/u01/install/APPS/fs_ne/EBSapps/log/adop/70/20170209_164742/prepare/validate/sebs4101lx -promptmsg=hide"
    [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on sebs4101lx
[PROCEDURE] [START 2017/02/09 16:51:09] Unlocking sessions table
[STATEMENT] Unlocking ad_adop_sessions table for sebs4101lx with wait interval of 60 seconds and number of tries 2