问题描述:
上周五下班后把测试rac关闭后,今天早上打开报以下错误:
[oracle@rac1 11.2.0]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 5 09:27:09 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/rac/spfilerac.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/rac/spfilerac.ora
ORA-12547: TNS:lost contact
解决方法:
1、首先通过crsctl stat res -t命令查看集群服务,发现服务正常;
2、查看grid用户下/u01/grid/app/11.2.0/grid/bin/oracle文件权限变为-rwxr-x--x,其正常权限应为-rwsr-s--x(6751),如下:
[grid@rac1 ~]$ cd /u01/grid/app/11.2.0/bin
[grid@rac1 bin]$ ls -lh oracle
-rwxr-x--x 1 grid oinstall 201M Mar 22 09:15 oracle