7 Replies Latest reply on Jan 4, 2017 7:21 AM by Shaik

    Upgrade EBS

    Beauty_and_dBest

      Hi ALL,

       

      My friend sent me this Upgrade script.

      I forgot what version is it for

      I guess is it for  EBS R12.1.3  to EBS R12.2.0?

       

      Please kindly help confirm what is this upgrade procedure for?

       

      Kind regards,

      jc

       

        

      SNO.Tasks
      1Drop event alert triggers in custom schemas (conditional):
      2Disable Custom Triggers
      3Apply Patch 13420532
      4Convert LONG/LONG RAW Data Type to CLOB
      5Create New Service Names (_patch)
      alter system set service_names='ERPA1',ERPA1_
      6Gather Stats
      FND_STATS.GATHER_SCHEMA_STATISTICS('ALL', 10, 8,'NOBACKUP', NULL, 'LASTRUN', 'GATHER AUTO', 10, 'N');
      7Rapidwiz - Create Upgrade File System
      1. run from applmgr on Apps Node
      8Change Audit Group State
      9Edit s_atName in fs1 and fs2 contextfiles and run Autoconfig
      10Use fs1 Appl Top .env file
      11Enable Maintenance Mode
      12Applying 10117518:
      1. Copy and run adgrants.sql from 18040523
      2. mkdir AD_source 10117518_CUP5 and "cp -r 10117518 18040523 AD_source"
      3. Merge 10117518 and 18040523
      admrgpch -s /erpapp/DBA/1224_main/pre_upg_driver/AD_source -d /erpapp/DBA/1224_main/pre_upg_driver/10117518_CUP5 -merge_name 10117518_cup5 -admode
      4. export LOGDIR=$APPL_TOP/admin/UPGDEV2
      5. cd /erpapp/DBA/1224_main/pre_upg_driver/10117518_CUP5
      6. adpatch workers=16
      13Drop VPD policies before starting Upgrade driver and enable after completion
      14Add Pre-Install patches
      15Merge u10124646.drv with Pre-Install patches
      cd $AU_TOP/patch/115/driver
      admrgpch -d . -preinstall -master u10124646.drv
      16Apply Upgrade Driver
      adpatch options=nocopyportion,nogenerateportion workers=48
      17FAILED: file pycustrs.sql on worker  1.
      Copy odf from 16536493
      Run the below queries:
      ALTER TABLE HR.PAY_CUSTOM_RESTRICTIONS_TL MODIFY (STANDARD_FORM_TITLE NULL);
      ALTER TABLE HR.PAY_CUSTOM_RESTRICTIONS_TL MODIFY (QUERY_FORM_TITLE NULL);

      Skip Job if fails on EGOSILDO.sql
      18Disable Maintenance Mode
      19cd <AD_TOP>/patch/115/sql
      sqlplus APPS/Xd0mc9ja @txkDropAdxPreAutoConfig.sql
      20Run rapidwiz 2nd time - Configure Upgraded file system
      21Apply GSCC and Online Patching Readiness Patch 18824534
      adpatch options=hotpatch
      22EXEC FND_ORACLE_USER_PKG.LOAD_ROW('EDOCVIEW', 'CUSTOM', 'INVALID', NULL, 'N', 'B');
      EXEC FND_ORACLE_USER_PKG.LOAD_ROW('HRTA', 'CUSTOM', 'INVALID', NULL, 'N', 'B');
      EXEC FND_ORACLE_USER_PKG.LOAD_ROW('QLIK_FIN', 'CUSTOM', 'INVALID', NULL, 'N', 'B');
      EXEC FND_ORACLE_USER_PKG.LOAD_ROW('QLIK_HR', 'CUSTOM', 'INVALID', NULL, 'N', 'B');
      EXEC FND_ORACLE_USER_PKG.LOAD_ROW('QLIK_MRO', 'CUSTOM', 'INVALID', NULL, 'N', 'B');
      EXEC FND_ORACLE_USER_PKG.LOAD_ROW('TADB', 'CUSTOM', 'INVALID', NULL, 'N', 'B');
      /
      23sqlplus system @$AD_TOP/sql/ADZDPSUM.sql
      mv adzdpsum.txt adzdpsum_pre_dbprep.txt
      24sqlplus system @$AD_TOP/sql/ADZDPMAN.sql
      mv adzdpman.txt adzdpman_pre_dbprep.txt
      25sqlplus system @$AD_TOP/sql/ADZDPAUT.sql
      mv adzdpaut.txt adzdpaut_pre_dbprep.txt
      26Review Reports
      27cd /export/home/oracle/vishnu/1224/17629476/files/rdbms/admin

      sqlplus '/as sysdba'
      @dbmsobj.sql
      @dbmsxdbschmig.sql
      @prvtxdbschmig.plb
      grant all on sys.dbms_objects_apps_utils to apps ;
      grant all on sys.xdb$moveSchemaTab to apps ;
      execute sys.dbms_metadata_util.load_stylesheets;
      alter package dbms_metadata_int compile plsql_ccflags = 'ku$xml_enabled:true';
      alter package ad_zd_prep compile;
      alter package ad_zd_prep compile body;
      28cd /u01/1224/db/appsutil/admin
      sqlplus '/as sysdba'
      @adgrants_18283295.sql
      @adgrants_20034256.sql
      29Apply 13543260
      adpatch options=hotpatch,forceapply workers=12
      30sqlplus apps/apps
      exec sys.utl_recomp.recomp_parallel;
      31cd $LOG_HOME/appl/op
      sqlplus apps @$AD_TOP/sql/ADZDEXRPT.sql
      sqlplus system @$AD_TOP/sql/ADZDPSUM.sql
      mv adzdpsum.txt adzdpsum_post_dbprep.txt
      sqlplus system @$AD_TOP/sql/ADZDPMAN.sql
      mv adzdpman.txt adzdpman_post_dbprep.txt
      sqlplus system @$AD_TOP/sql/ADZDPAUT.sql
      mv adzdpaut.txt adzdpaut_post_dbprep.txt
      sqlplus apps @$AD_TOP/sql/ADZDDBCC.sql
      32Refer to 12.2.4 Readme: 1617458.1
      33Apply latest AD and TXK C Patches:
      2. Copy patches to fs_ne/patch
      18283295:R12.AD.C.Delta.5
      20034256:R12.AD.C
      20075842:R12.AD.C
      18288881:R12.TXK.C.Delta.5
      20043910:R12.TXK.C
      19803392:R12.TXK.C
      20158287:R12.TXK.C
      19259764:R12.FND.C
      3. cd /erpapp/upgdev/fs1/EBSapps/appl
      . APPSUPGDEV_amdsc3-dev-zc1.env
      4. adop phase=apply patches=18283295,20034256,20075842 hotpatch=yes merge=yes workers=16
      5. adop phase=apply patches=18288881,20043910,19803392,20158287 hotpatch=yes merge=yes  workers=16
      34. EBSapps.env run
      35adadminsrvctl.sh stop
      36adnodemgrctl.sh stop
      37drop sequence apps.AHL_RT_OPER_DEP_S
      create table apps.AHL_RT_OPER_DEPENDENCIES_bak as select * from apps.AHL_RT_OPER_DEPENDENCIES
      drop table apps.AHL_RT_OPER_DEPENDENCIES
      38cp from upgdev2
      adop phase=apply apply_mode=downtime patches=17919161 workers=36
      Error: Existing object name matches
      Solution: drop sequence apps.AHL_RT_OPER_DEP_S
      39Attach Oracle Homes:
      /erpapp/upgdev2/fs1/FMW_Home/Oracle_EBS-app1/oui/bin
      ./runInstaller -silent -attachHome -invPtrLoc /var/opt/oracle/oraInst.loc ORACLE_HOME="/erpapp/upgdev2/fs1/FMW_Home/Oracle_EBS-app1" ORACLE_HOME_NAME="EBS_appl_UPG2"
      /erpapp/upgdev2/fs1/FMW_Home/webtier
      ./runInstaller -silent -attachHome -invPtrLoc /var/opt/oracle/oraInst.loc ORACLE_HOME="/erpapp/upgdev2/fs1/FMW_Home/webtier" ORACLE_HOME_NAME="UPGDEV2_WEB22_oracle"
      /erpapp/upgdev2/fs1/FMW_Home/oracle_common
      ./runInstaller -silent -attachHome -invPtrLoc /var/opt/oracle/oraInst.loc ORACLE_HOME="/erpapp/upgdev2/fs1/FMW_Home/oracle_common" ORACLE_HOME_NAME="UPGDEV2_oracle_common2"
      ./runInstaller -silent -attachHome -invPtrLoc /var/opt/oracle/oraInst.loc ORACLE_HOME="/erpapp/upgdev2/fs1/EBSapps/10.1.2" ORACLE_HOME_NAME="1012_new_UPG2"
      40adop phase=cleanup
      41adop phase=fs_clone
      42adop phase=apply patches=17919162,19290141 hotpatch=yes merge=yes workers=24
      43Copy Custom Top files fro 12.1.3 to 12.2.5
      44adcgnjar
      45cd $AD_TOP/patch/115/sql
      sqlplus apps/apps
      @txkDropAdxPreAutoConfig.sql
      46Run Autoconfig
        • 1. Re: Upgrade EBS
          mdtaylor

          Hi JC,

           

          It appears to be a 12.1.3 to 12.2.4 upgrade document.

           

          In general, I prefer to not rely on home baked upgrade documents as they are obsolete the moment they are created.  The technology patches are different each week after they are created. 

           

          Regards,

          Michael

          • 2. Re: Upgrade EBS
            Beauty_and_dBest

            Thanks Michael,

             

            But home baked documents are easier to understand vs that of the official docs which will set your brain to "crazy" mode

            Is it possible that I will follow the same procedure but I will get the latest technology patches?

             

            Can you give me the MOS notes id being referenced by this document?

            e.g > #1 - Drop event alert triggers in custom schemas (conditional):   << where can I find this?

             

             

            Kind regards,

            • 3. Re: Upgrade EBS
              Beauty_and_dBest

              Hi Michael and ALL,

               

              I thought someone mentioned in the forum, that you can not directly upgrade 12.1.3 to 12.2.4? You have to make it first to 12.2.0?

               

               

              Please comment....

               

              Kind regards,

              • 4. Re: Upgrade EBS
                SMOOTHEDATH

                Hi Jenna

                 

                You are upgrading to R12.2.0 , then enabling ADOP , then upgrading to 12.2.5

                Please let me know which package you are referring to

                 

                Sohin

                • 5. Re: Upgrade EBS
                  Shaik

                  Hi JC,

                   

                   

                  While performing upgrades will drop alert triggers and custom triggers and recreate after upgrade completes, we cant see this step in 11i to R12.2 upgrade guide

                   

                  Oracle® E-Business Suite Upgrade Guide Release 11i to 12.2 Part No. E48834-03

                  Oracle® E-Business Suite Upgrade Guide Release 12.0 and 12.1 to 12.2 Part No. E418839-15

                   

                  If you are upgrading from 11i to R12.2 or R12.1 to R12.2 please follow above documents

                   

                   

                  Above mentioned steps are consolidated and time to time we can see update in documents so patches are differ.

                  Above steps for upgrading 11i to R12.2, i can see the patches mentioned in upgrade document.

                   

                  You need to upgrade R12.2.0 first , enable ADOP and apply R12.2.4 Patchset

                   

                  Regards

                  Shaik

                  • 6. Re: Upgrade EBS
                    Beauty_and_dBest

                    Thanks ALL,

                     

                    I am confused now , why do patches in documents changed? Does this mean the official document provided erroneous or incomplete patches previously?

                    For example the document > Part No. E418839-15   , does this mean it is evolving or changing constantly?

                    Supposing I have downloaded the pdf copy of this document a month ago, do I need to download it again?

                     

                    My question is (given a premise: home-baked docs is easier to follow)....Is it okay to follow the  "home-baked" upgrade documents above (as my guide)? At the same time I will get the latest patch set in the official document?

                     

                     

                    Kind regards,

                    • 7. Re: Upgrade EBS
                      Shaik

                      Hi JC

                       

                      only tech patches will change,  that too we can can easily identify by running EBS Technology Codelevel Checker (ETCC)

                      Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Note 1594274.1)

                       

                      In upgrade guides which i mentioned earlier for 11i to R12.2 or R12.1 to R12.2 will not find more changes.

                       

                      If you are starting upgrade just check latest update document and follow the order mentioned.

                       

                       

                      Regards

                      Shaik