暂无图片
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
打赏 0
JiekeXu
暂无图片

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

暂无图片 评论
暂无图片 有用 0
打赏 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
打赏 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
打赏 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
打赏 0
pgone

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

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

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

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
相关推荐
什么原因导致CPU使用率偏高
回答 3
因为“usesinglelogwriter”和“useadaptivelogfilesync”引起的
oracle rac 19c 在winserver2016 打补丁了,prepatch卡住了执行不下去
回答 3
感谢你的建议,卡住时是因为两边补丁级别不一致
oracle 19c gc buffer busy release 问题
回答 4
Bug30381614RACDatabaseSessionsWaitingforaLongTimeon'gcbufferbusyrelease'(DocID30381614.8)
求助一下各位,想获取alert日志文件中这个2022-07-07T00:00:28.689537+08:00这个时间段以下所有的内容,怎么做
回答 3
这是我写的监控alert日志中每天日志内容中的ORA信息shell片段,供你参考:exportDATEDAYTODAYdatedtoday"%Y%m%d"exportDATEDATTOMORROWda
oracle rac 19c 存储划分空间疑问?
回答 6
已采纳
FRA闪回恢复区的意思,规划这个盘一般就是为了存放闪回日志,如果不开闪回那就不需要这个了。但是生产环境一般都要开启归档,归档日志一般也不会存放到DATA磁盘组,故需单独划一个盘ARCH或者FRA来存放
Oracle 19c 降低HWM
回答 3
已采纳
移动表收缩表 导入导出表 在线重定义表truncate降低HWM,就这么几个方法,提不了速了,附上一个同样的问题https://www.modb.pro/issue/6975
oracle SQL文本文件的最大大小是多少?(不是一条SQL的长度大小)
回答 2
最大取决于操作系统的支持的大小吧!为了查看和执行的便利性,还是不建议太大的
oracle中dg同步原理的细节咨询??
回答 1
dataguard分为三种保护模式,分别为:最大保护(MaximumProtection)、最大可用(MaximumAvailability)和最大性能(Maximumperformance)。这三种
树形 数据双向绑定
回答 1
你这是说页面如何显示的问题?貌似与数据库没有关系,这个在页面开发的时候判断好条件就行了。数据库不会去对你的页面进行操作的
oracle undo redo 生成问题
回答 3
产生undo肯定会产生redo,但是产生redo不一定产生undo,比如延迟块清除