Saturday, 16 April 2016

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.



No comments:

Post a Comment