打19.8补丁

展开补丁包

  inflating: 31281355/README.html    
  inflating: PatchSearch.xml         
[oracle@localhost ~]$ cd 31281355

/opatch lspatches   ./opatch lsinv   

Database opened.

查询当前状态

SQL> select patch_id,patch_type,action,status,source_version from dba_registry_sqlpatch;

  PATCH_ID PATCH_TYPE ACTION	      STATUS			SOURCE_VERSION
---------- ---------- --------------- ------------------------- ---------------
  29517242 RU	      APPLY	      SUCCESS			19.1.0.0.0

SQL> select owner, object_type, status, count(*) from dba_objects  where status='INVALID' group by owner, object_type, status order by owner, object_type;

no rows selected

[oracle@oln ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.21

OPatch succeeded.
[oracle@oln ~]$ $ORACLE_HOME/OPatch/opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)
OPatch succeeded.

检查

[oracle@oln 31281355]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /opt/oracle/product/19c/dbhome_1
Central Inventory : /opt/oracle/oraInventory
   from           : /opt/oracle/product/19c/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.21
OUI version       : 12.2.0.7.0
Log file location : /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2020-09-22_05-07-16AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

关闭数据库,然后打补丁。

[oracle@oln 31281355]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.


Oracle Home       : /opt/oracle/product/19c/dbhome_1
Central Inventory : /opt/oracle/oraInventory
   from           : /opt/oracle/product/19c/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.21
OUI version       : 12.2.0.7.0
Log file location : /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2020-09-22_05-10-19AM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.


Oracle Home       : /opt/oracle/product/19c/dbhome_1
Central Inventory : /opt/oracle/oraInventory
   from           : /opt/oracle/product/19c/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.21
OUI version       : 12.2.0.7.0
Log file location : /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2020-09-22_05-10-45AM_1.log

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

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 = '/opt/oracle/product/19c/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '31281355' to OH '/opt/oracle/product/19c/dbhome_1'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.xdk.parser.java.jaxb2, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.sqlj, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.rdbms.util, 19.0.0.0.0...

Patching component oracle.rdbms.rsf, 19.0.0.0.0...

Patching component oracle.assistants.acf, 19.0.0.0.0...

Patching component oracle.assistants.deconfig, 19.0.0.0.0...

Patching component oracle.assistants.server, 19.0.0.0.0...

Patching component oracle.buildtools.rsf, 19.0.0.0.0...

Patching component oracle.ctx, 19.0.0.0.0...

Patching component oracle.dbjava.ic, 19.0.0.0.0...

Patching component oracle.ldap.rsf, 19.0.0.0.0...

Patching component oracle.network.rsf, 19.0.0.0.0...

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

Patching component oracle.rdbms.deconfig, 19.0.0.0.0...

Patching component oracle.sdo, 19.0.0.0.0...

Patching component oracle.sdo.locator.jrf, 19.0.0.0.0...

Patching component oracle.sqlplus, 19.0.0.0.0...

Patching component oracle.xdk, 19.0.0.0.0...

Patching component oracle.rdbms.crs, 19.0.0.0.0...

Patching component oracle.install.deinstalltool, 19.0.0.0.0...

Patching component oracle.dbjava.ucp, 19.0.0.0.0...

Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...

Patching component oracle.rdbms.lbac, 19.0.0.0.0...

Patching component oracle.dbdev, 19.0.0.0.0...

Patching component oracle.marvel, 19.0.0.0.0...

Patching component oracle.network.listener, 19.0.0.0.0...

Patching component oracle.precomp.rsf, 19.0.0.0.0...

Patching component oracle.javavm.client, 19.0.0.0.0...

Patching component oracle.precomp.common.core, 19.0.0.0.0...

Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...

Patching component oracle.network.client, 19.0.0.0.0...

Patching component oracle.ctx.atg, 19.0.0.0.0...

Patching component oracle.ctx.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.drdaas, 19.0.0.0.0...

Patching component oracle.duma, 19.0.0.0.0...

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

Patching component oracle.odbc, 19.0.0.0.0...

Patching component oracle.rdbms.oci, 19.0.0.0.0...

Patching component oracle.rdbms.rman, 19.0.0.0.0...

Patching component oracle.rdbms.dv, 19.0.0.0.0...

Patching component oracle.bali.ice, 11.1.1.7.0...

Patching component oracle.ovm, 19.0.0.0.0...

