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

来源:互联网 发布:ccd视觉编程软件 编辑:程序博客网 时间:2024/05/22 11:33
[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.

阅读全文
0 0
原创粉丝点击