ITPub博客

首页 > 数据库 > Oracle > ogg一个奇葩的问题 OGG-01031

ogg一个奇葩的问题 OGG-01031

原创 Oracle 作者:fei890910 时间:2013-11-26 19:32:51 0 删除 编辑
今天搭建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
拷贝正常,但是问题没有解决                                              





来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29108064/viewspace-1061175/,如需转载,请注明出处,否则将追究法律责任。

上一篇: ogg启动步骤
请登录后发表评论 登录
全部评论

注册时间:2013-08-15

  • 博文量
    120
  • 访问量
    747447