本次实验在vmware9.0环境下进行，安装的操作系统centos-6.4-x86_64,数据库版本是oracle10g10.2.0.1，源库和目标库都安装了数据库
1.实验环境配置
本次实验在vmware9.0环境下进行，安装的操作系统centos-6.4-x86_64,数据库版本是oracle10g10.2.0.1，源库和目标库都安装了数据库，源库oracle_sid=myorcl，目标库oracle_sid=orcl
oracle streams技术介绍&搭建
单实例到单实例oracle stream搭建
oracle 10gr2 streams删除所有配置
oracle 单表流复制 stream
oracle简单stream一个用户单向复制配置
2.在源库与目标库初始化参数设置
在源库操作如下：
sql> select instance_name,status from v$instance;
instance_name status
---------------- ------------
myorcl open
sql> alter system set aq_tm_processes=1 scope=spfile; --队列等待时间
sql> alter system set job_queue_processes=2 scope=spfile; --至少为2
sql> alter system set global_names=true scope=spfile; --用来控制database link同名
sql> alter database rename global_name to myorcl.net;
sql> alter system set streams_pool_size=50m scope=spfile;
重启数据库并查看设置的global_name，，如下：
sql> shutdown immediate
sql> startup
sql> select * from global_name;
global_name
--------------------------------------------------------------------------------
myorcl.net
在目标库操作，如下：
sql> select instance_name,status from v$instance;
instance_name status
---------------- ------------
orcl open
sql> alter system set aq_tm_processes=1 scope=spfile;
sql> alter system set job_queue_processes=2 scope=spfile;
sql> alter system set global_names=true scope=spfile;
sql> alter database rename global_name to orcl.net;
sql> alter system set streams_pool_size=50m scope=spfile;
sql> shutdown immediate
重启数据库并查看设置的global_name，如下：
sql> shutdown immediate
sql> startup
sql> select * from global_name;
global_name
--------------------------------------------------------------------------------
orcl.net
3.在源库和目标库配置tnsnames.ora，如下：
primary =
(description =
(address_list =
(address = (protocol = tcp)(host = 10.41.6.118)(port = 1521))
)
(connect_data =
(service_name = myorcl)
)
)
standby =
(description =
(address_list =
(address = (protocol = tcp)(host = 10.41.6.119)(port = 1521))
)
(connect_data =
(service_name = orcl)
)
)
测试能否连通，如下：
首先关闭防火墙，service iptables stop
在源库测试，如下：
[oracle@dayong ~]$ tnsping standby
tns ping utility for linux: version 10.2.0.1.0 - production on 03-apr-2014 11:47:41
copyright (c) 1997, 2005, oracle. all rights reserved.
used parameter files:
used tnsnames adapter to resolve the alias
attempting to contact (description = (address_list = (address = (protocol = tcp)(host = 10.41.6.119)(port = 1521))) (connect_data = (service_name = orcl)))
ok (10 msec)
在目标库测试，如下：
[oracle@xiaoru ~]$ tnsping primary
tns ping utility for linux: version 10.2.0.1.0 - production on 03-apr-2014 11:53:24
copyright (c) 1997, 2005, oracle. all rights reserved.
used parameter files:
used tnsnames adapter to resolve the alias
attempting to contact (description = (address_list = (address = (protocol = tcp)(host = 10.41.6.118)(port = 1521))) (connect_data = (service_name = myorcl)))
ok (0 msec)
4.源库和目标库复制管理员的创建
不能使用sys和system作为流管理员，流管理员不能使用system表空间作为默认表空间；
源库操作如下：
sql> create tablespace streamtbs datafile '/u01/app/oradata/myorcl/streamtbs.dbf' size 100m;
sql> create user streamadmin identified by oracle default tablespace streamtbs quota unlimited on streamtbs;
sql> grant connect,resource,dba to streamadmin;
目标库操作如下：
sql> create tablespace streamtbs datafile '/u01/app/oradata/orcl/streamtbs.dbf' size 100m;
sql> create user streamadmin identified by oracle default tablespace streamtbs quota unlimited on streamtbs;
sql> grant connect,resource,dba to streamadmin;
更多详情见请继续阅读下一页的精彩内容：