Oracle 高可用 goldengate 11g 錯誤彙總

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

 

 

 

未完待續 …………