Saturday, December 7, 2013

Finalize Phase - R12.2 Online Patching Cycle

Ready the instance for cutover
Perform the final operations like Compile Invalids , Generate Derived Objects and Pre-compute DDL to be run at the Cutover phase.
Facilitates verification of customizations or other objects that may be affected by a patch.
If you skip this phase it will be called automatically by the cutover phase.
Default mode is quick which does not gather statistics.
Full mode runs gather statistics to help improve performance. This more will take about one hour longer if specified.
adop phase=finalize finalize_mode=full

Scenario

You have been asked to apply a patch and you completed the prepare phase and apply phase. Now customer has given a downtime for the cutover.


When we can do it?
Before the cutover phase begins you can run the finalize phase.



$ adop phase=finalize

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

 Please wait. Validating credentials...

RUN file system context file: /inst122i/applmgr/fs2/inst/apps/INST122I_testserver01/appl/admin/INST122I_testserver01.xml
PATCH file system context file: /inst122i/applmgr/fs1/inst/apps/INST122I_testserver01/appl/admin/INST122I_testserver01.xml

************* Start of  session *************
 version: 12.2.0
 started at: Sun Nov 17 2013 03:08:09

APPL_TOP is set to /inst122i/applmgr/fs2/EBSapps/appl
  Using ADOP Session ID from currently incomplete patching cycle
[START 2013/11/17 03:08:43] adzdoptl.pl run
  ADOP Session ID: 9
  Phase: finalize
  Log file: /inst122i/applmgr/fs_ne/EBSapps/log/adop/9/adop_20131117_030749.log
  [START 2013/11/17 03:08:54] finalize phase
      [EVENT]     Running Finalize in QUICK mode
  [END   2013/11/17 03:09:23] finalize phase
  [START 2013/11/17 03:09:24] Generating Post Finalize Reports
  [END   2013/11/17 03:09:25] Generating Post Finalize Reports
  [START 2013/11/17 03:09:25] Generating AD_ZD_LOGS Report
      [EVENT]     Report: /inst122i/applmgr/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql

      [EVENT]     Output: /inst122i/applmgr/fs_ne/EBSapps/log/adop/9/finalize_20131117_030749/INST122I_testserver01/adzdshowlog.out

  [END   2013/11/17 03:09:30] Generating AD_ZD_LOGS Report
[END   2013/11/17 03:09:38] adzdoptl.pl run
adop phase=finalize - Completed Successfully

adop exiting with status = 0 (Success)
$
[STATEMENT] FINALIZE Phase START TIME: 17-11-2013 03:09:03
      [EVENT]     Running Finalize in QUICK mode
      [EVENT]     [START 2013/11/17 03:09:07] Making finalize call
        [PROCEDURE] [START 2013/11/17 03:09:11] Compiling Invalid Objects as part of Finalize
        [PROCEDURE] [END   2013/11/17 03:09:17] Compiling Invalid Objects as part of Finalize
      [EVENT]     [END   2013/11/17 03:09:18] Making finalize call
      [STATEMENT] SQL Statement:         update ad_adop_sessions
        set finalize_end_date=to_date('17-11-2013 03:09:19','DD-MM-YYYY HH24:MI:SS')
        where  adop_session_id=9
[STATEMENT] FINALIZE Phase END TIME: 17-11-2013 03:09:19


[START 2013/11/17 03:09:25] Generating AD_ZD_LOGS Report
    [PROCEDURE] [START 2013/11/17 03:09:26] Generating Report to spool all logs from ad_zd_logs
      [EVENT]     Report: /inst122i/applmgr/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql

      [EVENT]     Output: /inst122i/applmgr/fs_ne/EBSapps/log/adop/9/finalize_20131117_030749/INST122I_testserver01/adzdshowlog.out

    [PROCEDURE] [END   2013/11/17 03:09:30] Generating Report to spool all logs from ad_zd_logs
[END   2013/11/17 03:09:30] Generating AD_ZD_LOGS Report



Popular Posts