Oracle 補丁下載，更新相關的文章已經介紹過多篇了，從 11g 單機，RAC 到 19c 均有涉及，今天應該是這個系列的最后一篇文章介紹了，也來說說 Linux7 下的 Oracle 19c RAC RU15 補丁更新詳細步驟，其他 RU 更新步驟均一樣，都可以從 19.3 更新到最新的 RU，也可以在 RU15 的基礎上更新最新的 RU17。值得一說的是最新的 RU 已經到 19.17 了，前面一篇文章介紹了今年第四季度各個版本數據庫的補丁更新情況。

注意：本文已經生成 PDF 文檔了，有需要的可使用此鏈接下載 http://www.sunline.cc/doc/79585

這里要注意 RU(Release Update)和 RUR (Release Update Revisions) 的區別：
1.RU 是主動，高度測試，捆綁了許多重要修復，能夠使客戶避免許多已知問題。
2.RUR 包含對 RU 的安全性和回退修復，將 RU 的生命周期延長兩個季度。每個 RUR 只針對特定的 RU。

Release Update Introduction and FAQ (文檔 ID 2285040.1)
Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (文檔 ID 2118136.2)

但是值得注意的是：從 2022 年 10 月開始，19.17.0 及以上版本將不再提供 19c RUR。在 2023 年 1 月 Oracle Database 19c RUR 19.16.2 發布后，任何平臺上都不會發布額外的RUR。詳情請參閱 19c RURs 的終止及常見問題解答(注2898381.1)。

下面來一起看看 RAC 下 RU 補丁更新的兩種方法，節點 1 和 節點 2 是兩種不同的方法。

下載補丁和 OPatch

RU15 下載(包括 GI 和 DB 以及 OJVM 補丁包)：

--19c Patch 33803476 - GI Release Update 19.15.0.0.220419

p33859214_190000_Linux-x86-64.zip
OPatch 12.2.0.1.30 for DB 12.2.0.1.0 (Apr 2022) 
p6880880_122010_Linux-x86-64.zip

上傳到 /u01/backup 然后使用 grid 用戶解壓。

chmod 777 p33859214_190000_Linux-x86-64.zip
(+ASM1)$ unzip p33859214_190000_Linux-x86-64.zip
(+ASM1)$ scp -r 33859214  rac19c-r2:/u01/backup
(+ASM1)$ scp -r OPatch rac19c-r2:/u01/backup

可參考文檔：
http://www.sunline.cc/doc/46149
https://mp.weixin.qq.com/s/VGyb-UjbI1IFo1llEfVduQ

停止集群件備份家目錄

----兩節點分別操作
/u01/app/19.0.0/grid/bin/crsctl stop crs
tar -zcvf /u01/app.tar.gz /u01/app
/u01/app/19.0.0/grid/bin/crsctl start crs

兩節點 GI、DB OPatch 替換

----# 表示 root 用戶，$ 表示 Oracle 用戶提示符，(ASM1)$ 表示 grid 用戶
# cd /u01/app/19.0.0/grid/
# mv OPatch OPatch.bak19
(ASM1)$ unzip p6880880_122010_Linux-x86-64.zip
# cp -r OPatch /u01/app/19.0.0/grid/
# chown grid:oinstall -R /u01/app/19.0.0/grid/OPatch

$ opatch version 
OPatch Version: 12.2.0.1.30

OPatch succeeded.

DB：
$ cd $ORACLE_HOME
$ mv OPatch/ OPatch_bak19
cp -r /u01/backup/OPatch ./

復制 oui-patch.xml 到遠程節點 2 注意權限

(+ASM2)$ cd /u01/app/oraInventory/ContentsXML/
(+ASM2)$ scp -p rac19c-r1:/u01/app/oraInventory/ContentsXML/oui-patch.xml ./

oracle inventory 驗證
$ <ORACLE_HOME>/OPatch/opatch lsinventory -detail -oh <ORACLE_HOME>

如果是 RAC 環境分別指定 $GI_HOME 和 $ORACLE_HOME

(+ASM1)$ opatch lsinventory -detail -oh $ORACLE_HOME
(DB1)$ opatch lsinventory -detail -oh $ORACLE_HOME

