【问题背景】公司测试环境,因新建了个目录把整个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