『ORACLE』ORA-01565: error in identifying file '+DATA/rac11g/spfilerac11g.ora...

jiawang

[oracle@strong ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed May 13 15:50:32 2020
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/orcl/spfileorcl.ora'
ORA-17503: ksfdopn:10 Failed to open file +DATA/orcl/spfileorcl.ora
ORA-29701: unable to connect to Cluster Synchronization Service
SQL>

查看grid用户下面的oracle文件的权限
[grid@strong ~]$ cd $ORACLE_HOME
[grid@strong grid]$ cd bin
[grid@strong bin]$ ls -ltr oracle
-rwxr-x--x 1 grid oinstall 209840384 May  9 11:38 oracle
权限不对需要修改
[grid@strong bin]$ chmod 6751 oracle
[grid@strong bin]$ ls -ltr oracle
-rwsr-s--x 1 grid oinstall 209840384 May  9 11:38 oracle

再查看oracle用户下oracle文件的权限
[oracle@strong ~]$ cd $ORACLE_HOME
[oracle@strong db_1]$ cd bin
[oracle@strong bin]$ ls -ltr oracle
-rwsr-s--x 1 oracle asmadmin 239854288 May 13 14:41 oracle

[oracle@strong ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed May 13 16:01:58 2020
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area 4275781632 bytes
Fixed Size                  2260088 bytes
Variable Size            1174406024 bytes
Database Buffers         3087007744 bytes
Redo Buffers               12107776 bytes
Database mounted.
Database opened.
SQL>