rac中另外一节点的asm实例启动

这几天在实验室里做rac+asm+Linux，在配置asm时，节点2的分区不能被mount，看来只有手动来mount了：

[oracle@server2 ~]$ ps -ef | grep asm
oracle    6339     1  0 10:06 ?        00:00:00 asm_pmon_+ASM2
oracle    6341     1  0 10:06 ?        00:00:00 asm_diag_+ASM2
oracle    6343     1  0 10:06 ?        00:00:00 asm_psp0_+ASM2
oracle    6345     1  0 10:06 ?        00:00:01 asm_lmon_+ASM2
oracle    6347     1  0 10:06 ?        00:00:00 asm_lmd0_+ASM2
oracle    6349     1  0 10:06 ?        00:00:00 asm_lms0_+ASM2
oracle    6359     1  0 10:06 ?        00:00:00 asm_mman_+ASM2
oracle    6361     1  0 10:06 ?        00:00:00 asm_dbw0_+ASM2
oracle    6363     1  0 10:06 ?        00:00:00 asm_lgwr_+ASM2
oracle    6365     1  0 10:06 ?        00:00:00 asm_ckpt_+ASM2
oracle    6367     1  0 10:06 ?        00:00:00 asm_smon_+ASM2
oracle    6369     1  0 10:06 ?        00:00:00 asm_rbal_+ASM2
oracle    6371     1  0 10:06 ?        00:00:00 asm_gmon_+ASM2
oracle    6399     1  0 10:06 ?        00:00:00 asm_lck0_+ASM2
oracle    6442     1  0 10:06 ?        00:00:00 /app/oracle/10g/bin/racgimon daemon ora.server2.ASM2.asm
oracle    7097     1  0 12:36 ?        00:00:00 asm_pz99_+ASM2
oracle    7144     1  0 12:36 ?        00:00:00 asm_pz98_+ASM2
oracle   13954  8392  0 12:40 pts/2    00:00:00 grep asm
[oracle@server2 ~]$ export ORACLE_SID=+ASM2
[oracle@server2 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 8 12:41:18 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> shutdown immediate
ORA-15100: invalid or missing diskgroup name

ASM instance shutdown
SQL> startup
ASM instance started

Total System Global Area   92274688 bytes
Fixed Size                  1217884 bytes
Variable Size              65890980 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
SQL> select count(*) from v$asm_disks;
select count(*) from v$asm_disks
                     *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only

SQL> select count(*) from v$asm_group;
select count(*) from v$asm_group
                     *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only

SQL> select count(*) from v$asm_diskgroup;

  COUNT(*)
----------
         1

这样就ok了，这个问题解决；

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11782778/viewspace-606176/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11782778/viewspace-606176/