Patching component oracle.dbjava.jdbc, 19.0.0.0.0...

Patching component oracle.oracore.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.scheduler, 19.0.0.0.0...

Patching component oracle.rdbms.install.common, 19.0.0.0.0...

Patching component oracle.ldap.owm, 19.0.0.0.0...

Patching component oracle.ldap.security.osdt, 19.0.0.0.0...

Patching component oracle.ons, 19.0.0.0.0...

Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...

Patching component oracle.sdo.locator, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...

Patching component oracle.xdk.rsf, 19.0.0.0.0...

Patching component oracle.sqlplus.ic, 19.0.0.0.0...

Patching component oracle.oraolap, 19.0.0.0.0...

Patching component oracle.xdk.parser.java, 19.0.0.0.0...

Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...

Patching component oracle.precomp.common, 19.0.0.0.0...

Patching component oracle.precomp.lang, 19.0.0.0.0...

Patching component oracle.jdk, 1.8.0.201.0...
Patch 31281355 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [31281355].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2020-09-22_05-10-45AM_1.log

OPatch succeeded.
[oracle@oln 31281355]$ 

启动数据库后检查没有发现刚才打的补丁!

[oracle@oln 31281355]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Sep 22 05:16:25 2020
Version 19.8.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.

staConnected to an idle instance.

SQL> rtup;
ORACLE instance started.

Total System Global Area 2415918568 bytes
Fixed Size		    9137640 bytes
Variable Size		  553648128 bytes
Database Buffers	 1845493760 bytes
Redo Buffers		    7639040 bytes
Database mounted.
Database opened.
SQL> select patch_id,patch_type,action,status,source_version from dba_registry_sqlpatch;

  PATCH_ID PATCH_TYPE ACTION	      STATUS			SOURCE_VERSION
---------- ---------- --------------- ------------------------- ---------------
  29517242 RU	      APPLY	      SUCCESS			19.1.0.0.0

SQL> select owner, object_type, status, count(*) from dba_objects  where status='INVALID' group by owner, object_type, status order by owner, object_type;

no rows selected

SQL> SQL> set linesize 200
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
BANNER_FULL
----------------------------------------------------------------------------------------------------------------------------------------------------------------
BANNER_LEGACY									     CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production			  0


SQL> 

执行datapatch

[oracle@oln 31281355]$ $ORACLE_HOME/OPatch/datapatch -verbose
SQL Patching tool version 19.8.0.0.0 Production on Tue Sep 22 05:43:08 2020
Copyright (c) 2012, 2020, Oracle.  All rights reserved.

Log file for this invocation: /opt/oracle/cfgtoollogs/sqlpatch/sqlpatch_1741_2020_09_22_05_43_08/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:
  No interim patches found

Current state of release update SQL patches:
  Binary registry:
    19.8.0.0.0 Release_Update 200703031501: Installed
  PDB CDB$ROOT:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 21-SEP-20 06.28.27.195519 AM
  PDB ORCLPDB1:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 21-SEP-20 06.35.48.668341 AM
  PDB PDB$SEED:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 21-SEP-20 06.35.48.668341 AM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED ORCLPDB1
    No interim patches need to be rolled back
    Patch 31281355 (Database Release Update : 19.8.0.0.200714 (31281355)):
      Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.8.0.0.0 Release_Update 200703031501
    No interim patches need to be applied

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

Validating logfiles...done
Patch 31281355 apply (pdb CDB$ROOT): SUCCESS
  logfile: /opt/oracle/cfgtoollogs/sqlpatch/31281355/23688465/31281355_apply_ORCLCDB_CDBROOT_2020Sep22_05_44_00.log (no errors)
Patch 31281355 apply (pdb PDB$SEED): SUCCESS
  logfile: /opt/oracle/cfgtoollogs/sqlpatch/31281355/23688465/31281355_apply_ORCLCDB_PDBSEED_2020Sep22_05_53_00.log (no errors)
Patch 31281355 apply (pdb ORCLPDB1): SUCCESS
  logfile: /opt/oracle/cfgtoollogs/sqlpatch/31281355/23688465/31281355_apply_ORCLCDB_ORCLPDB1_2020Sep22_05_53_02.log (no errors)
SQL Patching tool complete on Tue Sep 22 06:04:54 2020
[oracle@oln 31281355]$ 

再检查

[oracle@oln 31281355]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Sep 22 06:09:23 2020
Version 19.8.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0

