代码改变世界

Consolidated Seed Table Upgrade Patch(Patch 17204589)

2015-12-02 14:50  abce  阅读(772)  评论(0编辑  收藏  举报
$ adop phase=apply patches=17204589 hotpatch=yes abandon=no

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

 Please wait. Validating credentials...


Enter the RUN file system context file name [/app/oracle/apps/VIS/fs1/inst/apps/VIS_erptest/appl/admin/VIS_erptest.xml]: 

[STATEMENT] [END   2015/12/02 13:50:28] Performing verification of parameters
[STATEMENT] [START 2015/12/02 13:50:28] Checking for the required ENV setup 
[STATEMENT] [END   2015/12/02 13:50:29] Checking for the required ENV setup 

************* Start of  session *************
 version: 12.2.0
 started at: Wed Dec 02 2015 13:50:29

APPL_TOP is set to /app/oracle/apps/VIS/fs1/EBSapps/appl
[STATEMENT] [START 2015/12/02 13:50:29] Determining admin node
[STATEMENT] [END   2015/12/02 13:50:31] Determining admin node
[STATEMENT]  Recommended Worker Count:  4 Max Allowed Workers: 10
[STATEMENT] [START 2015/12/02 13:50:34] Acquiring lock on sessions table
[STATEMENT] [END   2015/12/02 13:50:35] Acquiring lock on sessions table
[STATEMENT] [START 2015/12/02 13:50:35] Checking for any pending sessions
[STATEMENT] There is already a hotpatch session which is incomplete. Details are:
[STATEMENT]     Session Id: 2
[STATEMENT]     Prepare phase status: X
[STATEMENT]     Apply phase status: P
[STATEMENT]     Cutover  phase status: R
[STATEMENT]     Abort phase status: X
[STATEMENT]     Session status: F
[STATEMENT] [Note: Y denotes that the phase is done
[STATEMENT]        N denotes that the phase has not been completed
[STATEMENT]        X denotes that the phase is not applicable
[STATEMENT]        R denotes that the phase is running (in progress) or ran
[STATEMENT]        F denotes that the phase has failed
[STATEMENT]        P (is applicable only to APPLY phase) denotes atleast
[STATEMENT]           one patch is already applied for the session id
[STATEMENT] Will continue with previous session  
[STATEMENT] [START 2015/12/02 13:50:51] Performing steps to get the previous session inputs
[STATEMENT] [END   2015/12/02 13:50:53] Performing steps to get the previous session inputs
[STATEMENT] Continuing 
[STATEMENT] [START 2015/12/02 13:50:56] Unlocking sessions table
[STATEMENT] [END   2015/12/02 13:50:56] Unlocking sessions table
[STATEMENT] [START 2015/12/02 13:50:56] adzdoptl.pl run
  [STATEMENT] Session ID: 2
  [STATEMENT] Phase: apply
  [STATEMENT] Log file: /app/oracle/apps/VIS/fs_ne/EBSapps/log/adop/2/adop_20151202_121011.log
  [STATEMENT] [START 2015/12/02 13:51:05] apply phase 
    [STATEMENT] APPLY Phase START TIME: 02-12-2015 13:51:06
    [STATEMENT] [START 2015/12/02 13:51:07] Performing Check for Logon Trigger existence and enablement
    [STATEMENT] [END   2015/12/02 13:51:09] Performing Check for Logon Trigger existence and enablement
    [STATEMENT] [Start 2015/12/02 13:51:13] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
      [STATEMENT] Reading defaults file /app/oracle/apps/VIS/fs1/EBSapps/appl/admin/VIS/adalldefaults.txt
      [STATEMENT] Substituting tokens ... 
      [STATEMENT] Regenerating defaults file ... 
    [STATEMENT] [End   2015/12/02 13:51:13] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
    [STATEMENT] Calling: adpatch  abandon=no  restart=yes  workers=4    options=hotpatch    flags=autoskip   console=no interactive=no  defaultsfile=/app/oracle/apps/VIS/fs1/EBSapps/appl/admin/VIS/adalldefaults.txt patchtop=/app/oracle/apps/VIS/fs_ne/EBSapps/patch/17204589 driver=u17204589.drv logfile=u17204589.log
    [STATEMENT] ADPATCH Log directory: /app/oracle/apps/VIS/fs_ne/EBSapps/log/adop/2/apply_20151202_135009/VIS_erptest/17204589/log
    [STATEMENT] Running: adpatch  abandon=no  restart=yes  workers=4    options=hotpatch    flags=autoskip   console=no interactive=no  defaultsfile=/app/oracle/apps/VIS/fs1/EBSapps/appl/admin/VIS/adalldefaults.txt patchtop=/app/oracle/apps/VIS/fs_ne/EBSapps/patch/17204589 driver=u17204589.drv logfile=u17204589.log stdin=yes

Successfully created out directory 
    [STATEMENT] [START 2015/12/02 14:09:44] Running finalize since in hotpatch mode
    [STATEMENT] [END   2015/12/02 14:31:28] Running finalize since in hotpatch mode
    [STATEMENT] [START 2015/12/02 14:31:28] Performing Automatic DB cutover
      [STATEMENT] [Start 2015/12/02 14:31:29] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
        [STATEMENT] Reading defaults file /app/oracle/apps/VIS/fs2/EBSapps/appl/admin/VIS_patch/adalldefaults.txt
        [STATEMENT] Substituting tokens ... 
        [STATEMENT] Regenerating defaults file ... 
      [STATEMENT] [End   2015/12/02 14:31:30] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
      [STATEMENT] Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=4 restart=no abandon=yes defaultsfile=/app/oracle/apps/VIS/fs1/EBSapps/appl/admin/VIS/adalldefaults.txt patchtop=/app/oracle/apps/VIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cutover.log driver=ucutover.drv
      [STATEMENT] ADPATCH Log directory: /app/oracle/apps/VIS/fs_ne/EBSapps/log/adop/2/apply_20151202_135009/VIS_erptest/log
      [STATEMENT] Running: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=4 restart=no abandon=yes defaultsfile=/app/oracle/apps/VIS/fs1/EBSapps/appl/admin/VIS/adalldefaults.txt patchtop=/app/oracle/apps/VIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cutover.log driver=ucutover.drv stdin=yes

Successfully created out directory 
    [STATEMENT] [END   2015/12/02 14:32:05] Performing Automatic DB cutover
    [STATEMENT] [START 2015/12/02 14:32:06] Running cutover since in hotpatch mode
    [STATEMENT] [END   2015/12/02 14:32:07] Running cutover since in hotpatch mode
    [STATEMENT] [START 2015/12/02 14:32:08] Compiling Invalid Objects
    [STATEMENT] [END   2015/12/02 14:32:14] Compiling Invalid Objects
  [STATEMENT] [END   2015/12/02 14:32:17] apply phase 
  [STATEMENT] [START 2015/12/02 14:32:18] Generating Post Apply Reports 
    [STATEMENT] APPLY Phase END TIME: 02-12-2015 14:32:19
      [STATEMENT] [START 2015/12/02 14:32:21] Generating Report to spool all logs from ad_zd_logs
        [STATEMENT] Report: /app/oracle/apps/VIS/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql

        [STATEMENT] Output: /app/oracle/apps/VIS/fs_ne/EBSapps/log/adop/2/apply_20151202_135009/VIS_erptest/adzdshowlog.out

      [STATEMENT] [END   2015/12/02 14:32:34] Generating Report to spool all logs from ad_zd_logs
  [STATEMENT] [END   2015/12/02 14:32:35] Generating Post Apply Reports 
[STATEMENT] [END   2015/12/02 14:32:37] adzdoptl.pl run
[STATEMENT] adop phase=apply - Completed Successfully

[STATEMENT] Log file: /app/oracle/apps/VIS/fs_ne/EBSapps/log/adop/2/adop_20151202_121011.log

adop exiting with status = 0 (Success)