通过Oracle客户端远程访问ASM实例


在配置Goldengate的时候，我们需要连接ASM实例，配置方法如下：
Oracle 10g RAC的方法：
在本地RAC两个节点上listener.ora文件中添加：
RAC1节点：
(SID_DESC =
     (GLOBAL_NAME = ASM)
     (ORACLE_HOME = /oracle/app/product/10.2.0/db_1)
     (SID_NAME = +ASM1)
    )
)
RAC2节点：
(SID_DESC =
     (GLOBAL_NAME = ASM)
     (ORACLE_HOME = /oracle/app/product/10.2.0/db_1)
     (SID_NAME = +ASM2)
    )
)
在本地RAC两个节点和远程客户端的tnsnames.ora文件中添加：
ASM2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.12)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ASM)
      (INSTANCE_NAME = +ASM2)
      (UR = A)
    )
  )
ASM1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.11)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ASM)
      (INSTANCE_NAME = +ASM1)
      (UR = A)
    )
  )

然后重启监听，远程测试连接：

[oracle@target ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Oct 19 05:17:20 2011
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> connsys/sys@asm1  as sysdba;
Connected.