RAC 中 ASM 实例名 与 节点的对应关系
这个名称看上去就不一致，不是很直观。
Name Target State Host
------------------------------ ---------- --------- -------
ora.rac.db ONLINE ONLINE rac1
ora.rac.rac1.inst ONLINE ONLINE rac2
ora.rac.rac2.inst ONLINE ONLINE rac1
--两个实例也是反的
ora.rac.taf.cs ONLINE ONLINE rac2
ora.rac.taf.rac1.srv ONLINE ONLINE rac2
ora.rac.taf.rac2.srv ONLINE ONLINE rac1
ora.rac1.ASM2.asm ONLINE ONLINE rac1
ora.rac1.LISTENER_RAC1.lsnr ONLINE ONLINE rac1
ora.rac1.gsd ONLINE ONLINE rac1
ora.rac1.ons ONLINE ONLINE rac1
ora.rac1.vip ONLINE ONLINE rac1
ora.rac2.ASM1.asm ONLINE ONLINE rac2
ora.rac2.LISTENER_RAC2.lsnr ONLINE ONLINE rac2
ora.rac2.gsd ONLINE ONLINE rac2
ora.rac2.ons ONLINE ONLINE rac2
ora.rac2.vip ONLINE ONLINE rac2
在这篇文章里，就是测试RAC下，ASM实例名的修改。 将2个节点的实例做下倒换。 也可以换成其他名字。 RAC 实例名的修改，放到下一篇。
一. ASM 实例基本信
1.1 节点1信息
[oracle@rac1 u01]$ export ORACLE_SID=+ASM2
[oracle@rac1 u01]$ sqlplus / as sysdba;
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 24 20:49:07 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> select instance_name,status,active_state from v$instance;
INSTANCE_NAME STATUS ACTIVE_ST
---------------- ------------ ---------
+ASM2 STARTED NORMAL
SQL> show parameter instance
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 2
instance_groups string
instance_name string +ASM2
instance_number integer 2
instance_type string asm
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 2
SQL>
1.2 节点2信息
[oracle@rac2 ~]$ export ORACLE_SID=+ASM1
[oracle@rac2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 24 20:53:02 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> select instance_name,status,active_state from v$instance;
INSTANCE_NAME STATUS ACTIVE_ST
---------------- ------------ ---------
+ASM1 STARTED NORMAL
SQL> show parameter instance
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_datab