oracle10g startup时 ASM 报错

北柏

问题描述如下：
os：rhel5.8 64bit
oracle version ：oracle10g

报错：
[oracle10g@test ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Mar 17 20:00:33 2013
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+ASMDG/prod/spfileprod.ora'
ORA-17503: ksfdopn:2 Failed to open file +ASMDG/prod/spfileprod.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL>

javascript:;javascript:;
javascript:;
os检查：
[root@test raw]# ll
total 0
crw-rw---- 1 oracle oinstall 162, 1 Mar 17 20:06 raw1
crw-rw---- 1 oracle oinstall 162, 2 Mar 17 20:06 raw2
crw-rw---- 1 oracle oinstall 162, 3 Mar 17 20:06 raw3
crw-rw---- 1 oracle oinstall 162, 4 Mar 17 20:06 raw4

以下为asm alertlog：




###################################################################################
-rw-r----- 1 oracle10g oinstall 32692 Mar 14 00:00 alert_prod.log  oracle的alter 为14号的
     


SQL> startup nomount
ASM instance started

Total System Global Area  130023424 bytes
Fixed Size                  2019032 bytes
Variable Size             102838568 bytes
ASM Cache                  25165824 bytes
SQL> alter diskgroup all mount;
alter diskgroup all mount
*
ERROR at line 1:
ORA-15110: no diskgroups mounted


SQL> alter diskgroup asmdg mount;
alter diskgroup asmdg mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "ASMDG"

刚学习asm，问题可能有点二，大家不要见笑，自己研究了好久，也没有解决，放到论坛上，ML和大家给看看，指点下！ alertASM.txt (17.96 KB, 下载次数: 882)

2013-3-21 22:38 上传

点击文件名下载附件

alertprod.txt (34.43 KB, 下载次数: 592)

2013-3-21 22:38 上传

点击文件名下载附件

北柏

再次上传

北柏

好的，谢谢ml指点。

Maclean Liu(刘相兵

which kfed

你需要先make kfed ， 否则输出信息无意义

北柏

ml，上传了

Maclean Liu(刘相兵

ORA-15063: ASM discovered an insufficient number of disks for diskgroup "ASMDG"

找不到足够的asm disk数目

SQL> CREATE DISKGROUP asmdg External REDUNDANCY  DISK '/dev/raw/raw1' SIZE 500M ,
'/dev/raw/raw2' SIZE 500M ,
'/dev/raw/raw3' SIZE 500M ,
'/dev/raw/raw4' SIZE 500M   
Wed Mar 13 23:19:31 2013
NOTE: initializing header on grp 1 disk ASMDG_0000
NOTE: initializing header on grp 1 disk ASMDG_0001
NOTE: initializing header on grp 1 disk ASMDG_0002
NOTE: initializing header on grp 1 disk ASMDG_0003

NOTE: cache registered group ASMDG number=1 incarn=0x6cd96302
Sun Mar 17 20:19:40 2013
ERROR: no PST quorum in group 1: required 2, found 0
Sun Mar 17 20:19:40 2013
NOTE: cache dismounting group 1/0x6CD96302 (ASMDG)


应当有4个ASM DISK

action plan:

1. #! /bin/sh
   
2. rm /tmp/kfed_DH.out /tmp/kfed_FS.out /tmp/kfed_BK.out /tmp/kfed_FD.out /tmp/kfed_DD.out /tmp/kfed_PST.out
   
3. for i in `ls /dev/raw/raw*`
   
4. do
   
5. echo $i >> /tmp/kfed_DH.out
   
6. kfed read $i >> /tmp/kfed_DH.out
   
7. echo $i >> /tmp/kfed_FS.out
   
8. kfed read $i blkn=1 >> /tmp/kfed_FS.out
   
9. echo $i >> /tmp/kfed_BK.out
   
10. kfed read $i aun=1 blkn=254 >> /tmp/kfed_BK.out
    
11. echo $i >> /tmp/kfed_FD.out
    
12. kfed read $i aun=2 blkn=1 >> /tmp/kfed_FD.out
    
13. echo $i >> /tmp/kfed_DD.out
    
14. kfed read $i aun=2 blkn=2 >> /tmp/kfed_DD.out
    
15. echo $i >> /tmp/kfed_PST.out
    
16. kfed read $i aun=1 blkn=2 >> /tmp/kfed_PST.out
    
17. done

复制代码

运行以上脚本 并将 /tmp 下 kfed开头的输出文件打包上传

北柏

自己沙发！