Executing /u01/app/11.2.0.4/grid/perl/bin/perl /u01/app/11.2.0.4/grid/OPatch/crs/patch11203.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