asm 实例无法加载diskgroups,ORA-15110: no diskgroups mounted
来源:互联网 发布:任务安排软件 编辑:程序博客网 时间:2024/04/29 15:15
今天安装oracle11g R2的grid,装完之后发现无法加载diskgroups,报错如下:
SQL> startup
ORA-00099: warning: no parameter file specified for ASM instance
ASM instance started
Total System Global Area 283930624 bytes
Fixed Size 2225792 bytes
Variable Size 256539008 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted
(1)分析认为是由于ORA-00099引起,无法找到diskgroup。
(2)在网上搜索得到asm参数文件的配置格式如下:
asm_diskstring='/dev/oracleasm/disks/DISK*'
asm_diskgroups='DATA'
asm_power_limit=1
diagnostic_dest='/opt/oracle'
instance_type='asm'
large_pool_size=12M
remote_login_passwordfile='EXCLUSIVE'
生成文件:$ORACLE_HOME/grid/dbs/init+ASM.ora
注意asm_diskstring中必须包含“*”才能正确加载,否则报下面错误
SQL> startup
ASM instance started
Total System Global Area 283930624 bytes
Fixed Size 2225792 bytes
Variable Size 256539008 bytes
ASM Cache 25165824 bytes
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"
(3)保存设置到spfile
SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]
lsts[0]]
产生这个问题的原因为ORACLE认为ASM实例是手工创建的,并没有注册这个资源,那么首先增加ASM资源
需要使用下面命令注册asm
srvctl add asm -l LISTENER -d '/dev/oracleasm/disks/DISK*'
然后重新执行命令:
SQL> create spfile from pfile;
File created.
(4)关闭asm实例后重新启动,成功加载:
SQL> startup
ASM instance started
Total System Global Area 283930624 bytes
Fixed Size 2225792 bytes
Variable Size 256539008 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
ASM diskgroups volume enabled
- asm 实例无法加载diskgroups,ORA-15110: no diskgroups mounted
- asm 实例无法加载diskgroups,ORA-15110: no diskgroups mounted
- ORA-15110: no diskgroups mounted
- Steps to Re-Create ASM Diskgroups
- Steps to Re-Create ASM Diskgroups
- Can External Tables Be Placed inside ASM diskgroups [ID 470989.1]
- How To Create ASM Diskgroups using NFS/NAS Files
- How To Create ASM Diskgroups using NFS/NAS Files
- Oracle ASM Advanced Tranning 3 —— Create ASM Instance and Managing Diskgroups
- How to configure dbconsole to display information from the ASM DISKGROUPS [ID 329581.1]
- Exact Steps To Migrate ASM Diskgroups To Another SAN Without Downtime.
- How to collect the full path name of the files in ASM diskgroups (文档 ID 888943.1)
- How to collect the full path name of the files in ASM diskgroups (文档 ID 888943.1)
- ASM实例启动报错:ORA-29701、ORA-15110解决方案
- ORA-15039: diskgroup not dropped ORA-15073: diskgroup DATA1 is mounted by another ASM instance
- asm无法加载磁盘
- ASM无法发现磁盘组----ORA-29780
- oracle ASM实例ORA-04031故障处理
- 托福写作备考经验:多练习全文写作
- poj2892 树状数组+二分
- Map集合的两种取出方式
- WIN7操作系统安装linux形成双系统详解
- MyEclipse8.6 性能优化
- asm 实例无法加载diskgroups,ORA-15110: no diskgroups mounted
- Perl 与 Python 之间的一些异同
- 如何更快的理解简单的排序算法
- Posix有名信号灯
- Magento简单的EAV数据查询
- 【SQL】isNull的使用
- 自定义Magento系统配置(6)
- 五楼一个月
- java例程练习(计算子串个数)