2节点RAC
CRS-->Listener-->ASM实例
到这里时,ASM实例创建好了,crs_stat -t也可以看到这ASM实例:
[oracle@db1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE db1
ora....B1.lsnr application ONLINE ONLINE db1
ora.db1.gsd application ONLINE ONLINE db1
ora.db1.ons application ONLINE ONLINE db1
ora.db1.vip application ONLINE ONLINE db1
ora....SM2.asm application ONLINE ONLINE db2
ora....B2.lsnr application ONLINE ONLINE db2
ora.db2.gsd application ONLINE ONLINE db2
ora.db2.ons application ONLINE ONLINE db2
ora.db2.vip application ONLINE ONLINE db2
但是继续往后时,ASM磁盘组发现不了ASM磁盘.
接着看日志${ORACLE_HOME}/log/${Node_Name}/:
2010-01-14 01:39:40.138: [ RACG][3086912256] [30872][3086912256][ora.db2.ASM2.asm]:
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 14 01:39:34 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning,
2010-01-14 01:39:40.138: [ RACG][3086912256] [30872][3086912256][ora.db2.ASM2.asm]: Real Application Clusters, OLAP and Data Mini
ng options
SQL> ORA-15100: invalid or missing diskgroup name
ASM instance shutdown
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Ap
2010-01-14 01:39:40.138: [ RACG][3086912256] [30872][3086912256][ora.db2.ASM2.asm]: plication Clusters, OLAP and Data Mining opti
ons
这时我可以看到ASM磁盘的卷标的:
[oracle@db1 dbs]$ /etc/init.d/oracleasm listdisks
VOL1
然后我手工删除ASM实例和相关的文件:
[oracle@db1 ~]$srvctl remove asm -n db1
[oracle@db1 ~]$cd ${ORACLE_BASE}/admin
[oracle@db1 admin]$rm -rf +ASM
[oracle@db1 dbs]$cd ${ORACLE_HOME}/dbs
[oracle@db1 dbs]$ rm -rf init+ASM1.ora
[oracle@db1 dbs]$ rm -f ab_+ASM1.dat
[oracle@db1 dbs]$ rm -f hc_+ASM1.dat
[oracle@db1 dbs]$ rm -f orapw+ASM1
[oracle@db1 dbs]$vi /etc/oratab
将+ASM1:/oracle/product/10.2.0/db:N注释
另外一个节点也同上面的操作.
最后擦除这个ASM磁盘数据:
[oracle@db1 ~]#dd if=/dev/zero of=/dev/sdc1 bs=1024 count=3140676
重启,再创建ASM实例,还是同上面的在ASM磁盘组里发现不了ASM磁盘,而且说数据库实例已启动.怪了:我是先创建ASM实例,再创建数据库实例了,这时ASM实例创建的时候,数据库实例尚未创建那!
请问运行dbca进行ASM配置完,asm还有别的配置文件需要清除?
还有/etc/init.d/oracleasm createdisk VOL1 /dev/sdc1 后,会往/dev/sdc3里写数据吗?
asmdiskstring和asmdiskgroup都必须指定吗? 我上面用的卷标是VOL1,那么asmdiskstring写成'ORCL:VOL*'那,还是'VOL*' ?
期待赐教!