dba_sky 发表于 2014-7-28 17:14:30

CACHESIZE PER DYNAMIC DETERMINATION (32G) LESS THAN RECOMMENDED: 64G (64bit s...

goldengate版本：11.2.0.1
数据库版本：10.2.0.5
操作系统：HPUX 11.31 IA

建了一个extract nm_ext，启动时从ggserr.log中获得了如下错误

2014-07-28 12:57:36  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, nm_ext.prm:  EXTRACT NM_EXT starting.
2014-07-28 12:57:36  INFO    OGG-03035  Oracle GoldenGate Capture for Oracle, nm_ext.prm:  Operating system character set identified as hp-roman8. Locale: en_US_POSIX, LC_ALL:.
2014-07-28 12:57:37  WARNING OGG-00254  Oracle GoldenGate Capture for Oracle, nm_ext.prm:  CONVERTUCS2CLOBS is a deprecated parameter.
2014-07-28 12:57:37  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, nm_ext.prm:  Virtual Memory Facilities for: BR
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /oracle/ogg/BR/NM_EXT.
2014-07-28 12:57:37  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, nm_ext.prm:  Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /oracle/ogg/dirtmp.
2014-07-28 12:57:37  WARNING OGG-01842  Oracle GoldenGate Capture for Oracle, nm_ext.prm:  CACHESIZE PER DYNAMIC DETERMINATION (32G) LESS THAN RECOMMENDED: 64G (64bit system)
vm found: 52.60G
Check swap space. Recommended swap/extract: 128G (64bit system).


在配置文件中添加 CACHEMGR CACHESIZE  8G ,启动后直接报
Source Context :
  SourceModule            :
  SourceID                :
  SourceFunction          :
  SourceLine              :

2014-07-28 16:20:06  ERROR   OGG-01117  Received signal: Bus error (10).

2014-07-28 16:20:06  ERROR   OGG-01668  PROCESS ABENDING.
Bus error(coredump)


由于刚接触goldengate时间不长，还请大师们多多指教

Maclean Liu(刘相兵 发表于 2014-7-28 17:18:58

给一下内存信息？HPUX ？prtconf ?

dba_sky 发表于 2014-7-28 17:21:07

ziyuanA[#/]uname -a
HP-UX ziyuanA B.11.31 U ia64 1000651334 unlimited-user license

ziyuanA[#/]machinfo
CPU info:
12 Intel(R) Itanium 2 9100 series processors (1.6 GHz, 18 MB)
          533 MT/s bus, CPU version A1
          24 logical processors (2 per socket)

Memory: 65338 MB (63.81 GB)

Firmware info:
   Firmware revision:  9.048
   FP SWA driver revision: 1.18
   IPMI is supported on this system.
   BMC firmware revision: 4.01

Platform info:
   Model:                  "ia64 hp server rx8640"
   Machine ID number:      3ba4ba46-70a0-11df-a002-a7d29bf842ed
   Machine serial number:  SGH5017A8W

OS info:
   Nodename:  ziyuanA
   Release:   HP-UX B.11.31
   Version:   U (unlimited-user license)
   Machine:   ia64
   ID Number: 1000651334
   vmunix _release_version:               
@(#) $Revision: vmunix:    B.11.31_LR FLAVOR=perf
ziyuanA[#/]swapinfo
             Kb      Kb      Kb   PCT  START/      Kb
TYPE      AVAIL    USED    FREE  USED   LIMIT RESERVE  PRI  NAME
dev     8388608       0 8388608    0%       0       -    1  /dev/vg00/lvol2
dev     65536000       0 65536000    0%       0       -    1  /dev/vg00/pswap
reserve       - 57101048 -57101048
memory  63639852 25525584 38114268   40%
ziyuanA[#/]swapinfo -atm
             Mb      Mb      Mb   PCT  START/      Mb
TYPE      AVAIL    USED    FREE  USED   LIMIT RESERVE  PRI  NAME
dev        8192       0    8192    0%       0       -    1  /dev/vg00/lvol2
dev       64000       0   64000    0%       0       -    1  /dev/vg00/pswap
reserve       -   55764  -55764
memory    62148   24927   37221   40%
total    134340   80691   53649   60%       -       0    -
ziyuanA[#/]

dba_sky 发表于 2014-7-28 22:05:12

GGSCI (ziyuanA) 2> info nm_ext,showch

EXTRACT    NM_EXT    Last Started 2014-07-28 12:41   Status ABENDED
Checkpoint Lag       00:00:00 (updated 09:09:23 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2014-07-28 12:53:34  Seqno 35557, RBA 399495168
                     SCN 3193.4108400563 (13717938976691)


Current Checkpoint Detail:

Read Checkpoint #1

  Oracle Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 1
    Sequence #: 35557
    RBA: 379669520
    Timestamp: 2014-07-28 12:29:23.000000
    SCN: 3193.4106339086 (13717936915214)
    Redo File: /oracle/oralogA/redo07a.log

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 1
    Sequence #: 35557
    RBA: 399493136
    Timestamp: 2014-07-28 12:53:34.000000
    SCN: 3193.4108400561 (13717938976689)
    Redo File: /oracle/oralogA/redo07a.log

  Current Checkpoint (position of last record read in the data source):
    Thread #: 1
    Sequence #: 35557
    RBA: 399495168
    Timestamp: 2014-07-28 12:53:34.000000
    SCN: 3193.4108400563 (13717938976691)
    Redo File: /oracle/oralogA/redo07a.log

Write Checkpoint #1

  GGS Log Trail

  Current Checkpoint (current write position):
    Sequence #: 4
    RBA: 149651
    Timestamp: 2014-07-28 12:53:37.750481
    Extract Trail: /oracle/ogg/dirdat/nm

CSN state information:
  CRC: A-C6-A8-53

Source Context :
  SourceModule            :
  SourceID                :
  SourceFunction          :
  SourceLine              :

2014-07-28 22:03:00  ERROR   OGG-01117  Received signal: Bus error (10).

2014-07-28 22:03:00  ERROR   OGG-01668  PROCESS ABENDING.
Bus error(coredump)

dba_sky 发表于 2014-7-29 15:06:43

该问题解决了。
删除dirchk/<extract_name>.cps文件，然后重新启动extract，问题解决。
页: [1]
查看完整版本: CACHESIZE PER DYNAMIC DETERMINATION (32G) LESS THAN RECOMMENDED: 64G (64bit s...