ORA-00221 ORA-00206 ORA-00206 ORACLE用户对ASM没权限
来源:互联网 发布:linux max map count 编辑:程序博客网 时间:2024/06/07 06:27
一. 问题描述:
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>
二. 问题分析:
-rwsr-s--x 1 oracle oinstall 239840842 Nov 24 11:18 /u01/app/oracle/product/11.2/db_1/bin/oracle
[oracle@adminm dbs]$
三. 问题解决:
[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]$
-rwsr-s--x 1 oracle asmadmin 239840842 Nov 24 11:18 /u01/app/oracle/product/11.2/db_1/bin/oracle
[oracle@adminm ~]$
- ORA-00221 ORA-00206 ORA-00206 ORACLE用户对ASM没权限
- grid与oracle用户下oracle程序权限不一致导致ORA-15055/ORA-27123无法连接ASM问题
- Oracle ASM错误之--ORA-15031、ORA-15014
- oracle 11g ASM 的管理用户 asm shutdown immediate ORA-01031: insufficient privileges
- ORA-15196 ORACLE ASM问题详解
- ORA-15196 ORACLE ASM问题详解
- Oracle ASM错误之--ORA-15033
- oracle ASM实例ORA-04031故障处理
- oracle错误 ORA-01950 对表空间"system"无权限
- oracle错误- ora-01950 对表空间无权限
- ORA
- ora
- ORA-15064与ASM
- oracle listener.ora sqlnet.ora tnsnames.ora
- Oracle sqlnet.ora, tnsnames.ora, listener.ora
- Oracle ORA-01034,ORA-27101,ORA-00600
- oracle ORA-01200&ORA-01110&ORA-01122
- ORACLE ORA-00132 ORA-00214
- phpssdbadmin环境搭建与配置
- Shader整理
- opencv3.1中利用SIFT特征及RANSAC筛选进行图像矫正
- 云SIM带来的革命
- 常用APDU指令错误码
- ORA-00221 ORA-00206 ORA-00206 ORACLE用户对ASM没权限
- C++Builder建立及调用DLL
- 关于Less里的css一些规则,了解入门less
- PHP连接SQLserver中文字符编码报错的解决
- 代理模式
- 多渠道打包
- 字符集与编码格式
- CTF中常见的隐藏手段总结
- 将一个字符串转换成一个整数,要求不能使用字符串转换整数的库函数