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

?

?

?

未完待續…………

總結

以上是生活随笔為你收集整理的Oracle goldengate 11g错误汇总的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。