SQL> select patch_id,patch_type,action,status,source_version from dba_registry_sqlpatch;

  PATCH_ID PATCH_TYPE ACTION	      STATUS			SOURCE_VERSION
---------- ---------- --------------- ------------------------- ---------------
  29517242 RU	      APPLY	      SUCCESS			19.1.0.0.0
  31281355 RU	      APPLY	      SUCCESS			19.3.0.0.0

SQL> set linesize 200
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
BANNER_FULL
----------------------------------------------------------------------------------------------------------------------------------------------------------------
BANNER_LEGACY									     CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production			  0


SQL>  select patch_id,patch_type,action,status,source_version,TARGET_VERSION from dba_registry_sqlpatch;

  PATCH_ID PATCH_TYPE ACTION	      STATUS			SOURCE_VERSION	TARGET_VERSION
---------- ---------- --------------- ------------------------- --------------- ---------------
  29517242 RU	      APPLY	      SUCCESS			19.1.0.0.0	19.3.0.0.0
  31281355 RU	      APPLY	      SUCCESS			19.3.0.0.0	19.8.0.0.0


SQL> 
姚远ACE CSDN认证博客专家 ACE 华为云 MVP
Oracle ACE,华为云 MVP,Oracle10g,12c OCM; MySQL 5.6,5.7,8.0 OCP;CCNA; EMC Certified; IBM P Certified; RHCE; SQLServer 764; DB2 Certified; TOEIC 890;获得过两次国家部级科技进步奖;发明过两项计算机专利。微信:yaoyuanace 邮箱:yaoyuanace(at)qq.com
已标记关键词 清除标记
相关推荐
<p style="font-size:16px;"> 在本地自己的操作系统上,完全模拟生产环境,让学员跟着视频一步一步搭建一套在RHEL7操作系统上面的oracle19c的rac环境。同时学员还会学会DNS服务器,DNS客户端,NTP服务器,NTP客户端等操作系统知识。让学员在短时间内,oracle和操作系统知识,有一定的提升。让学员可以独自轻松安装一套oracle rac环境。 </p> <p style="font-size:16px;"> <span style="color:#FF0000;">一课程主题</span> </p> <p style="font-size:16px;"> 模拟生产环境,用多路径共享存储,用虚拟软件安装一套RHEL7.5+oracle19c+rac+打补丁 </p> <p style="font-size:16px;"> <br /> </p> <p style="font-size:16px;"> <span style="color:#FF0000;">二课程特色</span> </p> <ol style="font-size:16px;"> <li> <p> 完成模拟生产环境,用openfiler软件模拟生产惠普的3par存储,用2个虚拟网卡模拟数据库服务器的2个HBA卡。 </p> </li> <li> <p> 课程以实践为主,从头到尾一步一步教学员怎样操作,实践性强 </p> </li> <li> <p> 模拟生产需求,完全可以把这套环境拿到生产环境安装 </p> <p> <br /> </p> </li> </ol> <p style="font-size:16px;"> <span style="color:#FF0000;">三课程内容</span> </p> <p style="font-size:16px;"> <span style="color:#FF0000;"></span> </p> <p style="font-size:16px;"> <span style="color:#FF0000;"></span> </p> <p style="font-size:16px;"> <span style="color:#FF0000;">1.课程结束成果演示</span> </p> <p style="font-size:16px;"> <span style="color:#FF0000;">  <span style="color:#000000;"> 1.1 用workstation,安装一套rhel7+oracle19c+rac+multipath+共享存储+DNS服务器+DNS客户端+NTP服务器+NTP客户端的生产环境</span></span> </p> <p style="font-size:16px;">    1.2 怎样打oracle19c的rac补丁(包括GI补丁,oracle补丁,数据库补丁,OJVM补丁,bug补丁) </p> <p style="font-size:16px;"> <br /> </p> <p style="font-size:16px;"> <span style="color:#FF0000;">2.安装openfiler软件,模拟共享存储+配置多路径访问</span> </p> <p style="font-size:16px;"> <span style="color:#FF0000;">   </span>2.1安装openfiler软件 </p> <p style="font-size:16px;">    2.2配置openfiler软件(配置2个虚拟网卡,模拟服务器的2个HBA卡) </p> <p style="font-size:16px;">    2.3创建ocr磁盘 </p> <p style="font-size:16px;">    2.4创建mgmt磁盘 </p> <p style="font-size:16px;">    2.5创建数据文件磁盘 </p> <p style="font-size:16px;">    2.6创建归档日志磁盘 </p> <p style="font-size:16px;"> <br /> </p> <p style="font-size:16px;"> <span style="color:#FF0000;">3.安装2台数据库服务器</span> </p> <p style="font-size:16px;">    3.1安装2台数据库服务器RHEL7.5 </p> <p style="font-size:16px;">    3.2配置服务器双网卡绑定+配置服务器心跳线 </p> <p style="font-size:16px;"> <br /> </p> <p style="font-size:16px;"> <span style="color:#FF0000;">4.安装多路径软件识别共享存储中的磁盘</span> </p> <p style="font-size:16px;">     4.1安装服务器本地yum源 </p> <p style="font-size:16px;">     4.2安装iscsi软件,配置多路径配置文件,识别共享存储中的磁盘 </p> <p style="font-size:16px;">     4.3识别ocr磁盘 </p> <p style="font-size:16px;">     4.4识别mgmt磁盘 </p> <p style="font-size:16px;">     4.5识别数据文件磁盘 </p> <p style="font-size:16px;">     4.6识别归档日志磁盘 </p> <p style="font-size:16px;"> <br /> </p> <p style="font-size:16px;"> <span style="color:#FF0000;">5.oracle19c的rac环境系统参数官方说明</span> </p> <p style="font-size:16px;">     5.1如何配置oracle19c的rac的系统参数(我们参考官方说明) </p> <p style="font-size:16px;">     5.2oracle19c+rac环境Best Practices 官方说明文档 </p> <p style="font-size:16px;"> <br /> </p> <p style="font-size:16px;"> <span style="color:#FF0000;">6.安装oracle19c+rac之前的准备工作</span> </p> <p style="font-size:16px;">     6.1修改/etc/hosts文件 </p> <p style="font-size:16px;">     6.2配置DNS服务器+DNS客户端+NTP服务器+NTP客户端 </p> <p style="font-size:16px;">     6.3创建用户和组 </p> <p style="font-size:16px;">     6.4创建目录 </p> <p style="font-size:16px;">     6.5修改用户环境变量 </p> <p style="font-size:16px;">     6.6安装相关软件包 </p> <p style="font-size:16px;">     6.7配置ssh互信 </p> <p style="font-size:16px;">     6.9禁用服务器透明大页 </p> <p style="font-size:16px;"> <br /> </p> <p style="font-size:16px;"> <span style="color:#FF0000;">7.安装oracle+19c+rac软件</span> </p> <p style="font-size:16px;">    7.1安装GI软件 </p> <p style="font-size:16px;">    7.2创建ASM磁盘,主要是数据文件磁盘和归档日志磁盘 </p> <p style="font-size:16px;">    7.3安装数据库软件 </p> <p style="font-size:16px;">    7.4创建数据库实例 </p> <p style="font-size:16px;">    7.5日常常用维护集群命令(启停数据库,启停集群,查看监听,教同学们怎样不死记命令,而且命令还正确) </p> <p style="font-size:16px;"> <br /> </p> <p style="font-size:16px;"> <span style="color:#FF0000;">8.打补丁</span> </p> <p style="font-size:16px;">   8.1打GI和ORACLE的操作系统补丁 </p> <p style="font-size:16px;">   8.2打OJVM补丁 </p> <p style="font-size:16px;">   8.3打ORA600的bug补丁 </p> <p style="font-size:16px;"> <br /> </p> <p style="font-size:16px;"> <span style="color:#FF0000;">9.课程总结和成果演示</span> </p> <p style="font-size:16px;"> <span style="color:#FF0000;"> <span style="color:#000000;">9.1课程总结和成果演示</span></span> </p> <p style="font-size:16px;"> <span style="color:#FF0000;"><br /> </span> </p> <p style="font-size:16px;"> <span style="color:#FF0000;">四学习必要工具</span> </p> <ol style="font-size:16px;"> <li> <p> 安装workstation软件   </p> </li> <li> <p> 官网下载openfiler,rhel7.5软件 </p> </li> <li> <p> 下载oracle软件(包括19.3的rac安装包,19.4的补丁) </p> <p> 以上软件我都已经在视频里面做了下载地址说明 </p> </li> <li> <div> <br /> </div> </li> </ol>
©️2020 CSDN 皮肤主题: Age of Ai 设计师:meimeiellie 返回首页