ORACLE11g 实例启动报错 ORA-00205: error in identifying control file, check alert log for more info

最新推荐文章于 2024-03-16 20:27:59 发布

chengxuefei_bj

最新推荐文章于 2024-03-16 20:27:59 发布

阅读量2.7w

点赞数 2

分类专栏： oracle故障处理文章标签： ORA-00205

本文链接：https://blog.csdn.net/chengxuefei_bj/article/details/50887904

版权

本文档描述了在尝试启动Oracle 11g实例时遇到ORA-00205错误的解决过程。错误原因在于控制文件无法被识别，通过检查alert日志发现与磁盘权限相关。解决方案是为ORACLE用户添加对/dev/raw/raw2的执行权限，从而成功启动并挂载数据库。

摘要由CSDN通过智能技术生成

ORACLE11g 实例启动报错：
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1607008256 bytes
Fixed Size 1364928 bytes
Variable Size 922750016 bytes
Database Buffers 671088640 bytes
Redo Buffers 11804672 bytes
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
SQL>

查看alert日志：
SQL> show parameter dump

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest