标题: 『ORACLE』ORA-01565: error in identifying file '+DATA/rac11g/spfilerac11g.ora... [打印本页] 作者: jiawang 时间: 2020-5-13 16:17 标题: 『ORACLE』ORA-01565: error in identifying file '+DATA/rac11g/spfilerac11g.ora... [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>