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