AIX平台署部Oracle数据库与打补丁常见错误(2)

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、安装检测报告告警

AIX平台署部Oracle数据库与打补丁常见错误

解决方法:

系统版本为AIX6.1(6100-09-03-1415),数据库安装检测报缺少IZ97457,IZ88711,IZ89514,该包已在该版中被修正.可以忽略.

5、rfc1323告警

AIX平台署部Oracle数据库与打补丁常见错误

解决方法:

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

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/304ed7aaa3680f2adf4cc16c7684907f.html