oracle集群安装ogg,RAC环境下配置OGG同步

在本文中，介绍了rac环境下配置ogg的单向同步；在配置过程中，2节点的rac数据库做为source端，单实例的数据库作为target端，下面是具体的环境介绍!

source端：

操作系统版本：rhel5.4 64bit

数据库版本：11.2.0.3 64bit

ogg版本：fbo_ggs_Linux_x64_ora10g_64bit.tar

rac数据库名：rac.yang.com

public ip:192.168.1.41/24,192.168.1.42/24

private ip:192.168.122.41/24,192.168.122.42/24

vip:192.168.1.141/24,192.168.1.142/24

scan名：rac-scan.yang.com

scan-ip:192.168.1.144/24,192.168.1.145/24,192.168.1.146/24

target端：

操作系统版本：rhel5.4 64bit

数据库版本：11.2.0.3 64bit

ogg版本：fbo_ggs_Linux_x64_ora10g_64bit.tar

数据库名：dg3.yang.com

ip:192.168.1.63/24

一：首先在两个rac节点上配置ASM动态注册,11g的监听器引入了endpoints_listener.ora文件管理

[grid@rac1 rac1]$ srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node(s): rac2,rac1

[grid@rac1 rac1]$ lsnrctl services

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 11-JUL-2012 21:09:20

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

Services Summary...

Service "+ASM" has 1 instance(s).

Instance "+ASM1", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0 state:ready

LOCAL SERVER

Service "rac.yang.com" has 1 instance(s).

Instance "rac1", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0 state:ready

LOCAL SERVER

Service "racXDB.yang.com" has 1 instance(s).

Instance "rac1", status READY, has 1 handler(s) for this service...

Handler(s):

"D000" established:0 refused:0 current:0 max:1022 state:ready

DISPATCHER

(ADDRESS=(PROTOCOL=tcp)(HOST=rac1.yang.com)(PORT=63054))

The command completed successfully

[grid@rac1 rac1]$ cat $TNS_ADMIN/listener.ora

LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))            # line added by Agent

LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3))))  # line added by Agent

LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2))))  # line added by Agent

LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))  # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON# line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON# line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON# line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON# line added by Agent

[grid@rac