SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 4 13:31:46 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/rac11g/spfilerac11g.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/rac11g/spfilerac11g.ora
ORA-12547: TNS:lost contact
SQL> exit
Disconnected
查看grid用户下面的oracle文件的权限
[oracle@node2 ~]$ su - grid
Password:
[grid@node2 ~]$ cd /u01/app/grid/bin/
[grid@node2 bin]$ ls -l oracle
-rwxr-x--x 1 grid oinstall 209914519 Jun 26 21:46 oracle
权限不对需要修改
[grid@node2 bin]$ chmod 6751 oracle
[grid@node2 bin]$ ls -l oracle
-rwsr-s--x 1 grid oinstall 209914519 Jun 26 21:46 oracle
再查看oracle用户下oracle文件的权限
[grid@node2 bin]$ su - oracle
Password:
[oracle@node2 ~]$ cd $ORACLE_HOME/bin/
[oracle@node2 bin]$ ls -l oracle
-rwsr-s--x 1 oracle asmadmin 239626689 Jun 26 23:08 oracle
回到grid用户下修改
[oracle@node2 bin]$ su - grid
Password:
[grid@node2 ~]$ cd $ORACLE_HOME/bin/
[grid@node2 bin]$ setasmgidwrap o=/u01/app/oracle/product/11.2.0/db_1/bin/oracle
[oracle@node2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 4 13:29:41 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 914440192 bytes
Fixed Size 2258600 bytes
Variable Size 645925208 bytes
Database Buffers 260046848 bytes
Redo Buffers 6209536 bytes
Database mounted.
Database opened.