北柏

60 积分	1 好友	6 主题

发消息

[SQL调优] oracle10g startup时 ASM 报错

1^#

发表于 2013-3-21 22:37:26 | 查看: 4510| 回复: 6

本帖最后由北柏于 2013-3-21 22:39 编辑

问题描述如下：
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, 下载次数: 937)

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

分享0

收藏0 回复只看该作者道具举报

北柏

2^#

发表于 2013-3-21 22:40:27

自己沙发！

回复只看该作者道具举报

Maclean Liu(刘相兵

3^#

发表于 2013-3-21 22:48:39

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:

#! /bin/sh
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
for i in `ls /dev/raw/raw*`
do
echo $i >> /tmp/kfed_DH.out
kfed read $i >> /tmp/kfed_DH.out
echo $i >> /tmp/kfed_FS.out
kfed read $i blkn=1 >> /tmp/kfed_FS.out
echo $i >> /tmp/kfed_BK.out
kfed read $i aun=1 blkn=254 >> /tmp/kfed_BK.out
echo $i >> /tmp/kfed_FD.out
kfed read $i aun=2 blkn=1 >> /tmp/kfed_FD.out
echo $i >> /tmp/kfed_DD.out
kfed read $i aun=2 blkn=2 >> /tmp/kfed_DD.out
echo $i >> /tmp/kfed_PST.out
kfed read $i aun=1 blkn=2 >> /tmp/kfed_PST.out
done