ORACLE11g 实例启动报错 ORA-00205 error in identifying control fil

首先给大家推荐一下我老师大神的人工智能教学网站。教学不仅零基础,通俗易懂,而且非常风趣幽默,还时不时有内涵黄段子!点这里可以跳转到网站 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                 string      /oracle11/app/oracle/diag/rdbm
                                                 s/db11/db11/trace
core_dump_dest                       string      /oracle11/app/oracle/diag/rdbm
                                                 s/db11/db11/cdump
max_dump_file_size                   string      unlimited
shadow_core_dump                     string      partial
user_dump_dest                       string      /oracle11/app/oracle/diag/rdbm
                                                 s/db11/db11/trace
SQL> 

查看alet日志信息:

ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup DATA was dismounted
ERROR: diskgroup DATA was not mounted
ORA-15025: could not open disk “/dev/raw/raw2”
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup DATA was dismounted
ERROR: diskgroup DATA was not mounted
ORA-15025: could not open disk “/dev/raw/raw2”
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup DATA was dismounted
ERROR: diskgroup DATA was not mounted

但是检查ASM实例都是启动了的,状态是ok的,ASM实例启动正常,但是挂载的磁盘ORACLE用户无法访问,看下/dev/raw/raw2的权限:

[root@test raw]

# ls -al
total 0
drwxr-xr-x  2 root root         80 Mar  9 18:22 .
drwxr-xr-x 12 root root       3820 Mar  9 18:22 ..
crw——-  1 grid oinstall 162, 1 Mar 13 16:23 raw1
crw——-  1 grid oinstall 162, 2 Mar 13 16:23 raw2

[root@test raw]

#
权限明显不足,添加oracle用户的访问执行权限,我这就直接chmod 777 *了

[root@test raw]

# chmod 777 *

[root@test raw]

# ls -al
total 0
drwxr-xr-x  2 root root         80 Mar  9 18:22 .
drwxr-xr-x 12 root root       3820 Mar  9 18:22 ..
crwxrwxrwx  1 grid oinstall 162, 1 Mar 13 16:23 raw1
crwxrwxrwx  1 grid oinstall 162, 2 Mar 13 16:23 raw2

[root@test raw]

然后去打开数据库:
SQL> alter database mount;

Database altered.

SQL> 
SQL> 
SQL> alter database open;

Database altered.

SQL>

解决了…

点这里可以跳转到人工智能网站

发表评论