日期:2014-05-16  浏览次数:20522 次

流复制实验之:Streams_Single_to_single_schames

环境介绍:

这个例子是如何配置单实例到单实例的单向复制.

环境如下表:

 

Source (single instance)

Target (single instance)

IP

172.28.7.244

172.28.7.11

OS

Oracle 10.2.0.1 for AIX5.3

Oracle 10.2.0.1 for windows XP

DB_NAME

orcl

orcl

Host name

Inode2

Ch-f

global_name

orcl.test.lcz.com.cn

testdb.test.lcz.com.cn

service_names

orcl.test.lcz.com.cn

testdb.test.lcz.com.cn

 

配置步骤:

(1).配置tnsnames.ora

初始single\rac(orcl1,orcl2)两个数据库的tnsnames.ora内容相同。

 

orcl.test.lcz.com.cn =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.7.244)(PORT = 1522))

    (LOAD_BALANCE = yes)

    (CONNECT_DATA =

      (SERVER = DEDICATED)

       (sid = orcl)

    )

  )