Oracle 11g RAC 补丁升级时报ORA-01565: error in identifying spfileprod.ora 错误处理
报错内容:
ORA-01565: error in identifying file '+DATA/PROD/parameterfile/spfileprod.ora'
CRS-5017: The resource action "ora.prod.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/PROD/parameterfile/spfileprod.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/PROD/parameterfile/spfileprod.ora
ORA-12547: TNS:lost contact
查看grid用户下面的oracle的权限(两个节点都需要执行)
[root@ vastda ta1 log]# su - grid
[grid@vastdata1 ~]$ ls -l $ORACLE_H OME/bin/oracle
-rwxr-x--x 1 grid oinstall 200678430 Oct 9 13:35 /u01/app/11.2.0/grid/bin/oracle
实验环境:
DB:Oracle 11.2.0.4 RAC
OS:Red Hat 6.5 企业版64位
处理过程:
今天在做Oracle 11g R2 RAC补丁升级时遇到下面的问题:CRS-5017: The resource action "ora.prod.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/PROD/parameterfile/spfileprod.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/PROD/parameterfile/spfileprod.ora
ORA-12547: TNS:lost contact
. For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/vastdata1/agent/crsd/oraagent_oracle/oraagent_oracle.log".
查阅MOS以及相关技术博客得知,可能和grid与oracle用户下面的oracle文件的权限有关!!!
结合之前因为grid整个目录权限改变,手动修改了,断定和权限有关。
查看grid用户下面的oracle的权限(两个节点都需要执行)
[root@ vastda ta1 log]# su - grid
[grid@vastdata1 ~]$ ls -l $ORACLE_H OME/bin/oracle
-rwxr-x--x 1 grid oinstall 200678430 Oct 9 13:35 /u01/app/11.2.0/grid/bin/oracle
权限不正确,修改(两个节点都需要执行)
[grid@ vastdata1 ~]$ chmod 6751 $ORACLE_HOME/bin/oracle
[grid@ vastdata1 ~]$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 grid oinstall 200678430 Oct 9 13:35 /u01/app/11.2.0/grid/bin/oracle
[grid@ vastdata1 ~]$ chmod 6751 $ORACLE_HOME/bin/oracle
[grid@ vastdata1 ~]$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 grid oinstall 200678430 Oct 9 13:35 /u01/app/11.2.0/grid/bin/oracle
查看oracle用户下面的oracle权限 (两个节点都需要执行)
[oracle@ vastdata1 trace]$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-x--x 1 oracle asmadmin 228886426 Oct 9 15:29 /u01/app/oracle/product/11.2.0/db_2/bin/oracle
在grid用户下面修改 (两个节点都需要执行)
[oracle@ vastdata1 trace]$ su - grid
Password:
[grid@ vastdata1 ~]$ cd $ORACLE_HOME/bin/
[grid@ vastdata1 bin]$ set
set setasmgid setasmgidwrap setfattr setkeycodes setmetamode setsid setup
setarch setasmgid0 setfacl setfont setleds setserial setterm setxkbmap
[grid@ vastdata1 bin]$ setasmgidwrap o=/u01/app/oracle/product/11.2.0/db_2/bin/oracle
[grid@ vastdata1 bin]$ ls -l /u01/app/oracle/product/11.2.0/db_2/bin/oracle
-rwsr-s--x 1 oracle asmadmin 228886426 Oct 9 15:29 /u01/app/oracle/product/11.2.0/db_2/bin/oracle
再次启动集群数据库:
crsctl start res -d VDREP -all
crsctl start res -d VDREP -all
再次启动正常 !
查看集群状态:
[grid@vastdata2 bin]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE vastdata1
ONLINE ONLINE vastdata2
ora.FRA.dg
ONLINE ONLINE vastdata1
ONLINE ONLINE vastdata2
ora.LISTENER.lsnr
ONLINE ONLINE vastdata1
ONLINE ONLINE vastdata2
ora.OCR.dg
ONLINE ONLINE vastdata1
ONLINE ONLINE vastdata2
ora.asm
ONLINE ONLINE vastdata1 Started
ONLINE ONLINE vastdata2 Started
ora.gsd
OFFLINE OFFLINE vastdata1
OFFLINE OFFLINE vastdata2
ora.net1.network
ONLINE ONLINE vastdata1
ONLINE ONLINE vastdata2
ora.ons
ONLINE ONLINE vastdata1
ONLINE ONLINE vastdata2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE vastdata1
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE vastdata2
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE vastdata2
ora.cvu
1 ONLINE ONLINE vastdata2
ora.oc4j
1 ONLINE ONLINE vastdata2
ora.prod.db
1 ONLINE ONLINE vastdata1 Open
2 ONLINE ONLINE vastdata2 Open
ora.scan1.vip
1 ONLINE ONLINE vastdata1
ora.scan2.vip
1 ONLINE ONLINE vastdata2
ora.scan3.vip
1 ONLINE ONLINE vastdata2
ora.vastdata1.vip
1 ONLINE ONLINE vastdata1
ora.vastdata2.vip
1 ONLINE ONLINE vastdata2
[grid@vastdata2 bin]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE vastdata1
ora.FRA.dg ora....up.type ONLINE ONLINE vastdata1
ora....ER.lsnr ora....er.type ONLINE ONLINE vastdata1
ora....N1.lsnr ora....er.type ONLINE ONLINE vastdata1
ora....N2.lsnr ora....er.type ONLINE ONLINE vastdata2
ora....N3.lsnr ora....er.type ONLINE ONLINE vastdata2
ora.OCR.dg ora....up.type ONLINE ONLINE vastdata1
ora.asm ora.asm.type ONLINE ONLINE vastdata1
ora.cvu ora.cvu.type ONLINE ONLINE vastdata2
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE vastdata1
ora.oc4j ora.oc4j.type ONLINE ONLINE vastdata2
ora.ons ora.ons.type ONLINE ONLINE vastdata1
ora.prod.db ora....se.type ONLINE ONLINE vastdata1
ora.scan1.vip ora....ip.type ONLINE ONLINE vastdata1
ora.scan2.vip ora....ip.type ONLINE ONLINE vastdata2
ora.scan3.vip ora....ip.type ONLINE ONLINE vastdata2
ora....SM1.asm application ONLINE ONLINE vastdata1
ora....A1.lsnr application ONLINE ONLINE vastdata1
ora....ta1.gsd application OFFLINE OFFLINE
ora....ta1.ons application ONLINE ONLINE vastdata1
ora....ta1.vip ora....t1.type ONLINE ONLINE vastdata1
ora....SM2.asm application ONLINE ONLINE vastdata2
ora....A2.lsnr application ONLINE ONLINE vastdata2
ora....ta2.gsd application OFFLINE OFFLINE
ora....ta2.ons application ONLINE ONLINE vastdata2
ora....ta2.vip ora....t1.type ONLINE ONLINE vastdata2
总结:
每次升级或者迁移都会遇到各种各样的问题,一味着急是解决不了问题的,你需要冷静下来,认真分析报错内容,根据提示信息查看相关日志。根据日志内容,确定具体报错。然后查阅MOS以及其他相关技术文档,寻得解决之法。