ADOP Errors and Solutions

Error:
Lines #(178-182):
              [EVENT]     Calling: /opt/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl
              [STATEMENT] Output directory: /opt/oracle/TEST/fs_ne/EBSapps/log/adop/7/prepare_20160416_143741/PROD_appsprod
              [UNEXPECTED]Error occurred while executing "perl /opt/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/opt/oracle/TEST/fs1/inst/apps/PROD_appsprod/appl/admin/PROD_appsprod.xml -patchcontextfile=/opt/oracle/TEST/fs2/inst/apps/PROD_appsprod/appl/admin/PROD_appsprod.xml -promptmsg=hide -console=off -patchtop=/opt/oracle/TEST/fs_ne/EBSapps/patch -mode=update -sessionid=7 -timestamp=20160416_143741 -workercount=32 -outdir=/opt/oracle/TEST/fs_ne/EBSapps/log/adop/7/prepare_20160416_143741/PROD_appsprod -autoskip=No"
              [UNEXPECTED]Error while runSyncFS sub-routine is called
              [PROCEDURE] [START 2016/04/16 14:39:50] Check and Stop patch Admin Server

Lines #(179-183):
              [STATEMENT] Output directory: /opt/oracle/TEST/fs_ne/EBSapps/log/adop/7/prepare_20160416_143741/PROD_appsprod
              [UNEXPECTED]Error occurred while executing "perl /opt/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/opt/oracle/TEST/fs1/inst/apps/PROD_appsprod/appl/admin/PROD_appsprod.xml -patchcontextfile=/opt/oracle/TEST/fs2/inst/apps/PROD_appsprod/appl/admin/PROD_appsprod.xml -promptmsg=hide -console=off -patchtop=/opt/oracle/TEST/fs_ne/EBSapps/patch -mode=update -sessionid=7 -timestamp=20160416_143741 -workercount=32 -outdir=/opt/oracle/TEST/fs_ne/EBSapps/log/adop/7/prepare_20160416_143741/PROD_appsprod -autoskip=No"
              [UNEXPECTED]Error while runSyncFS sub-routine is called
              [PROCEDURE] [START 2016/04/16 14:39:50] Check and Stop patch Admin Server
                [EVENT]     [START 2016/04/16 14:39:51] Check and Stop patch FS Admin Server

Lines #(188-192):
                [EVENT]     [END   2016/04/16 14:39:59] Check and Stop patch Node Manager
              [PROCEDURE] [END   2016/04/16 14:39:59] Check and Stop patch Node Manager
              [ERROR]     Prepare phase completed with errors or warnings. Please check logfiles.
              [STATEMENT] SQL statement : "  update ad_adop_sessions
  set status='F'

/opt/oracle/TEST/fs_ne/EBSapps/log/adop/7/prepare_20160416_143741/PROD_appsprod/TXK_SYNC_update_Sat_Apr_16_14_39_29_2016/txkADOPPreparePhaseSynchronize_Sat_Apr_16_14_39_29_2016.log: 
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Lines #(502-504):
TIME    : Sat Apr 16 14:39:50 2016
FUNCTION: main::execADPATCH [ Level 1 ] 
ERRORMSG: Application of patch did not go through successfully.


in abort.log file if you found these lines:

create or replace package APPS_DDL AUTHID DEFINER as * ERROR at line 1: ORA-00955: name is already used by an existing object

Solution:

Execute below query:

select * from dba_objects where object_name like '%APPS_DDL%' and object_type not in ('PACKAGE','PACKAGE BODY'); 


Drop synonym appeared in above query output.

Oracle Clone keep pointing to Source Server

Error:

When Set enviornment desitnation clone keep pointing to source server, This is the bug and the solution is:

grep: /d01/oracle/TEST/fs1/inst/apps/TEST_pcltest/appl/admin/TEST_pcltest.xml: No such file or directory

grep: /d01/oracle/TEST/fs1/inst/apps/TEST_pcltest/appl/admin/TEST_pcltest.xml: No such file or directory

grep: /d01/oracle/TEST/fs1/inst/apps/TEST_pcltest/appl/admin/TEST_pcltest.xml: No such file or directory

Solution:

The issue is a bug (yet to be logged) caused when using similar hostname from Source and Target, eg test & pcltest been used for your systems, but we can easily work around the issue by modifying the node_info.txt file 

1. On Target nodes backup and then open 

/opt/oracle/TEST/fs1/FMW_Home/Oracle_EBS-app1/applications/oacore/APP-INF/node_info.txt 

/opt/oracle/TEST/fs2/FMW_Home/Oracle_EBS-app1/applications/oacore/APP-INF/node_info.txt