重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-00205: error in identifying control file [打印本页]

---

作者: denglj    时间: 2022-3-4 09:26
标题: ORA-00205: error in identifying control file

环境：RAC+Oracle 11.2.0.4+CentOS Linux release 7.9.2009 (Core)

问题描述：RAC环境搭建好后，节点2启动数据库出现ORA-00205异常报警，如下：

SQL>startup

ORACLEinstance started.

TotalSystem Global Area 3256942592 bytes

FixedSize                  2257640 bytes

VariableSize            2382368024 bytes

DatabaseBuffers          855638016 bytes

RedoBuffers               16678912 bytes

ORA-00205:error in identifying control file, check alert log for more info

查看报警信息：

ThuFeb 10 10:04:33 2022

ORA-15025:could not open disk "/dev/asm-diske"

ORA-27041:unable to open file

Linux-x86_64Error: 13: Permission denied

Additionalinformation: 9

ORA-15025:could not open disk "/dev/asm-diskf"

ORA-27041:unable to open file

Linux-x86_64Error: 13: Permission denied

Additionalinformation: 9

ORA-15025:could not open disk "/dev/asm-diskg"

ORA-27041:unable to open file

Linux-x86_64Error: 13: Permission denied

Additionalinformation: 9

ORA-15025:could not open disk "/dev/asm-diskh"

ORA-27041:unable to open file

Linux-x86_64Error: 13: Permission denied

Additionalinformation: 9

ORA-15025:could not open disk "/dev/asm-diski"

ORA-27041:unable to open file

Linux-x86_64Error: 13: Permission denied

Additionalinformation: 9

ThuFeb 10 10:04:33 2022

SUCCESS:diskgroup DATA was dismounted

ERROR:diskgroup DATA was not mounted

ORA-00210:cannot open the specified control file

ORA-00202:control file: '+DATA/orcl/controlfile/current.274.1096198881'

ORA-17503:ksfdopn:2 Failed to open file +DATA/orcl/controlfile/current.274.1096198881

ORA-15001:diskgroup "DATA" does not exist or is not mounted

ORA-15040:diskgroup is incomplete

ORA-15040:diskgroup is incomplete

ORA-15040:diskgroup is incomplete

ORA-15040:diskgroup is incomplete

ORA-15040:diskgroup is incomplete

ORA-205signalled during: alter database mount...

以下为磁盘组信息：

ASMCMD> lsdg

State    Type   Rebal  Sector  Block      AU  Total_MB  Free_MB Req_mir_free_MB Usable_file_MB  Offline_disks  Voting_files Name

MOUNTED  NORMAL N      512   4096 1048576     51200    38080       10240           13920              0             N DATA/

MOUNTED  NORMAL N      512   4096 1048576     15360    14434       5120            4657              0             Y OCR/

磁盘组挂载正常，判断造成此异常为权限问题，值得注意的是节点1不存在此问题。

经研究发现，很可能与$ORACLE_HOME/bin/oracle文件属性有关系。

解决过程：

查看节点1该文件情况：

[root@hisdb1 bin]# pwd

/u01/app/oracle/product/11.2.0/db/bin

[root@hisdb1bin]# ll

-rwsr-s--x 1 oracle asmadmin 239501488 Feb  8 20:15 oracle

查看节点2该文件情况：

[root@hisdb2bin]# ll

-rwsr-s--x 1 oracle oinstall 239501488 Feb  8 20:15 oracle

发现oracle文件在两个节点的所属组不同，原来在安装oracle soft后，$ORACLE_HOME/bin/oracle文件属性权限为oracle:oninstall 751(-rwxr-x--x)

当节点1在建库(DBCA)时,此文件属性被修改为oracle:asmadmin6751(-rwsr-s--x)

将节点2中该文件属性更改为与节点1相同.

节点2执行：

[root@hisdb2 bin]# pwd

/u01/app/oracle/product/11.2.0/db/bin

[root@hisdb2 bin]# chown -Roracle:asmadmin oracle

[root@hisdb2 bin]# chmod 6751oracle

验证：

[oracle@hisdb2:/home/oracle]$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Productionon Thu Feb 10 11:24:51 2022

Copyright (c) 1982, 2013,Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 3256942592bytes

Fixed Size                  2257640 bytes

Variable Size            2382368024 bytes

Database Buffers          855638016 bytes

Redo Buffers               16678912 bytes

Database mounted.

Database opened.

---

欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)

Powered by Discuz! X3.2