dirprm/repfull.prm does not exist for REPFULL

启动replicat进程时报错找不到参数文件,但是该地址有此文件,且权限没有问题
GGSCI (11g) 4> start repfull, aftercsn 2161190

Sending START request to MANAGER ...

ERROR: Parameter file /ogg/dirprm/repfull.prm does not exist for REPFULL.

2017-09-26 05:56:46  WARNING OGG-01742  Command sent to MGR MGR returned with an ERROR response.
在另一窗口手动启动replicat进程,观察详细日志没有报错
[oracle@11g ogg]$ replicat paramfile /ogg/dirprm/repfull.prm

***********************************************************************
                 Oracle GoldenGate Delivery for Oracle
    Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
   Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:48:07
 
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.


                    Starting at 2017-09-26 06:04:47
***********************************************************************

Operating System Version:
Linux
Version #1 SMP Sun Nov 10 22:19:54 EST 2013, Release 2.6.32-431.el6.x86_64
Node: 11g
Machine: x86_64
                         soft limit   hard limit
Address Space Size   :    unlimited    unlimited
Heap Size            :    unlimited    unlimited
File Size            :    unlimited    unlimited
CPU Time             :    unlimited    unlimited

Process id: 2042

Description: 

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************

2017-09-26 06:04:47  INFO    OGG-03035  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
REPLICAT repfull
setenv ( NLS_LANG =  "AMERICAN_AMERICA.ZHS16GBK" )
Set environment variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
ASSUMETARGETDEFS
USERID goldengate, PASSWORD **********
DBOPTIONS DEFERREFCONST, SUPPRESSTRIGGERS
GETTRUNCATES
ALLOWNOOPUPDATES
DISCARDFILE ./dirrpt/repfull.dsc, purge, megabytes 5000
MAP test.*, TARGET testt.*;

2017-09-26 06:04:47  INFO    OGG-01815  Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /ogg/dirtmp.

CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE:                                2G
CACHEPAGEOUTSIZE (normal):                8M
PROCESS VM AVAIL FROM OS (min):           4G
CACHESIZEMAX (strict force to disk):   3.41G

Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE    11.2.0.4.0      Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

Database Language and Character Set:
NLS_LANG         = "AMERICAN_AMERICA.ZHS16GBK" 
NLS_LANGUAGE     = "AMERICAN" 
NLS_TERRITORY    = "AMERICA" 
NLS_CHARACTERSET = "ZHS16GBK" 

***********************************************************************
**                     Run Time Messages                             **
***********************************************************************

Opened trail file /ogg/dirdat/td000001 at 2017-09-26 06:04:47

此时实验同步也没有问题
Wildcard MAP resolved (entry test.*):
  MAP "TEST"."WORKER", TARGET testt."WORKER";
Using following columns in default map by name:
  WNO, WNAME
Using the following key columns for target table TESTT.WORKER: WNO.

SQL> select * from testt.worker;

WNO       WNAME
--------- --------------------
003       sachiel
002       eva

SQL> /

WNO       WNAME
--------- --------------------
003       sachiel
002       eva
001       adam
此时关闭replicat进程,关不掉
GGSCI (11g) 3> stop repfull

Sending STOP request to REPLICAT REPFULL ...
Request processed.


GGSCI (11g) 4> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    RUNNING     REPFULL     00:00:00      00:00:08    


GGSCI (11g) 5> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    RUNNING     REPFULL     00:00:00      00:00:09    


GGSCI (11g) 6> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    RUNNING     REPFULL     00:00:00      00:00:01    
再次发起关闭命令,报端口错误
GGSCI (11g) 14> stop repfull

Sending STOP request to REPLICAT REPFULL ...

ERROR: opening port for REPLICAT REPFULL (Connection refused).
report文件也不存在
GGSCI (11g) 16> view report repfull
ERROR: REPORT file REPFULL does not exist.
猜测是否网络出现问题
[oracle@11g ogg]$ cat /etc/host
cat: /etc/host: No such file or directory
[oracle@11g ogg]$ cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.56.101 11g
[oracle@11g ogg]$ ifconfig
eth0      Link encap:Ethernet  HWaddr 08:00:27:E1:A2:0D  
          inet addr:192.168.56.111  Bcast:192.168.56.255  Mask:255.255.255.0
          inet6 addr: fe80::a00:27ff:fee1:a20d/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:4927 errors:0 dropped:0 overruns:0 frame:0
          TX packets:3943 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:501117 (489.3 KiB)  TX bytes:484237 (472.8 KiB)
hostname和ip地址不对应,ogg分配端口的时候需要使用地址解析,我在做实验的时候因为两台虚拟机的ip地址冲突,就将其中一个的ip改了方便使用ssh连接,没有修改/etc/hosts
将/etc/hosts改过来后一切恢复正常
GGSCI (11g) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    ABENDED     REPFULL     00:00:00      00:05:38    


GGSCI (11g) 2> start repfull

Sending START request to MANAGER ...
REPLICAT REPFULL starting


GGSCI (11g) 3> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    RUNNING     REPFULL     00:00:00      00:00:01    

  • 2
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值