共計 8766 個字符，預計需要花費 22 分鐘才能閱讀完成。
丸趣 TV 小編給大家分享一下 AIX 平臺中 oracle 數據庫與打補丁常見錯誤有哪些，相信大部分人都還不怎么了解，因此分享這篇文章給大家參考一下，希望大家閱讀完這篇文章后大有收獲，下面讓我們一起去了解一下吧！
1、執行安裝時，圖形界面無法彈出并報錯.
$ ./runInstaller
********************************************************************************
Your platform requires the root user to perform certain pre-installation
OS preparation. The root user should run the shell script rootpre.sh before
you proceed with Oracle installation. rootpre.sh can be found at the top level
of the CD or the stage area.
Answer y if root has run rootpre.sh so you can proceed with Oracle
installation.
Answer n to abort installation and then ask root to run rootpre.sh .
********************************************************************************
Has rootpre.sh been run by root on all nodes? [y/n] (n)
y
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 190 MB. Actual 8346 MB Passed
Checking swap space: must be greater than 150 MB. Actual 16384 MB Passed
Checking monitor: must be configured to display at least 256 colors
Could not execute auto check for display colors using command /usr/bin/X11/xdpyinfo. Check if the DISPLAY variable is set. Failed
Some requirement checks failed. You must fulfill these requirements before
continuing with the installation,
Continue? (y/n) [n] y
Ignoring required pre-requisite failures. Continuing…
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-10-11_02-15-45PM. Please wait …$ Exception in thread main java.lang.NoClassDefFoundError: sun.awt.motif.MToolkit (initialization failure)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:134)
at java.lang.Class.forNameImpl(Native Method)
at java.lang.Class.forName(Class.java:173)
at java.awt.Toolkit$2.run(Toolkit.java:864)
at java.security.AccessController.doPrivileged(AccessController.java:192)
at java.awt.Toolkit.getDefaultToolkit(Toolkit.java:847)
at com.jgoodies.looks.LookUtils.isLowResolution(LookUtils.java:484)
at com.jgoodies.looks.LookUtils. clinit (LookUtils.java:249)
at java.lang.J9VMInternals.initializeImpl(Native Method)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:196)
at com.jgoodies.looks.plastic.PlasticLookAndFeel. clinit (PlasticLookAndFeel.java:135)
at java.lang.J9VMInternals.initializeImpl(Native Method)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:196)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:161)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:161)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:161)
at java.lang.Class.forNameImpl(Native Method)
at java.lang.Class.forName(Class.java:206)
at javax.swing.SwingUtilities.loadSystemClass(SwingUtilities.java:1812)
at javax.swing.UIManager.setLookAndFeel(UIManager.java:510)
at oracle.install.commons.util.Application.startup(Application.java:785)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:165)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:182)
at oracle.install.commons.base.driver.common.Installer.startup(Installer.java:348)
at oracle.install.ivw.crs.driver.CRSInstaller.startup(CRSInstaller.java:98)
at oracle.install.ivw.crs.driver.CRSInstaller.main(CRSInstaller.java:105)
解決方法：
步驟:
① root 用戶下 export DISPLAY= xx.xx.xx.xx:0.0 其中 xx.xx.xx.xx 為我本地電腦的 IP
② vi /etc/ssh/sshd_config
找到 #X11Forwarding no 這一行，將其改為 X11Forwarding yes (前面的 #要去掉)
③重新啟動 ssh:
stopsrc -s sshd
startsrc -s sshd
④ 然后斷開 xshell 重新登錄系統（任意用戶），就可以調出圖像界面了。
2、打補丁時，報如下錯誤。
# /u01/app/11.2.0.4/grid/OPatch/opatch auto /tmp/23274134 -ocmrf /tmp/ocm.rsp
Executing /u01/app/11.2.0.4/grid/perl/bin/perl /u01/app/11.2.0.4/grid/OPatch/crs/patch21203.pl -patchdir /tmp -patchn 23274134 -ocmrf /tmp/ocm.rsp -paramfile /u01/app/11.2.0.4/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/11.2.0.4/grid/cfgtoollogs/opatchauto2016-10-17_15-17-30.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0.4/grid/cfgtoollogs/opatchauto2016-10-17_15-17-30.report.log
2016-10-17 15:17:30: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0.4/grid/crs/install/crsconfig_params
The opatch minimum version check for patch /tmp/23274134/23054359 failed for /u01/app/11.2.0.4/grid
The opatch minimum version check for patch /tmp/23274134/23054319 failed for /u01/app/11.2.0.4/grid
The opatch minimum version check for patch /tmp/23274134/22502505 failed for /u01/app/11.2.0.4/grid
Opatch version check failed for oracle home /u01/app/11.2.0.4/grid
Opatch version check failed
ERROR: update the opatch version for the failed homes and retry
opatch auto failed.
#
查看日志發現如下報錯
2016-10-12 15:44:28: The opatch minimum version check for patch /tmp/23274134/22502505 failed for /u01/app/11.2.0.4/grid
2016-10-12 15:44:28: The opatch version check failed with following error
2016-10-12 15:44:28: Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2016, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/11.2.0.4/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0.4/grid/oraInst.loc
OPatch version : 11.2.0.3.15
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0.4/grid/cfgtoollogs/opatch/opatch3016-10-12_15-44-27PM_1.log
OPatch failed to lock and get an Inventory Session for the given Oracle Home /u01/app/11.2.0.4/grid
Possible causes are:
No read or write permission to $ORACLE_HOME, cannot create $ORACLE_HOME/.patch_storage
No read or write permission to $ORACLE_HOME/.patch_storage
OPatch cannot proceed further because system will not be able to backup files, or read the backup area for rollback/restore.
OPatchSession cannot load inventory for the given Oracle Home /u01/app/11.2.0.4/grid. Possible causes are:
No read or write permission to ORACLE_HOME/.patch_storage
Central Inventory is locked by another OUI instance
No read permission to Central Inventory
The lock file exists in ORACLE_HOME/.patch_storage
The Oracle Home does not exist in Central Inventory
UtilSession failed: IPMRWServices::verifyPatchStorageDirectory() cannot read or write to /u01/app/11.2.0.4/grid/.patch_storage
OPatch failed with error code 73
2016-10-12 15:44:28: Status of opatch version check for /u01/app/11.2.0.4/grid is 0
2016-10-12 15:44:28: Opatch version check failed for oracle home /u01/app/11.2.0.4/grid
2016-10-12 15:44:28: Opatch version check failed
2016-10-12 15:44:28: ERROR: update the opatch version for the failed homes and retry
解決方法：
grid 用戶對 /u01/app/11.2.0.4/grid 目錄沒有寫權限導致 patch 失敗。
3、打補丁報錯
# /u01/app/11.2.0.4/grid/OPatch/opatch auto /tmp/23274134 -ocmrf /tmp/ocm.rsp
Executing /u01/app/11.2.0.4/grid/perl/bin/perl /u01/app/11.2.0.4/grid/OPatch/crs/patch21203.pl -patchdir /tmp -patchn 23274134 -ocmrf /tmp/ocm.rsp -paramfile /u01/app/11.2.0.4/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/11.2.0.4/grid/cfgtoollogs/opatchauto2016-10-12_16-44-23.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0.4/grid/cfgtoollogs/opatchauto2016-10-12_16-44-23.report.log
2016-10-12 16:44:23: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0.4/grid/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11.2.0.4/dbhome_1 …
Stopped RAC /u01/app/oracle/product/11.2.0.4/dbhome_1 successfully
ERROR: prepatch execution for DB home … failed
opatch auto failed.
#
解決方法：
補丁程序文件權限不對導致打補丁失敗，做如下處理：
chown -R grid:oinstall /tmp/23274134
chmod -R 777 /tmp/23274134
4、安裝檢測報告告警
解決方法：
系統版本為 AIX6.1(6100-09-03-1415)，數據庫安裝檢測報缺少 IZ97457，IZ88711,IZ89514, 該包已在該版中被修正. 可以忽略.
5、rfc1323 告警
解決方法：
rfc1323 已被修改為 1, 檢測仍然報錯，使用如下命令進行修改
ifconfig en4 rfc1323 1
ifconfig en6 rfc1323 1
6、打完補丁之后 oracle 執行文件權限發生了變化, 數據庫啟動報錯
SQL startup
ORA-01565: error in identifying file +DATA/zx/spfilejxkzx.ora
ORA-17503: ksfdopn:2 Failed to open file +DATA/zx/spfilejxkzx.ora
ORA-15001: diskgroup DATA does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
SQL
數據庫警告日志報錯如下：
RSMN started with pid=33, OS id=3605444
ORACLE_BASE from environment = /u01/app/oracle
NOTE: Loaded library: System
ORA-15025: could not open disk /dev/rhdisk5
ORA-27041: unable to open file
IBM AIX RISC System/6000 Error: 13: Permission denied
Additional information: 11
ORA-15025: could not open disk /dev/rhdisk6
ORA-27041: unable to open file
IBM AIX RISC System/6000 Error: 13: Permission denied
Additional information: 11
ORA-15025: could not open disk /dev/rhdisk7
ORA-27041: unable to open file
IBM AIX RISC System/6000 Error: 13: Permission denied
Additional information: 11
ORA-15025: could not open disk /dev/rhdisk8
ORA-27041: unable to open file
IBM AIX RISC System/6000 Error: 13: Permission denied
Additional information: 11
SUCCESS: diskgroup DATA was dismounted
ERROR: diskgroup DATA was not mounted
ORA-01565: Unable to open Spfile +DATA/zx/spfilejxkzx.ora.
USER (ospid: 3015500): terminating the instance due to error 1565
Wed Oct 12 18:16:35 2016
ORA-1092 : opitsk aborting process
Instance terminated by USER, pid = 3015500
解決方法
# cd /u01/app/oracle/product/11.2.0.4/dbhome_1/bin
# ls -l oracle
-rwsr-s–x 1 oracle oinstall 309472813 Oct 12 12:08 oracle
修改
# chown oracle:asmadmin oracle
# ls -l oracle
-rwsr-s–x 1 oracle asmadmin 309472813 Oct 12 12:08 oracle
#
以上是“AIX 平臺中 oracle 數據庫與打補丁常見錯誤有哪些”這篇文章的所有內容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內容對大家有所幫助，如果還想學習更多知識，歡迎關注丸趣 TV 行業資訊頻道！
