ORA-00221 ORA-00206 ORA-00206 ORACLE用户对ASM没权限

最新推荐文章于 2024-10-05 15:25:14 发布

原创最新推荐文章于 2024-10-05 15:25:14 发布 · 2.9k 阅读

0 ·

CC 4.0 BY-SA版权

oracle 专栏收录该内容

11 篇文章

订阅专栏

在尝试打开只读数据库或挂载备用数据库时，遇到了ORA-00221和ORA-00206错误，指出控制文件写入失败。此问题可能与ASM（Automatic Storage Management）权限有关。在进行数据库实例关闭、重新启动和nomount/mount操作后，错误仍然存在。详细的问题分析和解决步骤将在后续部分展开。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一. 问题描述：

DG搭建后之后发现备库无法打开

SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-00221: error on write to control file
ORA-00206: error in writing (block 17, # blocks 1) of control file
ORA-00202: control file: '+DATA/stdo/controlfile/current.259.929097275'
ORA-15081: failed to submit an I/O operation to a disk
ORA-15081: failed to submit an I/O operation to a disk
ORA-00206: error in writing (block 17, # blocks 1) of control file
ORA-00202: control file: '+DATA/stdo/controlfile/current.258.929097275'
ORA-15081: failed to submit an I/O operation to a disk
ORA-15081: failed to submit an I/O operation to a disk

重启后亦无法mount

SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
[oracle@adminm dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 28 11:19:36 2016

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

Connected to an idle instance.

SQL> startup nomount pfile='/u01/app/oracle/product/11.2/db_1/dbs/initstdo.ora';
ORACLE instance started.

Total System Global Area 1.4665E+10 bytes
Fixed Size 2267424 bytes
Variable Size 2684356320 bytes
Database Buffers 1.1945E+10 bytes
Redo Buffers 32624640 bytes
SQL> alter database mount standby database;
alter database mount standby database
*
ERROR at line 1:
ORA-00221: error on write to control file
ORA-00206: error in writing (block 1, # blocks 1) of control file
ORA-00202: control file: '+DATA/stdo/controlfile/current.258.929097275'
ORA-15081: failed to submit an I/O operation to a disk
ORA-15081: failed to submit an I/O operation to a disk

SQL>
SQL>

二. 问题分析：

[oracle@adminm dbs]$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle oinstall 239840842 Nov 24 11:18 /u01/app/oracle/product/11.2/db_1/bin/oracle
[oracle@adminm dbs]$

三. 问题解决：

[root@adminm ~]# su - grid
[grid@adminm ~]$
[grid@adminm ~]$ cd $ORACLE_HOME
[grid@adminm grid]$ pwd
/u01/app/11.2.0/grid
[grid@adminm grid]$ cd bin
[grid@adminm bin]$ ls setasmgidwrap
setasmgidwrap
[grid@adminm bin]$ ./setasmgidwrap o=/u01/app/oracle/product/11.2/db_1/bin/oracle
[grid@adminm bin]$

[oracle@adminm ~]$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle asmadmin 239840842 Nov 24 11:18 /u01/app/oracle/product/11.2/db_1/bin/oracle
[oracle@adminm ~]$