您好,欢迎访问一九零五行业门户网

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

在配置goldengate的时候,我们需要连接asm实例,配置方法如下:oracle 10g rac的方法:在本地rac两个节点上listener.ora文件中添
在配置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.
更多oracle相关信息见oracle 专题页面 ?tid=12
其它类似信息

推荐信息