(+ASM2)$ opatch lsinventory -detail -oh $ORACLE_HOME
(DB2)$ opatch lsinventory -detail -oh $ORACLE_HOME

空間檢查和補丁沖突檢查這里就不做了，因為是新環境，這些都沒有問題。 如果有需要可參考我以前的文章或者補丁 README.html 。

補丁分析

這里一定要看補丁 README.html 的各個補丁介紹，有的只涉及到 DB，有的只涉及到 GI，有的只是 OJVM，例如 33806152 這個補丁則 GI 和 DB 都涉及，也是主要補丁；33815596 這個則是 OCW 這個補丁則 GI 和 DB 都可以使用；33815607 ACFS 補丁，33911149 Tomcat 補丁，33575402 補丁，這三個補丁僅在 GI 上適用，且不支持 HP-UX Itanium 和 Linux on IBM System z 系統，我這里是 RHEL7 沒有問題。

使用 root 用戶分析補丁 33806152

提前分析補丁，可以避免一些錯誤，如下檢測出來 GI 和 DB 的 OPatch 版本不一樣；注意這里的路徑深入到 33803476 即可，不必更深一層，不然就需要如下辦法一個個子補丁去分析和單獨應用，節點 2 則正常到 33803476 層。

# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/backup/33859214/33803476/33806152 -analyze

打補丁分析補丁時，個人建議將連接到操作系統 Oracle 或者 grid 用戶的會話都退出到 root 或者直接斷開，以前遇到過由于有連接導致打補丁失敗。下面是一個完整的日志輸出，其他補丁日志輸出則省略。

# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/backup/33859214/33803476/33806152 -analyze

OPatchauto session is initiated at Wed May 11 10:57:46 2022

System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2022-05-11_10-57-48AM.log.

Following home(s) will not be included as part of current opatchauto session as it's software only RAC home:
Home path:/u01/app/oracle/product/19.0.0/dbhome_1, Host:rac19c-r2

Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2022-05-11_10-58-35AM.log
The id for this session is HD5U

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0/dbhome_1

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

Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/dbhome_1

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

Executing patch validation checks on home /u01/app/oracle/product/19.0.0/dbhome_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19.0.0/dbhome_1

Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0/dbhome_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/dbhome_1

OPatchAuto successful.

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

Analysis for applying patches has completed successfully:

Host:rac19c-r1
CRS Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0

==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /u01/backup/33859214/33803476/33806152
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-11_10-58-54AM_1.log

Host:rac19c-r1
RAC Home:/u01/app/oracle/product/19.0.0/dbhome_1
Version:19.0.0.0.0

==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /u01/backup/33859214/33803476/33806152
Log: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-11_10-58-55AM_1.log


OPatchauto session completed at Wed May 11 10:59:38 2022
Time taken to complete the session 1 minute, 53 seconds

OCW 分析

# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/backup/33859214/33803476/33815596 -analyze
--省略日志輸出

ACFS 補丁分析

[root@rac19c-r1 33803476]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/backup/33859214/33803476/33815607 -analyze

--省略日志輸出
Reason: /u01/backup/33859214/33803476/33815607 is not required to be applied to oracle home /u01/app/oracle/product/19.0.0/dbhome_1

Tomcat 補丁分析

# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/backup/33859214/33803476/33911149 -analyze

--省略日志輸出
Reason: /u01/backup/33859214/33803476/33911149 is not required to be applied to oracle home /u01/app/oracle/product/19.0.0/dbhome_1

DBWLM 補丁分析

# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/backup/33859214/33803476/33575402 -analyze

--省略日志輸出
Reason: /u01/backup/33859214/33803476/33575402 is not required to be applied to oracle home /u01/app/oracle/product/19.0.0/dbhome_1

節點一分開打各個補丁

root 自動打補丁 33806152

# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/backup/33859214/33803476/33806152

OPatchAuto successful.

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

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

Host:rac19c-r1
RAC Home:/u01/app/oracle/product/19.0.0/dbhome_1
Version:19.0.0.0.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /u01/backup/33859214/33803476/33806152
Log: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-11_11-36-47AM_1.log

Host:rac19c-r1
CRS Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /u01/backup/33859214/33803476/33806152
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-11_11-41-34AM_1.log

OPatchauto session completed at Wed May 11 12:04:15 2022
Time taken to complete the session 32 minutes, 25 seconds

