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

在尝试打开只读数据库或挂载备用数据库时,遇到了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 ~]$






评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值