本帖最后由 莫不言 于 2013-10-30 14:33 编辑
[root@gdwzdb1 ~]# /etc/init.d/oracleasm listdisks
每次打开虚拟机都要在节点上执行 /etc/inint.d/oracleasm scandisks
[oracle@gdwzdb1 ~]$ crs_stat -t -v
Name Type R/RA F/FT TargetState Host
----------------------------------------------------------------------
ora.gdwzdb.dbapplication0/10/1ONLINEOFFLINE
ora....b1.inst application0/50/0ONLINEOFFLINE
ora....b2.inst application0/50/0ONLINEOFFLINE
ora....SM1.asm application0/50/0ONLINEONLINEgdwzdb1
ora....B1.lsnr application0/50/0ONLINEONLINEgdwzdb1
ora....db1.gsd application0/50/0ONLINEONLINEgdwzdb1
ora....db1.ons application0/30/0ONLINEONLINEgdwzdb1
ora....db1.vip application0/00/0ONLINEONLINEgdwzdb1
ora....SM2.asm application0/50/0ONLINEONLINEgdwzdb2
ora....B2.lsnr application0/50/0ONLINEONLINEgdwzdb2
ora....db2.gsd application0/50/0ONLINEONLINEgdwzdb2
ora....db2.ons application0/30/0ONLINEONLINEgdwzdb2
ora....db2.vip application0/00/0ONLINEONLINEgdwzdb2
[oracle@gdwzdb1 ~]$ export ORACLE_SID=+ASM1
[oracle@gdwzdb1 ~]$ sqlplus / assysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 28 09:51:40 2013
Copyright (c) 1982, 2005, Oracle.All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL>
SQL> select name,state from v$asm_diskgroup;
no rows selected
[root@gdwzdb1 ~]# /etc/init.d/oracleasm listdisks
[root@gdwzdb1 ~]# ll /dev/oracleasm/disks
total 0
[root@gdwzdb1 ~]# tail -f /opt/oracle/admin/+ASM/bdump/alert_+ASM1.log
Wed Oct 30 12:18:19 CST 2013
NOTE: cache registered group DG number=1 incarn=0xabd87ed0
Wed Oct 30 12:18:19 CST 2013
Loaded ASM Library - Generic Linux, version 2.0.4 (KABI_V2) library for asmlib interface
Wed Oct 30 12:18:19 CST 2013
ERROR: no PST quorum in group 1: required 2, found 0
Wed Oct 30 12:18:19 CST 2013
NOTE: cache dismounting group 1/0xABD87ED0 (DG)
NOTE: dbwr not being msg'd to dismount
ERROR: diskgroup DG was not mounted
[root@gdwzdb1 ~]# /etc/init.d/oracleasm scandisks
Scanning the system for Oracle ASMLib disks:
[OK]
[root@gdwzdb1 ~]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
[oracle@gdwzdb1 ~]$ ll /dev/oracleasm/disks
total 0
brw-rw---- 1 oracle oinstall 8, 35 Oct 30 13:59 VOL1
brw-rw---- 1 oracle oinstall 8, 36 Oct 30 13:59 VOL2
[root@gdwzdb1 ~]# ll /dev/oracleasm/disks（scandisks之后才能看到这里磁盘）
total 0
brw-rw---- 1 oracle oinstall 8, 35 Oct 30 14:22 VOL1
brw-rw---- 1 oracle oinstall 8, 36 Oct 30 14:22 VOL2
crw-rw---- 1 root oinstall 162, 1 Oct 30 12:17 raw1
crw-rw---- 1 oracle oinstall 162, 2 Oct 30 14:12 raw2
crw-rw---- 1 oracle oinstall 162, 3 Oct 30 12:17 raw3
crw-rw---- 1 oracle oinstall 162, 4 Oct 30 12:17 raw4
SQL> select name,state from v$asm_diskgroup;
NAME
STATE
------------------------------ -----------
DG
DISMOUNTED
SQL> alter diskgroup dg mount;
Diskgroup altered.
SQL> show parameter asm
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups
stringDG
asm_diskstring
stringORCL:VOL*
asm_power_limit
integer 1
[root@gdwzdb1 ~]# tail -f -n 50 /opt/oracle/admin/+ASM/bdump/alert_+ASM1.log
PMON started with pid=2, OS id=6355
DIAG started with pid=3, OS id=6357
PSP0 started with pid=4, OS id=6359
LMON started with pid=5, OS id=6361
LMD0 started with pid=6, OS id=6363
LMS0 started with pid=7, OS id=6365
MMAN started with pid=8, OS id=6369
DBW0 started with pid=9, OS id=6371
LGWR started with pid=10, OS id=6373
CKPT started with pid=11, OS id=6375
SMON started with pid=12, OS id=6377
RBAL started with pid=13, OS id=6379
GMON started with pid=14, OS id=6381
Wed Oct 30 14:20:06 CST 2013
lmon registered with NM - instance id 1 (internal mem no 0)
Wed Oct 30 14:20:07 CST 2013
Reconfiguration started (old inc 0, new inc 2)
ASM instance
List of nodes:
0 1
Global Resource Directory frozen
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Wed Oct 30 14:20:07 CST 2013
LMS 0: 0 GCS shadows cancelled, 0 closed
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Post SMON to start 1st pass IR
Wed Oct 30 14:20:07 CST 2013
LMS 0: 0 GCS shadows traversed, 0 replayed
Wed Oct 30 14:20:07 CST 2013
Submitted all GCS remote-cache requests
Fix write in gcs resources
Reconfiguration complete
LCK0 started with pid=15, OS id=6388
Wed Oct 30 14:20:08 CST 2013
SQL> ALTER DISKGROUP ALL MOUNT
Wed Oct 30 14:20:08 CST 2013
NOTE: cache registered group DG number=1 incarn=0x273881ab
Wed Oct 30 14:20:08 CST 2013
Loaded ASM Library - Generic Linux, version 2.0.4 (KABI_V2) library for asmlib interface
Wed Oct 30 14:20:08 CST 2013
ERROR: no PST quorum in group 1: required 2, found 0
Wed Oct 30 14:20:08 CST 2013
NOTE: cache dismounting group 1/0x273881AB (DG)
NOTE: dbwr not being msg'd to dismount
ERROR: diskgroup DG was not mounted
每次都要手动执行，/etc/init.d/oracleasm scandisks 才能找到磁盘，已经够累了。oracle你能自动点吗？不要老是整无数的BUG出来。
请问如何解决不能自动挂载磁盘问题呢？
操作系统redhat 5.5
asmlib包：
oracleasm-2.6.18-194.el5-2.0.5-1.el5.x86_64.rpm
oracleasmlib-2.0.4-1.el5.x86_64.rpm
oracleasm-support-2.1.8-1.el5.x86_64.rpm
只安装了三个rpm包，不知道是不是少安装了asmlib包。
|
