Oracle goldengate 11g 錯誤彙總

1、 ggsci執行錯誤

[oracle@doudou-NAS ~]$ ggsci

ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory

解決方法：export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/opt/ogg

 

2、找不到ggMessage

GGSCI (doudou-NAS) 1> edit params ./GLOBALS

Cannot load ICU resource bundle 'ggMessage', error code 2 - No such file or directory

Cannot load ICU resource bundle 'ggMessage', error code 2 - No such file or directory

解決方法：oracle goldengate的HOME目錄下執行

 

3、 執行ggsci命令報錯OGG-00014（清空./GLOBALS）

[oracle@doudou-NAS ogg]$ cat GLOBALS

Doudou

[oracle@doudou-NAS ogg]$ ggsci

Source Context :

  SourceModule            : [ggstd.config]

  SourceID                : [/net/ap1109nap-vlan900/vol/ifarm_ports/ifarm_views/aime_oggcore_210874/oggcore/OpenSys/src/gglib/ggstd/config.c]

  SourceFunction          : [readGlobalConfigFile]

  SourceLine              : [851]

  ThreadBacktrace         : [9] elements

                          : [/opt/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x26) [0x9cf166]]

                          : [/opt/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2c5) [0x9cb125]]

                          : [/opt/ogg/libgglog.so(_MSG_ERR_STARTUP_PARAM_UNRECOGNIZED(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x33) [0x9be7c9]]

                          : [ggsci [0x80fc596]]

                          : [ggsci(_ggGetConfig+0x6c) [0x80fc61c]]

                          : [ggsci(ggGetConfig+0x8f) [0x8099d7f]]

                          : [ggsci(main+0x21) [0x80bc1c1]]

                          : [/lib/libc.so.6(__libc_start_main+0xdc) [0xae9ebc]]

                          : [ggsci(__gxx_personality_v0+0x169) [0x8094461]]

 

2013-05-18 00:58:40  ERROR   OGG-00014  Unrecognized parameter: doudou. Parameter could be misspelled or unsupported.

2013-05-18 00:58:40  ERROR   OGG-01668  PROCESS ABENDING.

 

解決方法：清空./GLOBALS

GLOBALS位置:oracle goldengate HOME目錄下

 

4、extract異常終止（OGG-00446）

GGSCI (doudou-NAS) 35> INFO ALL

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          

EXTRACT     STOPPED     EXT1        00:00:00      00:06:09   

EXTRACT     RUNNING     PUMP1       00:00:00      00:00:03

GGSCI (doudou-NAS) 36> view report ext1

2013-06-19 17:26:25  ERROR   OGG-00446  No valid log files for current redo sequence 36, thread 1, error retrieving redo file name f

or sequence 36, archived = 0, use_alternate = 0Not able to establish initial position for sequence 36, rba 27954192.

2013-06-19 17:26:25  ERROR   OGG-01668  PROCESS ABENDING.

解決方法：

extract引數中新增 TRANLOGOPTIONS asmuser sys@asm,asmpassword oracle

注意：配置asm字串，並保證可以連線到源庫

 

原因：ASM儲存trail檔案需要注意一些引數

ASM儲存redo log 或 archive log 應該新增 TRANLOGOPTIONS asmuser sys@asm,asmpassword oracle

正好我們的redo log在ASM上，所以需要新增引數

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /rman/arch/

Oldest online log sequence     34

Next log sequence to archive   36

Current log sequence           36

SQL> select member from v$logfile;

MEMBER

---------------------------------------------

+DATA/doudou/onlinelog/group_3.266.815341983

+DATA/doudou/onlinelog/group_3.267.815341985

+DATA/doudou/onlinelog/group_2.264.815341979

+DATA/doudou/onlinelog/group_2.265.815341981

+DATA/doudou/onlinelog/group_1.262.815341975

+DATA/doudou/onlinelog/group_1.263.815341977