OCW 補丁

# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/backup/33859214/33803476/33815596    

ACFS 補丁

[root@rac19c-r1 33803476]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/backup/33859214/33803476/33815607 -oh /u01/app/19.0.0/grid

Tomcat 補丁

# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/backup/33859214/33803476/33911149 -oh /u01/app/19.0.0/grid

DBWLM 補丁

# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/backup/33859214/33803476/33575402 -oh /u01/app/19.0.0/grid

OPatchauto session is initiated at Wed May 11 15:03:56 2022

System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2022-05-11_03-04-00PM.log.

Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2022-05-11_03-04-45PM.log
The id for this session is 1GY2

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/rac19c-r1/crsconfig/crs_prepatch_apply_inplace_rac19c-r1_2022-05-11_03-05-08PM.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/rac19c-r1/crsconfig/crs_postpatch_apply_inplace_rac19c-r1_2022-05-11_03-07-52PM.log
CRS service started successfully on home /u01/app/19.0.0/grid

OPatchAuto successful.

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

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

Host:rac19c-r1
CRS Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /u01/backup/33859214/33803476/33575402
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-11_15-07-26PM_1.log

OPatchauto session completed at Wed May 11 15:10:32 2022
Time taken to complete the session 6 minutes, 36 seconds

節點二應用補丁

直接分析 33803476 整個補丁集

# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/backup/33859214/33803476 -analyze

OPatchAuto successful.

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

Analysis for applying patches has completed successfully:

Host:rac19c-r2
CRS Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /u01/backup/33859214/33803476/33815596
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-11_17-47-44PM_1.log

Patch: /u01/backup/33859214/33803476/33815607
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-11_17-47-44PM_1.log

Patch: /u01/backup/33859214/33803476/33575402
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-11_17-47-44PM_1.log

Patch: /u01/backup/33859214/33803476/33911149
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-11_17-47-44PM_1.log

Patch: /u01/backup/33859214/33803476/33806152
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-11_17-47-44PM_1.log

OPatchauto session completed at Wed May 11 17:48:08 2022
Time taken to complete the session 2 minutes, 20 seconds

Root 打補丁 33803476

# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/backup/33859214/33803476

注意看這里提示自動打失敗了，但是根絕這個錯誤看不出問題，那么就需要看上圖中標黃的日志了。

more /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-11_17-55-12PM_1.log

檢查日志發現節點 2 補丁 33815596 缺少文件 ocrcheck.bin 

# ll /u01/backup/33859214/33803476/33815596/files/bin/ocrcheck.bin
ls: cannot access /u01/backup/33859214/33803476/33815596/files/bin/ocrcheck.bin: No such file or directory

很是奇怪，補丁包是從節點1 解壓后 scp 過來的，怎么會出現缺少文件的問題呢？那就直接 scp zip 包然后在節點 2 解壓吧。

RAC1$ scp p33859214_190000_Linux-x86-64.zip rac19c-r2:/u01/backup

RAC2# chown grid:oinstall p33859214_190000_Linux-x86-64.zip
su - grid
(+ASM2)$ unzip p33859214_190000_Linux-x86-64.zip
(+ASM2)$ chmod 777 -R 33859214

然后使用 root 繼續打補丁吧。
# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/backup/33859214/33803476

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

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

Host:rac19c-r2
CRS Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /u01/backup/33859214/33803476/33575402
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-11_18-37-20PM_1.log

Patch: /u01/backup/33859214/33803476/33806152
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-11_18-37-20PM_1.log

Patch: /u01/backup/33859214/33803476/33815596
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-11_18-37-20PM_1.log

Patch: /u01/backup/33859214/33803476/33815607
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-11_18-37-20PM_1.log

Patch: /u01/backup/33859214/33803476/33911149
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-11_18-37-20PM_1.log


OPatchauto session completed at Wed May 11 18:46:27 2022
Time taken to complete the session 11 minutes, 49 seconds

注意：如果有其他問題，補丁已經開始進行了，中途出現問題報錯，需檢查日志修復問題后使用 resume 執行補丁。

# /u01/app/19.0.0/grid/OPatch/opatchauto resume 

檢查補丁信息

