来自：http://blog.sina.com.cn/s/blog_5025f6e201008kku.html
Oracle9i与Oracle10g之间的高级复制配置
今天有朋友问及，Oracle9i和Oracle10g之间能够构建高级复制环境。
基于实现原理，我们知道一定是可以的，但是还是动手测试了一下。
测试了简单的表复制，结论是没有问题。
高级复制的详细过程
http://www.eygle.com/archives/2005/06/oraclessoeaeaeo.html
测试的简单过程如下(略去了一些基本步骤).
首先测试两个数据库的连通性
$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Oct 31 10:36:31 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> show parameter glob
NAME TYPE VALUE
------------------------------------ ----------- ---------------------
global_context_pool_size string
global_names boolean TRUE
SQL> select * from global_name;
GLOBAL_NAME
----------------------------------------------------------------------
HSBILL.HURRAY.COM.CN
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
bash-2.03$ tnsping mars
TNS Ping Utility for Solaris: Version 9.2.0.4.0 - Production on 31-OCT-2006 10:39:41
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/opt/oracle/product/9.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.31.110)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = mars)))
OK (10 msec)
两个数据库分别创建db link:
9i的数据库:
bash-2.03$ sqlplus repadmin/repadmin
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Oct 31 10:57:49 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> create public database link "MARS.HURRAY.COM.CN" connect to repadmin identified by repadmin using 'MARS';
Database link created.
SQL> select * from dual@mars;
D
-
X
10g的数据库:
bash-2.03$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 31 10:15:20 2006Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> select username from dba_users where username='REPADMIN';
两个数据库分别创建测试表：
进行复制创建:
基本测试:
本例未作全面测试，仅用于说明Oracle9iR2和Oracle10gR2之间的高级复制功能上可行。