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

[oracle@node2 ~]$ sqlplus / as sysdba


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.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值