本文档详细记录了Oracle E-Business Suite R12.2系统的补丁安装过程，包括adgrants.sql的执行和多个补丁（如32394134、33441060、33550674）的热补丁应用。在应用过程中遇到了无法识别有效应用层级节点的问题，以及警告提示缺少多个数据库修复。通过执行adopphase命令进行应用、重启和回滚操作，并最终成功完成补丁应用。
EBS R12.2,新安装的，没有安装任何补丁。
R12.2的安装可以参考文档：(1条消息) EBS R12.2的安装_文档搬运工的博客-CSDN博客
AD和TXK的补丁，可以参考文档： Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
--安装过程
按照MOS文档，运行adgrants.sql等后。
--32394134
[applprod@erptest 2]$ adop phase=apply patches=32394134 hotpatch=yes restart=yes
Enter the APPS password:
Enter the EBS_SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /u01/oracle/PROD/fs1/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml
Patch edition context: /u01/oracle/PROD/fs2/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml
*******FATAL ERROR*******
PROGRAM : (/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Sun May 22 11:32:35 2022
FUNCTION: ADOP::GlobalVars::_GetMandatoryArgs [ Level 1 ]
ERRORMSG: Cannot identify any valid application tier nodes in
ADOP_VALID_NODES table. Ensure AutoConfig has been run on all nodes.
adop exiting with status = 255 (Fail)
[applprod@erptest 2]$ adop phase=apply patches=32394134 hotpatch=yes
Enter the APPS password:
Enter the EBS_SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /u01/oracle/PROD/fs1/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml
Patch edition context: /u01/oracle/PROD/fs2/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml
*******FATAL ERROR*******
PROGRAM : (/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Sun May 22 11:33:39 2022
FUNCTION: ADOP::GlobalVars::_GetMandatoryArgs [ Level 1 ]
ERRORMSG: Cannot identify any valid application tier nodes in
ADOP_VALID_NODES table. Ensure AutoConfig has been run on all nodes.
adop exiting with status = 255 (Fail)
[applprod@erptest 2]$ adop phase=abort
Enter the APPS password:
Enter the EBS_SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /u01/oracle/PROD/fs1/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml
Patch edition context: /u01/oracle/PROD/fs2/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml
*******FATAL ERROR*******
PROGRAM : (/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Sun May 22 11:34:09 2022
FUNCTION: ADOP::GlobalVars::_GetMandatoryArgs [ Level 1 ]
ERRORMSG: Cannot identify any valid application tier nodes in
ADOP_VALID_NODES table. Ensure AutoConfig has been run on all nodes.
adop exiting with status = 255 (Fail)
[applprod@erptest 2]$
[applprod@erptest 2]$
[applprod@erptest 2]$ adop phase=apply patches=32394134 hotpatch=yes
Enter the APPS password:
Enter the EBS_SYSTEM password:
Enter the EBS_SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /u01/oracle/PROD/fs1/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml
Patch edition context: /u01/oracle/PROD/fs2/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml
*******FATAL ERROR*******
PROGRAM : (/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Sun May 22 11:42:49 2022
FUNCTION: ADOP::GlobalVars::_validateApplyRestartArgs [ Level 1 ]
ERRORMSG: When running adop after a previous patching cycle failed, you must specify either the 'abandon' or 'restart' parameter .
adop exiting with status = 255 (Fail)
[applprod@erptest 2]$ adop phase=apply patches=32394134 hotpatch=yes restart=yes
Enter the APPS password:
Enter the EBS_SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /u01/oracle/PROD/fs1/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml
Patch edition context: /u01/oracle/PROD/fs2/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml
Patch file system free space: 147.33 GB
Validating system setup.
Node registry is valid.
[WARNING] ETCC: The following required database fixes have not been applied to node erptest:
8975044
14666816
17777718
18793246
18881811
19068380
19189525
19239846
19509982
19591608
19665139
20627866
20766180
20868862
21028698
21106027
21293453
21321429
21322448
21387964
21614112
21626377
21751519
21813400
21864513
21904072
21967332
22024071
22146267
22229581
22331786
22452653
22496904
22568797
22660003
22666802
22731026
22737974
23089357
23125826
23220453
23604553
23632545
23645516
24326444
24385983
24560906
24589081
25099339
25139545
25305405
25643931
25906117
25971286
26336977
26436717
26654363
26658759
26742604
26798411
27929509
27997875
28201045
28507324
28542455
29125374
30758943
31404014
32355765
32652143
32988028
Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.
[WARNING] MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh.
Checking for existing adop sessions.
Session Id : 2
Prepare phase status : NOT APPLICABLE
Apply phase status : ATLEAST ONE PATCH IS ALREADY APPLIED
Cutover phase status : NOT APPLICABLE
Abort phase status : NOT APPLICABLE
Session status : FAILED
Continuing with existing session [Session ID: 2].
Key: "loglevel" Value: "event"
Key: "prevdata_recom_workers" Value: ""
Key: "prevdata_recom_workers" Value: ""
Key: "merge" Value: "no"
Key: "merge" Value: "no"
Key: "prevdata_max_workers" Value: ""
Key: "prevdata_max_workers" Value: ""
Key: "restart" Value: "yes"
Key: "restart" Value: "yes"
Key: "super_node" Value: "HASH(0x19a00bf0)"
Key: "super_node" Value: "HASH(0x19a00bf0)"
Key: "allowcoredump" Value: "No"
Key: "allowcoredump" Value: "No"
Key: "prevdata_mtrestart" Value: ""
Key: "prevdata_mtrestart" Value: ""
Key: "dbloglevel" Value: "disable"
Key: "dbloglevel" Value: "disable"
Key: "analytics" Value: "0"
Key: "analytics" Value: "0"
Key: "force" Value: "0"
Key: "force" Value: "0"
Key: "prevdata_logidentmode" Value: ""
Key: "prevdata_logidentmode" Value: ""
Key: "prevdata_patchtop" Value: ""
Key: "prevdata_patchtop" Value: ""
Key: "runcontextfile" Value: "/u01/oracle/PROD/fs1/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml"
Key: "runcontextfile" Value: "/u01/oracle/PROD/fs1/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml"
Key: "appltop_id" Value: "196"
Key: "appltop_id" Value: "196"
Key: "ebssystemuser" Value: "EBS_SYSTEM"
Key: "ebssystemuser" Value: "EBS_SYSTEM"
Key: "patches" Value: "32394134"
Key: "patches" Value: "32394134"
[END 2022/05/22 11:44:00] Refreshing session input data
[START 2022/05/22 11:44:00] Unlocking sessions table
[END 2022/05/22 11:44:00] Unlocking sessions table
[START 2022/05/22 11:44:00] Running adzdoptl.pl
===========================================================================
ADOP (C.Delta.)
Session ID: 2
Node: erptest
Phase: apply
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/20220522_114306/adop_20220522_063554.log
===========================================================================
[START 2022/05/22 11:44:03] Checking status of phase
SQL Output: "1".
[START 2022/05/22 11:44:03] Checking status of phase
SQL Output: "0".
[END 2022/05/22 11:44:03] Checking status of phase
[START 2022/05/22 11:44:03] Running apply phase
[START 2022/05/22 11:44:03] Updating adop session status
[START 2022/05/22 11:44:03] Updating session process ID
[END 2022/05/22 11:44:04] Updating session process ID
[END 2022/05/22 11:44:04] Updating adop session status
[START 2022/05/22 11:44:04] Updating database input parameters
[END 2022/05/22 11:44:04] Updating database input parameters
[START 2022/05/22 11:44:04] Updating session timestamps
APPLY Phase START TIME: 22-05-2022 06:37:00
[END 2022/05/22 11:44:04] Updating session timestamps
[START 2022/05/22 11:44:04] Updating run edition name
[END 2022/05/22 11:44:05] Updating run edition name
[START 2022/05/22 11:44:07] Updating session status
[END 2022/05/22 11:44:07] Updating session status
Oracle E-Business Suite Online Patching
RUN edition environment variables have been set.
Applying patch 32394134.
Calling: adpatch abandon=no restart=yes workers=2 options=hotpatch console=no interactive=no defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs_ne/EBSapps/patch/32394134 driver=u32394134.drv logfile=u32394134.log
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/20220522_114306/apply/erptest/32394134/log/u32394134.log
Running: adpatch abandon=no restart=yes workers=2 options=hotpatch console=no interactive=no defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs_ne/EBSapps/patch/32394134 driver=u32394134.drv logfile=u32394134.log acp=yes
Successfully created out directory
Running finalize actions for the patches being applied.
Log: @ADZDSHOWLOG.sql "2022/05/22 12:00:27"
Running cutover actions for the patches being applied.
Oracle E-Business Suite Online Patching
RUN edition environment variables have been set.
Creating workers to process cutover DDL in parallel
[Start 2022/05/22 12:39:22] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
Reading defaults file /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt
Substituting tokens.
Regenerating defaults file.
[End 2022/05/22 12:39:22] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=2 restart=no abandon=yes defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cutover.log driver=ucutover.drv
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/20220522_114306/apply/erptest/log/cutover.log
Running: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=2 restart=no abandon=yes defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cutover.log driver=ucutover.drv acp=yes
Performing database cutover in Quick mode
[START 2022/05/22 13:41:42] Running cutover phase, as in hotpatch mode
[START 2022/05/22 13:41:42] Compiling invalid objects
[END 2022/05/22 13:42:02] Compiling invalid objects
Oracle E-Business Suite Online Patching
RUN edition environment variables have been set.
[START 2022/05/22 13:42:02] Updating session status
[END 2022/05/22 13:42:03] Updating session status
Generating post apply reports.
[START 2022/05/22 13:42:03] Updating session timestamps
APPLY Phase END TIME: 22-05-2022 13:42:03
[END 2022/05/22 13:42:03] Updating session timestamps
Generating log report.
[START 2022/05/22 13:42:03] Generating AD_ZD_LOGS report
Report: /u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql
Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/20220522_114306/apply/erptest/adzdshowlog.out
[END 2022/05/22 13:42:05] Generating AD_ZD_LOGS report
[START 2022/05/22 13:42:05] Updating adop session status
[END 2022/05/22 13:42:06] Updating adop session status
[END 2022/05/22 13:42:06] Running apply phase
[END 2022/05/22 13:42:06] Running adzdoptl.pl
The apply phase completed successfully.
adop exiting with status = 0 (Success)
[applprod@erptest 2]$ --3441060
[applprod@erptest 2]$ adop phase=apply patches=33441060 hotpatch=yes
Enter the APPS password:
Enter the EBS_SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /u01/oracle/PROD/fs1/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml
Patch edition context: /u01/oracle/PROD/fs2/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml
Patch file system free space: 147.32 GB
Validating system setup.
Node registry is valid.
[WARNING] ETCC: The following required database fixes have not been applied to node erptest:
8975044
14666816
17777718
18793246
18881811
19068380
19189525
19239846
19509982
19591608
19665139
20627866
20766180
20868862
21028698
21106027
21293453
21321429
21322448
21387964
21614112
21626377
21751519
21813400
21864513
21904072
21967332
22024071
22146267
22229581
22331786
22452653
22496904
22568797
22660003
22666802
22731026
22737974
23089357
23125826
23220453
23604553
23632545
23645516
24326444
24385983
24560906
24589081
25099339
25139545
25305405
25643931
25906117
25971286
26336977
26436717
26654363
26658759
26742604
26798411
27929509
27997875
28201045
28507324
28542455
29125374
30758943
31404014
32355765
32652143
32988028
Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.
[WARNING] MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh.
Checking for existing adop sessions.
[INFO] Connection to http://erptest.local:8000 successful
[WARNING] You should only specify hotpatch mode when directed to by the patch readme.
Continuing with the existing session [Session ID: 2].
===========================================================================
ADOP (C.Delta.13)
Session ID: 2
Node: erptest
Phase: apply
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/20220522_134607/adop.log
===========================================================================
Applying patch 33441060.
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/20220522_134607/apply/erptest/33441060/log/u33441060.log
Running finalize actions for the patches being applied.
Log: @ADZDSHOWLOG.sql "2022/05/22 13:49:01"
Running cutover actions for the patches being applied.
Creating workers to process cutover DDL in parallel
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/20220522_134607/apply/erptest/log/cutover.log
Performing database cutover in Quick mode
Generating post apply reports.
Generating log report.
Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/20220522_134607/apply/erptest/adzdshowlog.out
The apply phase completed successfully.
adop exiting with status = 0 (Success)
[applprod@erptest 2]$ --32392507
[applprod@erptest ~]$ adop phase=apply patches=32392507 hotpatch=yes restart=yes
Enter the APPS password:
Enter the EBS_SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /u01/oracle/PROD/fs1/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml
Patch edition context: /u01/oracle/PROD/fs2/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml
Patch file system free space: 147.12 GB
Validating system setup.
Node registry is valid.
[WARNING] ETCC: The following required database fixes have not been applied to node erptest:
8975044
14666816
17777718
18793246
18881811
19068380
19189525
19239846
19509982
19591608
19665139
20627866
20766180
20868862
21028698
21106027
21293453
21321429
21322448
21387964
21614112
21626377
21751519
21813400
21864513
21904072
21967332
22024071
22146267
22229581
22331786
22452653
22496904
22568797
22660003
22666802
22731026
22737974
23089357
23125826
23220453
23604553
23632545
23645516
24326444
24385983
24560906
24589081
25099339
25139545
25305405
25643931
25906117
25971286
26336977
26436717
26654363
26658759
26742604
26798411
27929509
27997875
28201045
28507324
28542455
29125374
30758943
31404014
32355765
32652143
32988028
Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.
[WARNING] MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh.
Checking for existing adop sessions.
Session Id : 2
Prepare phase status : NOT APPLICABLE
Apply phase status : ATLEAST ONE PATCH IS ALREADY APPLIED
Cutover phase status : NOT APPLICABLE
Abort phase status : NOT APPLICABLE
Session status : FAILED
Continuing with existing session [Session ID: 2].
===========================================================================
ADOP (C.Delta.13)
Session ID: 2
Node: erptest
Phase: apply
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/20220522_141031/adop.log
===========================================================================
Applying patch 32392507.
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/20220522_141031/apply/erptest/32392507/log/u32392507.log
New product CMI spliced. Use FNDCPASS to change the password.
New product YMS spliced. Use FNDCPASS to change the password.
Running finalize actions for the patches being applied.
Log: @ADZDSHOWLOG.sql "2022/05/22 14:26:26"
Running cutover actions for the patches being applied.
Creating workers to process cutover DDL in parallel
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/20220522_141031/apply/erptest/log/cutover.log
Performing database cutover in Quick mode
Generating post apply reports.
Generating log report.
Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/20220522_141031/apply/erptest/adzdshowlog.out
The apply phase completed successfully.
adop exiting with status = 0 (Success)
[applprod@erptest ~]$
--33550674
[applprod@erptest ~]$ adop phase=apply patches=33550674 hotpatch=yes
Enter the APPS password:
Enter the EBS_SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /u01/oracle/PROD/fs1/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml
Patch edition context: /u01/oracle/PROD/fs2/inst/apps/PROD_erptest/appl/admin/PROD_erptest.xml
Patch file system free space: 146.74 GB
Validating system setup.
Node registry is valid.
[WARNING] ETCC: The following required database fixes have not been applied to node erptest:
8975044
14666816
17777718
18793246
18881811
19068380
19189525
19239846
19509982
19591608
19665139
20627866
20766180
20868862
21028698
21106027
21293453
21321429
21322448
21387964
21614112
21626377
21751519
21813400
21864513
21904072
21967332
22024071
22146267
22229581
22331786
22452653
22496904
22568797
22660003
22666802
22731026
22737974
23089357
23125826
23220453
23604553
23632545
23645516
24326444
24385983
24560906
24589081
25099339
25139545
25305405
25643931
25906117
25971286
26336977
26436717
26654363
26658759
26742604
26798411
27929509
27997875
28201045
28507324
28542455
29125374
30758943
31404014
32355765
32652143
32988028
Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.
[WARNING] MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh.
Checking for existing adop sessions.
[INFO] Connection to http://erptest.local:8000 successful
[WARNING] You should only specify hotpatch mode when directed to by the patch readme.
Continuing with the existing session [Session ID: 2].
===========================================================================
ADOP (C.Delta.13)
Session ID: 2
Node: erptest
Phase: apply
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/20220522_143432/adop.log
===========================================================================
Applying patch 33550674.
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/20220522_143432/apply/erptest/33550674/log/u33550674.log
Running finalize actions for the patches being applied.
Log: @ADZDSHOWLOG.sql "2022/05/22 14:38:15"
Running cutover actions for the patches being applied.
Creating workers to process cutover DDL in parallel
Log: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/20220522_143432/apply/erptest/log/cutover.log
Performing database cutover in Quick mode
Generating post apply reports.
Generating log report.
Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/20220522_143432/apply/erptest/adzdshowlog.out
The apply phase completed successfully.
adop exiting with status = 0 (Success)
[applprod@erptest ~]$
END。
扫一扫
2961
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
