1 2 Previous Next 19 Replies Latest reply: Feb 5, 2014 1:38 PM by stejac RSS

ebs 12.2 adop prepare

stejac Newbie
Currently Being Moderated

Hi Oracle Community

i installed ebs 12.2 on enterprise linux

but i have some problem with my adop phase=prepare autoconfig fail on fs2

i'm open to any idea

thanks

 

ADOP run:

#############################################################

...

AutoConfig will consider the custom templates if present.

  Using CONFIG_HOME location     : /u01/oracle/VIS12/fs2/inst/apps/VIS12_vision12

  Classpath                   : /u01/oracle/VIS12/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/oracle/VIS12/fs2/EBSapps/comn/java/classes

  Using Context file          : /u01/oracle/VIS12/fs2/inst/apps/VIS12_vision12/appl/admin/VIS12_vision12.xml

Context Value Management will now update the Context file

  Updating Context file...COMPLETED

  Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...

  Configuring AD_TOP........COMPLETED

  Configuring FND_TOP.......COMPLETED

  Configuring ICX_TOP.......COMPLETED

  Configuring MSC_TOP.......COMPLETED

  Configuring IEO_TOP.......COMPLETED

  Configuring BIS_TOP.......COMPLETED

  Configuring CZ_TOP........COMPLETED

  Configuring AMS_TOP.......COMPLETED

  Configuring CCT_TOP.......COMPLETED

  Configuring WSH_TOP.......COMPLETED

  Configuring CLN_TOP.......COMPLETED

  Configuring OKE_TOP.......COMPLETED

  Configuring OKL_TOP.......COMPLETED

  Configuring OKS_TOP.......COMPLETED

  Configuring CSF_TOP.......COMPLETED

  Configuring IBY_TOP.......COMPLETED

  Configuring JTF_TOP.......COMPLETED

  Configuring MWA_TOP.......COMPLETED

  Configuring CN_TOP........COMPLETED

  Configuring CSI_TOP.......COMPLETED

  Configuring WIP_TOP.......COMPLETED

  Configuring CSE_TOP.......COMPLETED

  Configuring EAM_TOP.......COMPLETED

  Configuring FTE_TOP.......COMPLETED

  Configuring ONT_TOP.......COMPLETED

  Configuring AR_TOP........COMPLETED

  Configuring AHL_TOP.......COMPLETED

  Configuring IES_TOP.......COMPLETED

  Configuring OZF_TOP.......COMPLETED

  Configuring CSD_TOP.......COMPLETED

  Configuring IGC_TOP.......COMPLETED

AutoConfig completed with errors.

            [ERROR]     Error occurred while executing <sh /u01/oracle/VIS12/fs1/EBSapps/appl/ad/12.0.0/bin/adconfig.sh contextfile=/u01/oracle/VIS12/fs2/inst/apps/VIS12_vision12/appl/admin/VIS12_vision12.xml promptmsg=hide log=/u01/oracle/VIS12/fs_ne/EBSapps/log/adop/2/prepare_20140123_101617/VIS12_vision12/adconfig.log>

            [ERROR]     Error while runPendingConfigClone sub-routine is called

...

########################################################

 

so i checked in adconfig log:

##########################################################

...

Library Path : /u01/oracle/VIS12/fs2/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/oracle/VIS12/fs2/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/oracle/VIS12/fs2/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/oracle/VIS12/fs2/EBSapps/appl/cz/12.0.0/bin:/u01/oracle/VIS12/fs2/EBSapps/10.1.2/lib32:/u01/oracle/VIS12/fs2/EBSapps/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/VIS12/fs2/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/oracle/VIS12/fs2/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/oracle/VIS12/fs2/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/oracle/VIS12/fs2/EBSapps/appl/sht/12.0.0/lib

 

SQLPLUS Executable : /u01/oracle/VIS12/fs2/EBSapps/10.1.2/bin/sqlplus

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jan 23 11:34:42 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.

define printer for reports ...

0 rows created.

insert into fnd_printer_tl

            *

ERROR at line 1:

ORA-20002: Seed Data Table has not been prepared for patching

ORA-06512: at "APPS.FND_PRINTER_TL+", line 1

ORA-04088: error during execution of trigger 'APPS.FND_PRINTER_TL+'

...

