探索Oracle之資料庫更新十
12c(12.1.0.2)CPU 19774304
一、 更新檔描述
參考metalink doc: (Doc ID 19774304.8)
Bug19774304 - 12.1.0.2 Bundle Patch 2 for Engineered Systems and DB In-Memory (Nov2014) (Doc ID 19774304.8)
二、 更新檔包含
19649591
DATABASE BUNDLE PATCH 12.1.0.2.2
(Oracle Database)
19392590
ACFS PATCH SET UPDATE 12.1.0.2.1
19392604
OCW PATCH SET UPDATE 12.1.0.2.1
三、 更新檔修複包含如下bug
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">14643995</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">ONLY 1 SQLPATCH INVOCATION AT A TIME</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">15996428</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">SESSIONS SID BLOCKING 0 SESSIONS</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">16010876</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">ORA-00600: [KFDPARALLELIO2] IN ASM WHEN I/O EMULATION</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">16286734</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">NLS:12.1_WIN64_130128:THERE ARE MANY QUESTION MASK IN GI INSTALLATION LOG</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">16293223</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">HEALTH FACTOR IMPROVEMENTS.</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">16359751</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">ORA-600[QCSGPVC:TBL2EVCOLNO:COLUMNS] DURING INSERT</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">17158137</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">RULES TESTS FAIL IN LOGICAL STANDBY WITH ORA-600 [17182]</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">17338864</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">LNX64-12.1-GH:PROVISION FROM GHS TO GHC FAILED WITH PRGO-1129</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">17940721</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">W2K8_12102:CVU PREREQ CHECK SHOULD FAIL WHEN ASM DISK IS OFFLINE IN REMOTE NODE</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">17972478</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&patchId=19774304&sourceId=19774304.8&_adf.ctrl-state=bcyolq2s6_49&_afrLoop=289973767932609">PACKAGE DBMS_COMPRESSION.GET_COMRESSION_TYPE SHOWS INCORRECT INFORMATION</a>
四、 該更新檔具體說明：
<a target="_blank" href="https://updates.oracle.com/Orion/Services/download?type=readme&aru=18125377#CIHCFEJE">https://updates.oracle.com/Orion/Services/download?type=readme&aru=18125377#CIHCFEJE</a>
五、 了解更新檔相關知識之後對漏洞進行修複
5.2 停止所有資料庫及監聽
5.3 上傳媒體，并解壓縮
5.4 檢視目前的OPatch 版本及CPU資訊
5.5 檢視更新前各元件的版本資訊
5.5 進入解壓後的CPU 19774304目錄
5.6 開始應用更新檔：
5.7 至此，CPU更新已經完成：
5.8 啟動資料庫檢查
![Java String.format方法的簡單使用[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)