windows服务器上安装Oracle,在windows服务器上又安装了一个虚拟机,虚拟机上安装PostgreSQL,通过ogg将oracle的数据同步到PostgreSQL。
源端配置:
1.mgr
PORT 7809
DYNAMICPORTLIST 7800-8000
AUTOSTART ER *
AUTORESTART EXTRACT *,WAITMINUTES 2, RESETMINUTES 5
PURGEOLDEXTRACTS D:\ogg\dirdat\*,USECHECKPOINTS,MINKEEPDAYS 3
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
SYSLOG ERROR,WARN
2.Extract进程
EXTRACT escott
userid C##GGADMIN, password ggadmin
LOGALLSUPCOLS
UPDATERECORDFORMAT COMPACT
EXTTRAIL D:\ogg\dirdat\lt
SOURCECATALOG orclpdb
TABLE ykgrid_compre.*;
3.Pump进程
EXTRACT PUSCOTT
SETENV (NLS_LANG=AMERICAN_AMERICA.UTF8)
PASSTHRU
RMTHOST 192.168.137.104, MGRPORT 7810
RMTTRAIL /data/ogg/dirdat/tr
TABLE ykgrid_compre.*;
4.生成define文件
defsfile D:\ogg\dirdef\defgen.def
USERID C##GGADMIN, PASSWORD ggadmin
TABLE ykgrid_compre.*;
目标端
1.mgr
PORT 7810
AUTOSTART ER *
AUTORESTART EXTRACT *,WAITMINUTES 2, RESETMINUTES 5
PURGEOLDEXTRACTS /data/ogg/dirdat/*,USECHECKPOINTS,MINKEEPDAYS 3
2.Replicat进程
REPLICAT RORA_1
SOURCEDEFS /data/ogg/dirdef/defgen.def
SETENV(PGCLIENTENCODING = "UTF8")
SETENV(ODBCINI="/data/ogg/odbc.ini")
SETENV(NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
TARGETDB gis_test,userid test1,password Shuzhi@123
DISCARDFILE /data/ogg/dirrpt/RORA_compre.rpt, append
MAP ykgrid_compre.*,TARGET public.*;
源端Pump进程无法启动,日志如下:
ERROR OGG-01224 Connect failed to 192.168.137.104:7819, error 10061:由于目标计算机积极拒绝,无法连接。 - retries exceeded
配置的是7810端口,但是不知道为什么连接时用的是7819端口