Oracle11g R2 RAC ORA-01565: error in identifying file ‘+DGSYSTEM/test/spfiletest.ora‘

【问题背景】公司测试环境,因新建了个目录把整个Oracle环境目录的权限给改了,导致重启实例时出现如下问题

[root@testb ~]# srvctl start instance -d test -i test2
PRCR-1013 : Failed to start resource ora.test.db
PRCR-1064 : Failed to start resource ora.test.db on node testb
CRS-5017: The resource action "ora.test.db start" encountered the following error: 
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DGSYSTEM/test/spfiletest.ora'
ORA-17503: ksfdopn:2 Failed to open file +DGSYSTEM/test/spfiletest.ora
ORA-12547: TNS:lost contact
. For details refer to "(:CLSN00107:)" in "/oracle/app/11.2.0/grid/log/testb/agent/crsd/oraagent_oracle/oraagent_oracle.log".

CRS-2674: Start of 'ora.test.db' on 'testb' failed
[root@testb ~]# 

【处理】

在做这步操作之前,最好先按部署时的权限顺序,对各个目录赋权限,然后再进行接下来的操作

su - grid
cd $ORACLE_HOME/bin
ls -lsa oracle
204920 -rwxrwxr-x 1 grid oinstall 209836240 Jan  9 23:01 oracle

chmod 6751 oracle
ls -lsa oracle
204920 -rwsr-s--x 1 grid oinstall 209836240 Jan  9 23:01 oracle

su - oracle
cd $ORACLE_HOME/bin
ls -lsa oracle

chmod 6751 oracle
ls -lsa oracle
233892 -rwsr-x--x 1 oracle asmadmin 239501480 Jan  9 23:30 oracle

##启动实例并检查状态
[root@testb ~]# srvctl start instance -d test -i test2
[root@testb ~]# crsctl status res -t

[root@testb ~]# crsctl status res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DGDATA01.dg
               ONLINE  ONLINE       testa                                       
               ONLINE  ONLINE       testb                                       
ora.DGGRID1.dg
               ONLINE  ONLINE       testa                                       
               ONLINE  ONLINE       testb                                       
ora.DGRECOVERY.dg
               ONLINE  ONLINE       testa                                       
               ONLINE  ONLINE       testb                                       
ora.DGSYSTEM.dg
               ONLINE  ONLINE       testa                                       
               ONLINE  ONLINE       testb                                       
ora.LISTENER.lsnr
               ONLINE  ONLINE       testa                                       
               ONLINE  ONLINE       testb                                       
ora.asm
               ONLINE  ONLINE       testa                   Started             
               ONLINE  ONLINE       testb                   Started             
ora.gsd
               OFFLINE OFFLINE      testa                                       
               OFFLINE OFFLINE      testb                                       
ora.net1.network
               ONLINE  ONLINE       testa                                       
               ONLINE  ONLINE       testb                                       
ora.ons
               ONLINE  ONLINE       testa                                       
               ONLINE  ONLINE       testb                                       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       testa                                       
ora.cvu
      1        ONLINE  ONLINE       testa                                       
ora.test.db
      1        ONLINE  ONLINE       testa                   Open                
      2        ONLINE  ONLINE       testb                   Open                
ora.testa.vip
      1        ONLINE  ONLINE       testa                                       
ora.testb.vip
      1        ONLINE  ONLINE       testb                                       
ora.oc4j
      1        ONLINE  ONLINE       testa                                       
ora.scan1.vip
      1        ONLINE  ONLINE       testa                                       
[root@testb ~]# 

##若还不能启动,则可试试重启集群节点
crsctl restart crs

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值