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
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
