今天搭建ogg的时候遇到一个奇葩的问题,现将问题贴出来供大家一起思考
环境
linux5.5
oracle 11.2
问题资源库pump进程挂起
pump进程挂掉
GGSCI (node3) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EORA_1 00:00:00 00:00:06
EXTRACT ABENDED PORA_1 00:00:00 00:59:39
REPLICAT RUNNING RORA_1 00:00:00 00:00:08
资源库告警日志信息
2013-11-26 14:37:09 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Unable to lock file "./dirdat/pa000001" (error 11, Resource temporarily unavailable). Lock currently held by process id (PID) 5335.
2013-11-26 14:37:09 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Unable to open file "./dirdat/pa000001" (error 11, Resource temporarily unavailable).
2013-11-26 14:37:09 ERROR OGG-01031 Oracle GoldenGate Capture for Oracle, pora_1.prm: There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable to open file "./dirdat/pa000001" (error 11, Resource temporarily unavailable)).
pump进程report 报告
GGSCI (node3) 5> view report pora_1
2013-11-26 14:37:09 ERROR OGG-01031 There is a problem in network communication, a remote file problem, encr
yption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable
to open file "./dirdat/pa000001" (error 11, Resource temporarily unavailable)).
2013-11-26 14:37:09 ERROR OGG-01668 PROCESS ABENDING.
pump进程配置
GGSCI (node3) 1> edit params pora_1
-- Data Pump parameter file to read the local
-- trail of EMP_OGG and DEPT_OGG changes
EXTRACT PORA_1
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
PASSTHRU
RMTHOST 192.168.10.101, MGRPORT 7809
RMTTRAIL ./dirdat/pa
TABLE scott.*;
但是在目标库上无法生成pa文件
[oracle@node1 dirdat]$ ls
aa000000 aa000001 aa000002 aa000003 aa000004
在网上查到的资料说可能是因为 目标库上的collector 进程将dirdat文件锁住导致无法生成pa文件,
从而导致资源库 pump进程挂起 。各位大神如果遇到过 这个 问题帮忙看看哦。
测试
拷贝文件到node1
[oracle@node3 ~]$ scp aaaaaa node1:/home/oracle
oracle@node1's password:
aaaaaa 100% 0 0.0KB/s 00:00
但是node1上没有文件
[oracle@node1 ~]$ ls
ogg112101_fbo_ggs_Linux_x86_ora11g_32bit.zip oradiag_oracle veridata-cagent.zip
Oracle Goldengate 11g Install and Setup Guide.doc V18156-01-linux.zip veridata-server.zip
[oracle@node1 ~]$ ls
从新配置/etc/hosts 文件
[root@node3 ~]# vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.10.11 node3
192.168.10.101 node1
拷贝正常,但是问题没有解决