『ORACLE』ORA-01565: error in identifying file '+DATA/rac11g/spfilerac11g.ora'(11g)
来源:互联网 发布:ccd视觉编程软件 编辑:程序博客网 时间:2024/05/22 11:33
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.
- 『ORACLE』ORA-01565: error in identifying file '+DATA/rac11g/spfilerac11g.ora'(11g)
- ORA-01565: error in identifying file '+DATA/spfilerac.ora'
- Oracle 11g RAC 补丁升级时报ORA-01565: error in identifying spfileprod.ora 错误处理
- 天灾还是人祸:ORA-01565: error in identifying file '/u01/app/oracle/oradata/eftp/testNS.dbf'
- Oracle RMAN 丢失归档日志:ORA-19625: error identifying file
- 【Oracle问题集4】ORA-00205 error in identifying controlfile
- ORA-19625: error identifying file /home/oracle/arch1_13_949547843.dbf ORA-27037: unable to obtain fi
- 启动oracle数据库报错ORA-00205: error in identifying control file, check alert log for more info
- ORA-00205: error in identifying control file, check alert log for more info
- ORA-00205: error in identifying control file, check alert log for more info
- ORA-00205: error in identifying control file, check alert log for more info
- 解决案例:ORA-00205: error in identifying control file, check alert log for more info
- ORACLE11g 实例启动报错 ORA-00205: error in identifying control file, check alert log for more info
- oracle 11g,ora-00257,ora-09945
- ORACLE 11G收缩表空间报错 ORA-03297: file contains used data beyondrequested RESIZE value
- ORACLE 10G imp error: ORA-12899
- ORA-01110: data file
- oracle 11g ora-00972
- 移动端图片自适应
- EasyUI修改DateBox和DateTimeBox的默认日期格式,中文问题
- c++ 二维数组出杨辉三角
- Scala入门到精通——第十九节 隐式转换与隐式参数(二)
- 欢迎使用CSDN-markdown编辑器
- 『ORACLE』ORA-01565: error in identifying file '+DATA/rac11g/spfilerac11g.ora'(11g)
- jeb2.2.5 破解版
- 学习的步伐(六) Kotlin 学习总结:类的特性
- shell脚本将gbk文件转化为utf-8
- oracle 根据时间排序,删除相邻的除排序字段均相同的两条中较新的一条记录
- 突然想写点东西
- TOMCAT动态热部署WEB项目依赖的第三方jar包
- HDU
- github客户端上传代码 mac 注意事项