暂无图片
19c单实例+ASM打补丁
我来答
分享
pgone
2021-10-14
19c单实例+ASM打补丁

装好了db和gi软件,但还未创建实例,准备打补丁

1)应用补丁日志

[root@1ge153 ~]# opatchauto apply /oraru/31326369/31305339/

OPatchauto session is initiated at Thu Oct 14 14:02:05 2021

System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2021-10-14_02-02-08PM.log.

会话日志文件是/u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2021-10-14_02-02-11PM.log
此会话的 ID 为 71ZJ

Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid
Patch applicability verified successfully on home /u01/app/19.0.0/grid


Executing patch validation checks on home /u01/app/19.0.0/grid
Patch validation checks successfully completed on home /u01/app/19.0.0/grid


Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.0.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/1ge153/crsconfig/hapatch_2021-10-14_02-02-41PM.log
CRS service brought down successfully on home /u01/app/19.0.0/grid


Start applying binary patch on home /u01/app/19.0.0/grid
Binary patch applied successfully on home /u01/app/19.0.0/grid


Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.0.0/grid
Postpatch operation log file location: /u01/app/grid/crsdata/1ge153/crsconfig/hapatch_2021-10-14_02-08-28PM.log
CRS service started successfully on home /u01/app/19.0.0/grid

OPatchAuto 成功。

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:1ge153
SIHA Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /oraru/31326369/31305339/31281355
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-10-14_14-03-07下午_1.log

Patch: /oraru/31326369/31305339/31304218
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-10-14_14-03-07下午_1.log

Patch: /oraru/31326369/31305339/31305087
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-10-14_14-03-07下午_1.log

Patch: /oraru/31326369/31305339/31335188
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-10-14_14-03-07下午_1.log



OPatchauto session completed at Thu Oct 14 14:09:06 2021
Time taken to complete the session 7 minutes, 1 second
[root@1ge153 ~]#


2)应用OJVM日志

[oracle@1ge153 31219897]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2021, Oracle Corporation. All rights reserved.


Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.27
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2021-10-14_14-45-09PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 31219897

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/19.0.0/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '31219897' to OH '/u01/app/oracle/product/19.0.0/dbhome_1'

Patching component oracle.javavm.server, 19.0.0.0.0...

Patching component oracle.javavm.server.core, 19.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

Patching component oracle.rdbms, 19.0.0.0.0...
Patch 31219897 successfully applied.
Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2021-10-14_14-45-09PM_1.log

OPatch succeeded.



3)检查补丁情况

[oracle@1ge153 ~]$ opatch lspatches
31219897;OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)

[grid@1ge153 OPatch]$ opatch lspatches
31335188;TOMCAT RELEASE UPDATE 19.0.0.0.0 (31335188)
31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)
31304218;ACFS RELEASE UPDATE 19.8.0.0.0 (31304218)
31281355;Database Release Update : 19.8.0.0.200714 (31281355)

OPatch succeeded.


4)我的问题是版本怎么不一致呢





我来答
添加附件
收藏
分享
问题补充
7条回答
默认
最新
pgone

该怎么做

暂无图片 评论
暂无图片 有用 0
JiekeXu
暂无图片

建上库,跑完 SQL 脚本再看看

暂无图片 评论
暂无图片 有用 0
pgone
题主
2021-10-14
好的老师,我去试下
pgone
题主
2021-10-14
老师我建完库执行还是不行,你看我那个评论
pgone
题主
2021-10-14
老师:我这单实例+asm环境是不是不应该用这个命令opatchauto apply /oraru/31326369/31305339/ 0 0 0
展开全部评论(1条)
Uncopyrightable

oracle用户下是不是少执行一些东西呀,更新数据字典?

https://www.modb.pro/doc/46086

暂无图片 评论
暂无图片 有用 0
pgone

[oracle@1ge153 ~]$ datapatch -verbose
SQL Patching tool version 19.3.0.0.0 Production on Thu Oct 14 16:11:36 2021
Copyright (c) 2012, 2019, Oracle. All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_125481_2021_10_14_16_11_36/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done

Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
Interim patch 31219897 (OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)):
Binary registry: Installed
PDB CDB$ROOT: Applied successfully on 14-OCT-21 03.54.48.970439 PM
PDB PDB$SEED: Applied successfully on 14-OCT-21 04.06.53.206968 PM

Current state of release update SQL patches:
Binary registry:
19.3.0.0.0 Release_Update 190410122720: Installed
PDB CDB$ROOT:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 14-OCT-21 04.06.51.453700 PM
PDB PDB$SEED:
Applied 19.3.0.0.0 Release_Update 190410122720 with errors on 14-OCT-21 04.06.53.202173 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT
No interim patches need to be rolled back
No release update patches need to be installed
No interim patches need to be applied
For the following PDBs: PDB$SEED
No interim patches need to be rolled back
Patch 29517242 (Database Release Update : 19.3.0.0.190416 (29517242)):
Apply from 19.1.0.0.0 Feature Release to 19.3.0.0.0 Release_Update 190410122720
No interim patches need to be applied

Installing patches...
Patch installation complete. Total patches installed: 1

Validating logfiles...done
Patch 29517242 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29517242/22862832/29517242_apply_ORCL_PDBSEED_2021Oct14_16_12_03.log (no errors)
SQL Patching tool complete on Thu Oct 14 16:14:01 2021
[oracle@1ge153 ~]$ opatch lspatches
31219897;OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)

暂无图片 评论
暂无图片 有用 0
你好我是李白

这个是正常的,你可以去阅读RU的readme,里面会有表格列出补丁是否是包含db home 与 grid home类似如下:

Patch NumberDescriptionApplicable Homes
,在applicable homes下面会有Both DB Homes and Grid Home或者Only Grid Home等等,所以并不是你打补丁有问题,而是该OCW补丁是合集,所以会显示在db home中,反之亦然。

按照mos文档19c Database Installation includes DBRU and OCWRU (Doc ID 2578032.1),显示说:

From Oracle 19c onwards, Database Updates and OCW Updates comes packed along with and gets applied when installation is done. Every quarter new 19c software is uploaded to OTN to include the latest Updates.

但是好像12c中就已经是这样了,部分OCW patch会显示在在DB home的lspatches中,反之亦然。

暂无图片 评论
暂无图片 有用 0
pgone

我这单实例+asm环境是不是不应该用这个命令opatchauto apply /oraru/31326369/31305339/

暂无图片 评论
暂无图片 有用 0
你好我是李白

readme如果没有特别说明单机asm打补丁方法,那你这个方法就没问题。

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