一、试验环境:
A机:IP:192.168.121.200 OS:Linux es4; DB:Oracle 9.2.0.8;
B机:IP:192.168.121.100 OS:Linux es4; DB:Oracle 9.2.0.8;
二、试验步骤:
1. 初始化参数检查
A机:db_domain=dbname.dbcard
global_names=true
job_queue_processes=10 # 缺省值
open_links=4 # 缺省值
系统参数: /etc/hosts /etc/sysconfig/network
B机:db_domain=dbrep.dbcard
global_names=true
job_queue_processes=10 # 缺省值
open_links=4 # 缺省值
系统参数: /etc/hosts /etc/sysconfig/network
2. 配置数据库连接
两个数据库之间可以互相访问,在tnsnames.ora里设置数据库连接字符串。
[oracle@dbrep admin]$ more tnsnames.ora
# Generated by Oracle configuration tools.
dbrep = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.121.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dbrep.dbcard)
)
)
dbname = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.121.200)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dbname.dbcard)
)
)
3. 用 system 用户连接数据库,改数据库全局名称,建公共的数据库链接。
A机:alter database rename global_name to dbname.dbcard;
B机:alter database rename global_name to dbrep.dbcard
注意:conn systemppwd@testdb.main.dbcard as sysdba 测试
Conn systemppwd@testdb.backup.dbcard as sysdba 测试
如果 不通,检查hosts配置, 必要时重启
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/262478/viewspace-600558/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/262478/viewspace-600558/