dba_sky

10 积分	1 好友	3 主题

发消息

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

1^#

发表于 2014-7-28 17:14:30 | 查看: 9579| 回复: 4

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          : [ggapp.util.pcs]
  SourceID             : [/scratch/aime1/adestore/views/aime1_staoi06/oggcore/OpenSys/src/gglib/ggapp/pcsutl.c]
  SourceFunction       : [AbendHandler]
  SourceLine             : [893]

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时间不长，还请大师们多多指教

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2014-7-28 17:18:58

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

回复只看该作者道具举报

dba_sky

3^#

发表于 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

4^#

发表于 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          : [ggapp.util.pcs]
  SourceID             : [/scratch/aime1/adestore/views/aime1_staoi06/oggcore/OpenSys/src/gglib/ggapp/pcsutl.c]
  SourceFunction       : [AbendHandler]
  SourceLine             : [893]

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

5^#

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

该问题解决了。
删除dirchk/<extract_name>.cps文件，然后重新启动extract，问题解决。

已有 1 人评分	威望	理由
Maclean Liu(刘相兵	+ 10	结贴有奖

总评分: 威望 + 10 查看全部评分

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册