Oracle9i和Oracle10g之间构建高级复制环境的测试用例

当前位置：首页 - 数据库 - 正文

君子好学，自强不息！

2022-11-25 | 数据库 | 1818ip | 576°c

A⁺ A^-

Oracle9i和Oracle10g之间有许多的共性，后者向前者兼容。因此这里我们主要介绍Oracle9i和Oracle10g之间能够构建高级复制环境，手动测试的例子。

首先测试两个数据库的连通性:

$ sqlplus “/ as sysdba”

SQL*Plus: Release 9.2.0.4.0 – Production on Tue Oct 31 10:36:31 2006

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

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

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 2006

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’;

USERNAME#p#

REPADMIN

SQL> connect repadmin/repadmin Connected. SQL> select * from tab;

no rows selected

SQL> select * from global_name;

GLOBAL_NAME ——————————————————————————– MARS.HURRAY.COM.CN

SQL> create public database link “HSBILL.HURRAY.COM.CN” connect to repadmin identified by repadmin using ‘HSBILL’;

Database link created.

SQL> select * from dual@hsbill;

D – X

两个数据库分别创建测试表：

SQL> connect eygle/eygle Connected.

SQL> create table eygle as select * from v$session;

Table created.

SQL> alter table eygle add (constraint pk_eygle primary key (SADDR));

Table altered.

进行复制创建:

SQL> connect repadmin/repadmin Connected.

SQL> execute dbms_repcat.create_master_repgroup(‘rep_910’);