###########################################################

  • 1. Re: ebs 12.2 adop prepare
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    i installed ebs 12.2 on enterprise linux

     

    Was the application upgraded to 12.2.2 or 12.2.3 yet?

     

    What are the steps you have followed so far?

     

    Thanks,

    Hussein

  • 2. Re: ebs 12.2 adop prepare
    stejac Newbie
    Currently Being Moderated

    Hi Hussein

    # installed 12.2

    # strated the apps was running great

    # activated FRC as secondary language (keep US as base)

    # run patch wizard and downloaded 2 patch for analyse

    # stopped the apps to save some memory (keep admin server running for adop)

    # run adop phase=prepare

     

    thats where i'm

    thanks

  • 3. Re: ebs 12.2 adop prepare
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    # run patch wizard and downloaded 2 patch for analyse

     

    What are the two patch that you are trying to apply?

     

    The error you are getting is an expected one if you are on 12.2, and you will need to proceed with 12.2.2/12.2.3 upgrade first (latter is recommended) before applying any other application patches.

     

    Thanks,

    Hussein

  • 4. Re: ebs 12.2 adop prepare
    stejac Newbie
    Currently Being Moderated

    Hi Hussein

    these are the 2 patch that patch wizard downloaded

    [oracle@vision12 patch_wizard]$ ls nonad/

    p17021789_R12.TXK.C_R12_frc.zip  p17021789_R12.TXK.C_R12_GENERIC.zip

    [oracle@vision12 patch_wizard]$ ls ad/

    p17023760_R12.AD.C_R12_frc.zip  p17023760_R12.AD.C_R12_LINUX.zip

     

    but i'm still in "prepare" step nothing is applyed

    like Doc ID 1586217.1 path B

  • 5. Re: ebs 12.2 adop prepare
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    Those two patches should be applied using:

     

    adop phase=apply patches=17021789 hotpatch=yes

    adop phase=apply patches=17023760 hotpatch=yes

     

    So, are you using the same syntax?

     

    Thanks,

    Hussein

  • 6. Re: ebs 12.2 adop prepare
    stejac Newbie
    Currently Being Moderated

    Hi hussein

    Doc ID 1586217.1 path B

    is not telling me to do it in hot mode

    will try your way

    thanks

  • 7. Re: ebs 12.2 adop prepare
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    Thanks.

     

    Before suggesting a workaround, can you please confirm that you have applied (the consolidated seed table upgrade Patch 17204589 (17204589:12.2.0) on the Run File system using adop hotpatch mode)?

     

    Thanks,

    Hussein

  • 8. Re: ebs 12.2 adop prepare
    stejac Newbie
    Currently Being Moderated

    ok understand that i should be in path A instead

    will add 17204589 too

    thanks

  • 9. Re: ebs 12.2 adop prepare
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    stejac wrote:

     

    ok understand that i should be in path A instead

    will add 17204589 too

    thanks

     

    Yes please, apply this patch then run "adop phase=prepare" which should complete successfully this time.

     

    Thanks,

    Hussein

  • 10. Re: ebs 12.2 adop prepare
    stejac Newbie
    Currently Being Moderated

    Hi

    patched perfectly

    tryed adop phase=fs_clone  (Doc ID 1586217.1 last step)

    but got :

    ##########################################################

    ERROR while running FSCloneApply...

    Sat Jan 25 15:38:12 2014

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

    PROGRAM : (/u01/oracle/VIS12/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)

    TIME    : Sat Jan 25 15:38:12 2014

    FUNCTION: main::runFSCloneApply [ Level 1 ]

    ERRORMSG: /u01/oracle/VIS12/fs1/EBSapps/comn/clone/bin/adclone.pl did not go through successfully.

     

     

              [UNEXPECTED]Error occurred while executing <perl /u01/oracle/VIS12/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/u01/oracle/VIS12/fs1/inst/apps/VIS12_vision12/appl/admin/VIS12_vision12.xml -patchcontextfile=/u01/oracle/VIS12/fs2/inst/apps/VIS12_vision12/appl/admin/VIS12_vision12.xml -promptmsg=hide -console=off -mode=create -sessionid=4 -timestamp=20140125_095759 -outdir=/u01/oracle/VIS12/fs_ne/EBSapps/log/adop/4/fs_clone_20140125_095759/VIS12_vision12>

              [UNEXPECTED]Error occurred while CLONE Patch File System from Run File System using command: <perl /u01/oracle/VIS12/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/u01/oracle/VIS12/fs1/inst/apps/VIS12_vision12/appl/admin/VIS12_vision12.xml -patchcontextfile=/u01/oracle/VIS12/fs2/inst/apps/VIS12_vision12/appl/admin/VIS12_vision12.xml -promptmsg=hide -console=off -mode=create -sessionid=4 -timestamp=20140125_095759 -outdir=/u01/oracle/VIS12/fs_ne/EBSapps/log/adop/4/fs_clone_20140125_095759/VIS12_vision12>.

              [UNEXPECTED]fs_clone phase completed with errors/warnings. Please check logfiles

              Log file: /u01/oracle/VIS12/fs_ne/EBSapps/log/adop/4/adop_20140125_095759.log

     

     

    adop exiting with status = 2 (Fail)

    #########################################################

     

    any idea ?

  • 11. Re: ebs 12.2 adop prepare
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    I cannot really tell why it's failing without reviewing the log files first.

     

    Thanks,

    Hussein

  • 12. Re: ebs 12.2 adop prepare
    stejac Newbie
    Currently Being Moderated

    sorry forgot to add that log but it does't add lot more

     

    ##############################

        Log file: /u01/oracle/VIS12/fs_ne/EBSapps/log/adop/4/adop_20140125_095759.log

    [START 2014/01/25 09:57:59] Performing verification of parameters

    [END   2014/01/25 09:58:28] Performing verification of parameters

    [STATEMENT] Sourcing the Run Edition environment: /u01/oracle/VIS12/fs1/EBSapps/appl/APPSVIS12_vision12.env

    [EVENT]     [START 2014/01/25 09:58:29] Checking for the required ENV setup

    [EVENT]     [END   2014/01/25 09:58:30] Checking for the required ENV setup

    [STATEMENT] Using 3 workers (Default: 3, Recommended maximum limit: 83)

    [PROCEDURE] [START 2014/01/25 09:58:31] Determining admin node

    [PROCEDURE] [END   2014/01/25 09:58:33] Determining admin node

    [PROCEDURE] [START 2014/01/25 09:58:36] Acquiring lock on sessions table

      [STATEMENT] SQL stmt: <       begin

              AD_ZD_ADOP.LOCK_SESSIONS_TABLE('vision12',60,2);

           end;

    >

     

     

    [PROCEDURE] [END   2014/01/25 09:58:38] Acquiring lock on sessions table

    [EVENT]     [START 2014/01/25 09:58:39] Checking for any pending sessions

      [PROCEDURE] inside checkAciveHotPatchSession

      [STATEMENT] Statement: <    select count(1) from ad_adop_sessions

          where status <> 'C' and prepare_status='X' and cutover_status='X' and

                abort_status='X' and apply_status in ('N','P') and cleanup_status='N'

                and appltop_id=1045 and node_name='vision12'

    >.

      [STATEMENT] value of incomplete_session: <0>

      [PROCEDURE] leaving checkAciveHotPatchSession

      [STATEMENT] Master Session Id: <>

      [PROCEDURE] [START 2014/01/25 09:58:49] Staging the current session

        [STATEMENT]  sql statement: <       select  node_name||',' from ad_adop_session_patches

            where bug_number='CLONE' and status='N' and (adop_session_id >= (select

    NVL(max(adop_session_id),0) from ad_adop_sessions) and adop_session_id =

    (select NVL(max(adop_session_id),0) from ad_adop_session_patches))

    >

        [STATEMENT] Value of failed nodes : <>

     

     

        [STATEMENT]  sql statement: <       select  node_name||',' from ad_adop_session_patches

            where  bug_number='CLONE' and status='C' and (adop_session_id >= (select

    NVL(max(adop_session_id),0) from ad_adop_sessions) and adop_session_id =

    (select NVL(max(adop_session_id),0) from ad_adop_session_patches))

    >

        [STATEMENT] Value of completed nodes : <>

     

     

        [STATEMENT]  sql statement: <        select ad_adop_session_id_seq.nextval from dual

    >

        [STATEMENT] SQL stmt: <       insert into ad_adop_session_patches

           (ADOP_SESSION_ID,BUG_NUMBER,PATCHRUN_ID,STATUS,APPLIED_FILE_SYSTEM_BASE,PATCH_FILE_SYSTEM_BASE,

            ADPATCH_OPTIONS,APPLTOP_ID,NODE_NAME,AUTOCONFIG_STATUS,START_DATE,CLONE_STATUS)

           VALUES

           (4,'CLONE',NULL,'N','/u01/oracle/VIS12/fs1','/u01/oracle/VIS12/fs2',NULL,

            '1045','vision12','N',to_date('25-01-2014 09:58:59','DD-MM-YYYY HH24:MI:SS'),'NOT-STARTED')

    >

     

     

      [PROCEDURE] [END   2014/01/25 09:59:03] Staging the current session

      [PROCEDURE] [START 2014/01/25 09:59:04] Unlocking sessions table

        [STATEMENT] SQL stmt: <       begin

              AD_ZD_ADOP.UNLOCK_SESSIONS_TABLE('vision12',60,2);

           end;

    >

     

     

      [PROCEDURE] [END   2014/01/25 09:59:07] Unlocking sessions table

      [START 2014/01/25 09:59:07] adzdoptl.pl run

        ADOP Session ID: 4

        Phase: fs_clone

        [START 2014/01/25 09:59:09] fs_clone phase

          [EVENT]     [START 2014/01/25 09:59:12] Performing CLONE Steps

            [EVENT]     [START 2014/01/25 09:59:13] CLONE Patch File System from Run File System

              [EVENT]     Calling: /u01/oracle/VIS12/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl

              [STATEMENT] Output directory: /u01/oracle/VIS12/fs_ne/EBSapps/log/adop/4/fs_clone_20140125_095759/VIS12_vision12

              [UNEXPECTED]Error occurred while executing <perl /u01/oracle/VIS12/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/u01/oracle/VIS12/fs1/inst/apps/VIS12_vision12/appl/admin/VIS12_vision12.xml -patchcontextfile=/u01/oracle/VIS12/fs2/inst/apps/VIS12_vision12/appl/admin/VIS12_vision12.xml -promptmsg=hide -console=off -mode=create -sessionid=4 -timestamp=20140125_095759 -outdir=/u01/oracle/VIS12/fs_ne/EBSapps/log/adop/4/fs_clone_20140125_095759/VIS12_vision12>

              [UNEXPECTED]Error occurred while CLONE Patch File System from Run File System using command: <perl /u01/oracle/VIS12/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/u01/oracle/VIS12/fs1/inst/apps/VIS12_vision12/appl/admin/VIS12_vision12.xml -patchcontextfile=/u01/oracle/VIS12/fs2/inst/apps/VIS12_vision12/appl/admin/VIS12_vision12.xml -promptmsg=hide -console=off -mode=create -sessionid=4 -timestamp=20140125_095759 -outdir=/u01/oracle/VIS12/fs_ne/EBSapps/log/adop/4/fs_clone_20140125_095759/VIS12_vision12>.

              [PROCEDURE] [START 2014/01/25 15:38:23] Check and Stop Patch Admin Server

                [STATEMENT]         select count(1) from ad_adop_session_patches

            where applied_file_system_base='/u01/oracle/VIS12/fs1' and

            patch_file_system_base='/u01/oracle/VIS12/fs2' and

            bug_number IN ('CLONE','CONFIG_CLONE') and

            status IN ('N','F')

     

     

                [STATEMENT] There is a pending clone session for /u01/oracle/VIS12/fs2.

                [STATEMENT] Skipping Check and Stop Patch Admin Server Step.

              [PROCEDURE] [END   2014/01/25 15:38:31] Check and Stop Patch Admin Server

              [UNEXPECTED]fs_clone phase completed with errors/warnings. Please check logfiles

              [PROCEDURE] [START 2014/01/25 15:38:33] Unlocking sessions table

                [STATEMENT] SQL stmt: <       begin

              AD_ZD_ADOP.UNLOCK_SESSIONS_TABLE('vision12',60,2);

           end;

    >

     

     

              [PROCEDURE] [END   2014/01/25 15:38:36] Unlocking sessions table

              Log file: /u01/oracle/VIS12/fs_ne/EBSapps/log/adop/4/adop_20140125_095759.log

    ####################################

  • 13. Re: ebs 12.2 adop prepare
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    Will need to review the following logs:

     

    - All logs under /u01/oracle/VIS12/fs_ne/EBSapps/log/adop/4 (in one zip/tar file)

    - Zip of files in fs1/EBSapps/comn/clone/FMW/logs, fs2/EBSapps/comn/clone/FMW/logs directories

    - Zip of directory $APPLRGF/TXK/ohsCloneLog


    Thanks,

    Hussein

  • 14. Re: ebs 12.2 adop prepare
    stejac Newbie
    Currently Being Moderated

    Hi Hussein

    looks like i cant upload file in this forum so i putted them in skydrive

    https://skydrive.live.com/redir?resid=BFC8896D8EABB5F6%211086

     

    file 4.zip   =  /u01/oracle/VIS12/fs_ne/EBSapps/log/adop/4

    file ohsCloneLog.zip   =   $APPLRGF/TXK/ohsCloneLog

    Folder   fs1/EBSapps/comn/clone/FMW/logs     is empty

    Folder   fs2/EBSapps/comn/clone/FMW/logs     does not exist


    thanks

1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points