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

 

 

 

未完待续…………