(+ASM1)$ opatch lspatches
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
33911149;TOMCAT RELEASE UPDATE 19.0.0.0.0 (33911149)
33815607;ACFS RELEASE UPDATE 19.15.0.0.0 (33815607)
33815596;OCW RELEASE UPDATE 19.15.0.0.0 (33815596)
33806152;Database Release Update : 19.15.0.0.220419 (33806152)

(+ASM2)$ opatch lspatches
33911149;TOMCAT RELEASE UPDATE 19.0.0.0.0 (33911149)
33815607;ACFS RELEASE UPDATE 19.15.0.0.0 (33815607)
33815596;OCW RELEASE UPDATE 19.15.0.0.0 (33815596)
33806152;Database Release Update : 19.15.0.0.220419 (33806152)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)

檢查發現 RAC2 ACFS 和 DBWLM 沒有變過來而已，不過已經打上補丁了。

RAC1$ opatch lspatches
33815596;OCW RELEASE UPDATE 19.15.0.0.0 (33815596)
33806152;Database Release Update : 19.15.0.0.220419 (33806152)

RAC2$ opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)

手動打補丁

檢查發現 RAC2 DB 沒有打上補丁，那么手動來打吧。

# chown -R oracle:oinstall 33859214 

su - oracle

RAC2$ /u01/backup/33859214/33803476/33815596/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/19.0.0/dbhome_1

RAC2$ opatch apply -oh /u01/app/oracle/product/19.0.0/dbhome_1 /u01/backup/33859214/33803476/33806152


RAC2$ opatch apply -oh /u01/app/oracle/product/19.0.0/dbhome_1 /u01/backup/33859214/33803476/33815596

RAC2$ /u01/backup/33859214/33803476/33815596/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/product/19.0.0.0/dbhome_1

Oracle 用戶再次檢查 19.15 已沒有問題了。

$ opatch lspatches
33815596;OCW RELEASE UPDATE 19.15.0.0.0 (33815596)
33806152;Database Release Update : 19.15.0.0.220419 (33806152)

OPatch succeeded.

OJVM 補丁

檢查 OJVM 是否安裝，是否使用？ 這個很早之前也說過了。

SQL> SELECT version, status FROM dba_registry WHERE comp_id='JAVAVM';
16:55:52 SQL> 
VERSION                        STATUS
------------------------------ --------------------------------------------
19.0.0.0.0                     VALID

SQL> select count(*) from x$kglob where KGLOBTYP = 29 OR KGLOBTYP = 56;

  COUNT(*)
----------
         0

為了確定 OJVM 的用戶，我們可以通過下面的 SQL 檢查 V$SESSION 來顯示數據庫中調用 Java 的 SERVICE, PROGRAM 或 user。 此 SQL 將只顯示活動用戶(因此可能必須定期運行以充分收集數據)。

col service_name format a20
col username format a20
col program format a20
set num 8
select sess.service_name, sess.username,sess.program, count(*)
from
v$session sess,
dba_users usr,
x$kgllk lk,
x$kglob
where kgllkuse=saddr
and kgllkhdl=kglhdadr
and kglobtyp in (29,56)
and sess.user# = usr.user_id
and usr.oracle_maintained = 'N'      -- omit this line on 11.2.0.4
group by sess.service_name, sess.username, sess.program
order by sess.service_name, sess.username, sess.program;

--如果您希望報告除您自己的應用程序之外正在使用的 Oracle 實用程序(以便Oracle 實用程序也可以暫停)，請使用以下 SQL SELECT 語句。 即時編譯器(JIT)在滾動過程中停止。

col service_name format a20
col username format a20
col program format a20
set num 8
select sess.service_name, sess.username,sess.program, count(*)
from
v$session sess,
x$kgllk lk,
x$kglob
where kgllkuse=saddr
and kgllkhdl=kglhdadr
and kglobtyp in (29,56)
group by sess.service_name, sess.username, sess.program
order by sess.service_name, sess.username, sess.program;

OJVM PSU 補丁將補丁文件放到 ORACLE_HOME 中，重新鏈接 ORACLE_HOME，然后修改 Oracle 可執行文件。 然后，Oracle 數據庫編排 Java 系統類的更新。

