文檔 /
Oracle 19c RAC_RU19.10 打補丁及錯誤處理簡單步驟.txt
Oracle 19c RAC_RU19.10 打補丁及錯誤處理簡單步驟.txt
5墨值下載
1、 grid 和 oracle 用戶替換 Opatch
cd /app/soft
unzip p6880880_122010_Linux-zSer_12.2.0.1.23.zip –d $ORACLE_HOME
2、驗證 opatch 版本
opatch version
OPatch Version: 12.2.0.1.23
3、 grid 用戶解壓 19.10 RU 補丁（這里必須要用 grid 用戶解壓）
cd /app/soft
unzip p32226239_190000_Linux-zSer-1910.zip
4、 檢測是否有補丁沖突
grid、oracle 用戶均需要執行
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir
/app/soft/32226239/32218454
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir
/app/soft/32226239/32222571
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir
/backup/soft/32126842/32226239/32218454
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir
/backup/soft/32126842/32226239/32222571
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir
/backup/soft/32126842/32226239/
5、復制 oui-patch.xml 到遠程節點注意權限
scp -p jieker1:/u01/app/oraInventory/ContentsXML/oui-patch.xml ./
6、root 用戶分析補丁
/app/app/19.0.0.0/grid/OPatch/opatchauto apply /app/soft/32226239 -analyze
/backup/app/19.0.0.0/grid/OPatch/opatchauto apply
/backup/soft/32126842/32226239/ -analyze
/u01/app/19.0.0.0/grid/OPatch/opatchauto apply /backup/soft/32126842/32226239/
-analyze
root 自動打補丁
/u01/app/19.0.0.0/grid/OPatch/opatchauto apply /backup/soft/32126842/32226239/
查看 lib 包是否有進程占用
fuser /app/app/oracle/product/19.0.0.0/dbhome_1/lib/libsqlplus.so
fuser /app/app/oracle/product/19.0.0.0/dbhome_1/lib/libclntsh.so.19.1
如果存在進程占用，將會產生如下報錯
/app/app/oracle/product/19.0.0.0/dbhome_1/bin/expdp at Thu Mar 04 15:31:14 CST
2021
[Mar 4, 2021 3:31:14 PM] [INFO] Following active executables are not used by
opatch process : /app/app/oracle/product/19.0.0.0/dbhome_1/lib/libclntsh.so.19.1
/app/app/oracle/product/19.0.0.0/dbhome_1/lib/libsqlplus.so
Following active executables are used by opatch process :
[Mar 4, 2021 3:31:14 PM] [INFO] Prerequisite check
"CheckActiveFilesAndExecutables" failed.
The details are:
Following active executables are not used by opatch process :
/app/app/oracle/product/19.0.0.0/dbhome_1/lib/libclntsh.so.19.1
/app/app/oracle/product/19.0.0.0/dbhome_1/lib/libsqlplus.so
Following active executables are used by opatch process :
[Mar 4, 2021 3:31:15 PM] [SEVERE] OUI-67073:UtilSession failed: Prerequisite
check "CheckActiveFilesAndExecutables" failed.
[Apr 8, 2021 10:39:06 PM] [INFO] Finish fuser command /bin/fuser
/u01/app/19.0.0.0/grid/bin/expdp at Thu Apr 08 22:39:06 CST 2021
[Apr 8, 2021 10:39:06 PM] [INFO] Following active executables are not used by
opatch process :
/u01/app/19.0.0.0/grid/lib/libasmclntsh19.so
/u01/app/19.0.0.0/grid/lib/libclntsh.so.19.1
Following active executables are used by opatch process :
[Apr 8, 2021 10:39:06 PM] [INFO] Prerequisite check
"CheckActiveFilesAndExecutables" failed.
The details are:
Following active executables are not used by opatch process :
/u01/app/19.0.0.0/grid/lib/libasmclntsh19.so
/u01/app/19.0.0.0/grid/lib/libclntsh.so.19.1
Following active executables are used by opatch process :
[Apr 8, 2021 10:39:06 PM] [SEVERE] OUI-67073:UtilSession failed: Prerequisite
check "CheckActiveFilesAndExecutables" failed.
可以通過 kill 占用進程進行處理
jieker1:~ # fuser -kv /u01/app/19.0.0.0/grid/lib/libclntsh.so.19.1
jieker1:~ # fuser -kv /u01/app/19.0.0.0/grid/lib/libasmclntsh19.so
7、 檢查/app/soft/32226239/32222571/files/bin/ocrcheck.bin 屬主(如果使用 oracle 用
戶解壓補丁，權限需要修改為 grid)
ls –l /app/soft/32226239/32222571/files/bin/ocrcheck.bin
chown grid:oinstall /app/soft/32226239/32222571/files/bin/ocrcheck.bin
單機 ASM 出現的權限問題
jiekexu:/u01/app/19.0.0.0/grid/bin # ls -l
/backup/soft/30899722/30894985/files/bin/ocrcheck.bin
-rwx------ 1 oracle oinstall 825152 Apr 11 2020
/backup/soft/30899722/30894985/files/bin/ocrcheck.bin
jiekexu:/u01/app/19.0.0.0/grid/bin # chown grid:oinstall
/backup/soft/30899722/30894985/files/bin/ocrcheck.bin
jiekexu:/u01/app/19.0.0.0/grid/bin # ls -l
/backup/soft/30899722/30894985/files/bin/ocrconfig.bin
-rwx------ 1 oracle oinstall 957136 Apr 11 2020
/backup/soft/30899722/30894985/files/bin/ocrconfig.bin
jiekexu:/u01/app/19.0.0.0/grid/bin # chown grid:oinstall
/backup/soft/30899722/30894985/files/bin/ocrconfig.bin
jiekexu:/u01/app/19.0.0.0/grid/bin # ls -l
/backup/soft/30899722/30894985/files/bin/ocrconfig.bin
-rwx------ 1 grid oinstall 957136 Apr 11 2020
/backup/soft/30899722/30894985/files/bin/ocrconfig.bin
如果權限錯誤將會產生報錯
Patch: /app/soft/32226239/32222571
Log: /app/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-03-
04_15-43-38PM_1.log
Reason: Failed during Analysis: CheckPatchApplicable Failed, [ Prerequisite
Status: FAILED, Prerequisite output:
The details are:
of 3
5墨值下載
【版權聲明】本文為墨天輪用戶原創內容，轉載時必須標注文檔的來源（墨天輪），文檔鏈接，文檔作者等基本信息，否則作者和墨天輪有權追究責任。如果您發現墨天輪中有涉嫌抄襲或者侵權的內容，歡迎發送郵件至：contact@modb.pro進行舉報，并提供相關證據，一經查實，墨天輪將立刻刪除相關內容。
下載排行榜
文檔被以下合輯收錄
評論