windows打19C RU补丁

在windows server 2016 +oracle 19c单机上安装最新补丁

打本季度最新的RU类型的Bundle Patch 33829175

下载补丁并校验
下载地址：
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=271623540251792&id=2118136.2&_adf.ctrl-state=12evktajhd_87

阅读readme
检查当前环境
1、This is a client only bundle patch. It is cumulative. That is, the content of all previous bundles is included in the latest bundle patch.
这个是累计补丁

2、 the Oracle home must have the 19.3 Client installed.
要求数据库home必须是19.3

select banner_full from v$version;
select version,version_full from v$instance;
select * from product_component_version;

3、操作系统环境要求，64位的windows server 2016
Operating system requirement:
Windows Server 2016 x64 - Standard, Datacenter, and Essentials editions

4、opatch工具的版本要求
You must use the OPatch utility version 12.2.0.1.29 or later to apply this patch

4.1下载opatch 工具的地址：
https://updates.oracle.com/ARULink/PatchDetails/process_form?patch_num=6880880

4.2备份ORACLE_HOME/OPatch解压新的OPatch
4.3测试新的opatch工具的版本号
opatch version

5、补丁冲突检查
opatch lspatches

cd 33829175
opatch prereq CheckConflictAgainstOHWithDetail -ph ./

如果有冲突一般回退

安装补丁
1、设置环境变量
echo %ORACLE_HOME%
echo %PATH%

set ORACLE_HOME=D:\oracle19c
set PATH=%ORACLE_HOME%\perl\bin;%ORACLE_HOME%\OPatch;%PATH%

确保该变量 PERL5LIB为空
set PERL5LIB=
2、关闭与oracle home相关联的服务
关闭实例:shutdown immediate
关闭监听:lsnrctl stop
关闭与oracle有关的服务:services.msc 中与o有关的服务
关闭分布式事物协调服务:net stop msdtc

3、备份oracle home，在命令行用新版本的opatch工具实施
备份%ORACLE_HOME%

cd 33829175
opatch apply

4、执行修改后的sql文件，否则在dba_registry_sqlpatch中无法查看
4.1在services.msc中启动oracle server服务 oracleserviceSID 而不是sqlplus中启动
4.2 cd %oracle_home%/opatch
opatch -verbose
4.3检查补丁安装情况
select patch_id,patch_type,action,status,source_version,target_version from dba_registry_sqlpatch;
4.4 编译无效对象
select count(*) from dba_objects where status=‘INVALID’;

cd %ORACLE_HOME%/rdbms/admin
SQL> @utlrp.sql

5、卸载补丁
opatch rollback -id 33829175
装载修改sql
database -verbose
编译无效对象
@utlrp.sql