瀟湘隱者

最近在給幾臺Windows平臺的Oracle 19c數據庫安裝Oracle 19.28補丁時遇到了一些小問題，簡單總結一下。

問題1：

D:\App\Oracle19c\product\19.3.0\db_1\OPatch\opatch apply
Oracle 臨時補丁程序安裝程序版本 12.2.0.1.47
版權所有 (c) 2025, Oracle Corporation。保留所有權利。


Oracle 主目錄       ：D:\App\Oracle19c\product\19.3.0\db_1
主產品清單：C:\Program Files\Oracle\Inventory
   來自           ：
OPatch 版本    ：12.2.0.1.47
OUI 版本       ：12.2.0.7.0
日志文件位置：D:\App\Oracle19c\product\19.3.0\db_1\cfgtoollogs\opatch\opatch2025-08-14_11-20-04上午_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:

Following active files/executables/libs are used by ORACLE_HOME :D:\App\Oracle19c\product\19.3.0\db_1
D:\App\Oracle19c\product\19.3.0\db_1\bin\oravssmsgus.dll
D:\App\Oracle19c\product\19.3.0\db_1\bin\ORAEVRUS19.dll



D:\App\Oracle19c\product\19.3.0\db_1\oui\lib\win64\vcruntime140.dll
UtilSession 失敗: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: D:\App\Oracle19c\product\19.3.0\db_1\cfgtoollogs\opatch\opatch2025-08-14_11-20-04上午_1.log

OPatch failed with error code = 73

出現這個問題,似乎有進程在使用這幾個文件.但是使用下面命令找不到相關進程

D:\soft\p37962957_190000_MSWIN-x86-64\37962957>tasklist /m oravssmsgus.dll
信息: 沒有運行的任務匹配指定標準。

D:\soft\p37962957_190000_MSWIN-x86-64\37962957>tasklist /m ORAEVRUS19.dll
信息: 沒有運行的任務匹配指定標準。

關于vcruntime140.dll，能找到相關進程，這個錯誤可以忽略(實際驗證結果)

D:\soft\p37962957_190000_MSWIN-x86-64\37962957>tasklist /m vcruntime140.dll

映像名稱                       PID 模塊
========================= ======== ============================================
OmniInet.exe                  1460 VCRUNTIME140.dll
NTRTScan.exe                  1716 VCRUNTIME140.dll
vmtoolsd.exe                  2136 VCRUNTIME140.dll
VGAuthService.exe             2144 VCRUNTIME140.dll
AisEsmUI.exe                  4652 VCRUNTIME140.dll

但是有些環境，只有上面兩個dll報錯，即使用微軟的工具Process Explorer也定位不到相關進程，同事最后想到一個妙招，將oravssmsgus.dll和ORAEVRUS19.dll重命名后,就能解決這個問題. 當然也不用擔心，安裝/應用新的補丁后，會在對應bin目錄生成新的dll文件。

問題2：

Adding patches to retry installation queue...done
Retry installation queue:
  For the following PDBs: ***UAT ***DEV
    No interim patches need to be rolled back
    Patch 37962957 (Windows Database Bundle Patch : 19.28.0.0.250715 (37962957)):
      Apply from 19.24.0.0.0 Release_Update 240705100120 to 19.28.0.0.0 Release_Update 250710053622
    The following interim patches will be applied:
      37847857 (OJVM RELEASE UPDATE: 19.28.0.0.250715 (37847857))

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

Validating logfiles...done
Patch 37962957 apply (pdb IYICTUAT): WITH ERRORS
  logfile: D:\App\Oracle19c\product\19.3.0\db_1\cfgtoollogs\sqlpatch\37962957\27562815/37962957_apply_IYICT_IYICTUAT_2025Aug14_15_08_58.log (errors)
  -> Error at line 138767: script ctx/admin/dr0stat.pkh
      - 0/0      PL/SQL: Compilation unit analysis terminated
  -> Error at line 138768: script ctx/admin/dr0stat.pkh
      - 381/48   PLS-00201: 必須聲明標識符 'SYS.HTTPURITYPE'
  -> Error at line 140778: script ctx/admin/dr0stat.plb
      - 0/0      PL/SQL: Compilation unit analysis terminated
  -> Error at line 140779: script ctx/admin/dr0stat.plb
      - 1/11     PLS-00201: 必須聲明標識符 'TEXTOPTSTATS'
  -> Error at line 140780: script ctx/admin/dr0stat.plb
      - 1/11     PLS-00304: 如果沒有說明, 則無法編譯 'TEXTOPTSTATS' 主體
Patch 37847857 apply (pdb IYICTUAT): WITH ERRORS (PREV PATCH)
  logfile: D:\App\Oracle19c\product\19.3.0\db_1\cfgtoollogs\sqlpatch\37847857\27716658/37847857_apply_IYICT_IYICTUAT_2025Aug14_15_08_19.log (no errors)
Patch 37962957 apply (pdb IYICTDEV): WITH ERRORS
  logfile: D:\App\Oracle19c\product\19.3.0\db_1\cfgtoollogs\sqlpatch\37962957\27562815/37962957_apply_IYICT_IYICTDEV_2025Aug14_15_08_57.log (errors)
  -> Error at line 138767: script ctx/admin/dr0stat.pkh
      - 0/0      PL/SQL: Compilation unit analysis terminated
  -> Error at line 138768: script ctx/admin/dr0stat.pkh
      - 381/48   PLS-00201: 必須聲明標識符 'SYS.HTTPURITYPE'
  -> Error at line 140778: script ctx/admin/dr0stat.plb
      - 0/0      PL/SQL: Compilation unit analysis terminated
  -> Error at line 140779: script ctx/admin/dr0stat.plb
      - 1/11     PLS-00201: 必須聲明標識符 'TEXTOPTSTATS'
  -> Error at line 140780: script ctx/admin/dr0stat.plb
      - 1/11     PLS-00304: 如果沒有說明, 則無法編譯 'TEXTOPTSTATS' 主體
Patch 37847857 apply (pdb IYICTDEV): WITH ERRORS (PREV PATCH)
  logfile: D:\App\Oracle19c\product\19.3.0\db_1\cfgtoollogs\sqlpatch\37847857\27716658/37847857_apply_IYICT_IYICTDEV_2025Aug14_15_08_18.log (no errors)

Please refer to MOS Note 1609718.1 and/or the invocation log

出現這個錯誤，是因為權限緣故，因為安全規范,將一些賬號權限給拿走了,授予下面權限即可(CDB與對應的PDB都必須授權，否則會報錯)。 如果是沒有對賬號權限限制的環境，應該不會遇到這個問題。

授權語句如下：

GRANT EXECUTE ON  HTTPURITYPE TO PUBLIC;

從之前的經驗來看，Windows平臺安裝補丁時，總會遇到各種各樣，奇奇怪怪的問題，而Linux平臺安裝Oracle補丁則較少遇到一些奇奇怪怪的問題。