使用 RAC 滾動步驟在主數據庫中停止、清空和禁用所有使用 OJVM 的服務。 應用OJVM Patch 和所有 Post SQL (Data Patch)步驟。 重啟數據庫，啟用并重啟使用OJVM 的服務。通俗易懂的意思就是停止數據庫實例應用 OJVM 補丁。

--關閉實例 1 
$ srvctl stop instance -d jiekedb -instance jiekedb1

--應用 OJVM 補丁
cd /u01/backup/33859214/33808367
opatch apply -local     
opatch lsinventory 

--啟動實例執行 datapatch 腳本
$ srvctl start instance -d jiekedb -instance jiekedb1
cd $ORACLE_HOME/OPatch

./datapatch -verbose 

檢查數據庫補丁信息

set line 456 
col ACTION_TIME for a30
col STATUS for a10
col DESCRIPTION for a55
select PATCH_ID, PATCH_UID, TARGET_VERSION, ACTION, ACTION_TIME, STATUS, DESCRIPTION from dba_registry_sqlpatch order by action_time;

  PATCH_ID  PATCH_UID TARGET_VERSION  ACTION          ACTION_TIME                    STATUS     DESCRIPTION
---------- ---------- --------------- --------------- ------------------------------ ---------- -------------------------------------------------------
  29517242   22862832 19.3.0.0.0      APPLY           09-MAY-22 05.18.12.723309 PM   SUCCESS    Database Release Update : 19.3.0.0.190416 (29517242)
  33806152   24713297 19.15.0.0.0     APPLY           11-MAY-22 12.04.14.679266 PM   SUCCESS    Database Release Update : 19.15.0.0.220419 (33806152)
  33808367   24680225 19.15.0.0.0     APPLY           11-MAY-22 05.36.54.859534 PM   SUCCESS    OJVM RELEASE UPDATE: 19.15.0.0.220419 (33808367)

補丁回退

回退補丁也比較簡單，具體請查看 README.html 。新安裝的數據庫一般情況下是不需要回退的，這里以備不時之需，請使用 root 用戶執行：

# <GI_HOME>/OPatch/opatchauto rollback <UNZIPPED_PATCH_LOCATION>/33803476

然后啟動數據庫，使用 Oracle 用戶僅在其中一個節點執行下面腳本。

cd $ORACLE_HOME/OPatch
./datapatch -verbose

然后檢查日志：

33806152_rollback_<database SID>_<CDB name>_<timestamp>.log

然后編譯無效對象：

cd $ORACLE_HOME/rdbms/admin
sqlplus / AS SYSDBA
SQL> @utlrp.sql

如果是單機環境，關閉數據庫實例和監聽，直接：

opatch rollback -id 33806152

其他補丁相關的資料

https://mp.weixin.qq.com/s/_Z8boXE3ZTxq37rSAyZGeA
https://mp.weixin.qq.com/s/VGyb-UjbI1IFo1llEfVduQ
https://mp.weixin.qq.com/s/2DoBV-8PsoYENgwM3BAIaQ
https://mp.weixin.qq.com/s/zS4aE3TfhbMwDk37nIEGfg
https://mp.weixin.qq.com/s/C0YbdGs2SVxqDuTm1g83fw
https://mp.weixin.qq.com/s/0jPYvtfFezGLhq-S-9RqGQ
https://mp.weixin.qq.com/s/Q45cfsRz1Oa4dSzi8_2Ktg
http://www.sunline.cc/download/1033988
http://www.sunline.cc/download/541101
http://www.sunline.cc/download/39727
http://www.sunline.cc/doc/46149
http://www.sunline.cc/db/27255
http://www.sunline.cc/doc/1602
http://www.sunline.cc/doc/4638

全文完，希望可以幫到正在閱讀的你，如果覺得此文對你有幫助，可以分享給你身邊的朋友，同事，你關心誰就分享給誰，一起學習共同進步~~~

注意：本文已經生成 PDF 文檔了，有需要的可使用此鏈接下載 http://www.sunline.cc/doc/79585

?? 歡迎關注我的公眾號【JiekeXu DBA之路】，一起學習新知識！
————————————————————————————
公眾號：JiekeXu DBA之路
CSDN ：https://blog.csdn.net/JiekeXu
墨天輪：http://www.sunline.cc/u/4347
騰訊云：https://cloud.tencent.com/developer/user/5645107
————————————————————————————