OGGg同构(GoldenGate-ORACLE)、异构(GoldenGate-MYSQL)同步配置及错误解析.docx

OGG同构?(ORACL?E-ORACL?E)、异构(ORACL?E-MYSQL?)同步配置及?错误解析环境：(已安装数据?库实例)+OEL5.75?zlm?sid:zlm11?g0?zlm2?sid:zlm11?g一、安装软件，配置环境，创建相关用?户1.1?下载介质并?安装OGG?软件从官方网址?下载最新版?OGG?FOR?ORACL?E?11g?ON?LINUX??X86-64软件：http://www.oracl?/techn?etwor?k/middl?eware?/golde?ngate?/downl?oads/index?.html?ssSou?rceSi?teId=ocome?nOracl?e?Golde?nGate??V.1?for?Oracl?e?11g?on?Linux??x86-64?(86?MB)?介质名称：ogg11?2101_?fbo_g?gs_Li?nux_x?64_or?a11g_?64bit?.zip1.2?把OGG软?件包复制到?源端ora?cle主目?录，创建安装目?录gg11?后2次解压?到gg11?[oracl?e@zlm?~]$?lsogg11?2101_?fbo_g?gs_Li?nux_x?64_or?a11g_?64bit?.zip[oracl?e@zlm?~]$?cd?$OACLE?_BASE?[oracl?e@zlm?oracl?e]$?mkdir??gg11[oracl?e@zlm?oracl?e]$?cd?gg11[oracl?e@zlm?gg11]$?unzip??/home/oracl?e/ogg11?2101_?fbo_g?gs_Li?nux_x?64_or?a11g_?64bit?.zip?[oracl?e@zlm?gg11]$?lltotal??22376?4-rw-rw-r--?1?oracl?e?oinst?all?22855?6800?Apr?23??2012?fbo_g?gs_Li?nux_x?64_or?a11g_?64bit?.tar-rwxrw?xrwx?1?oracl?e?oinst?all????22054?6?May??2??2012?OGG_W?inUni?x_Rel?_Note?s_.1.pdf-rwxrw?xrwx?1?oracl?e?oinst?all?????93696??May??2??2012?Oracl?e?Golde?nGate??.1?READM?E.doc-rwxrw?xrwx?1?oracl?e?oinst?all?????24390??May??2??2012?Oracl?e?Golde?nGate??.1?READM?E.txt[oracl?e@zlm?gg11]$?tar?xvof?fbo_g?gs_Li?nux_x?64_or?a11g_?64bit?.tar?1.3?修改环境变?量文件.bash_?profi?le，加入OGG?的环境变量?expor?t?GGHOM?E=$ORACL?E_BAS?E/gg11expor?t?PATH=$ORACL?E_BAS?E/gg11:$ORACL?E_HOM?E/bin:/usr/bin/:$PATH[oracl?e@zlm?gg11]$?.?~/.bash_?profi?le[oracl?e@zlm?gg11]$?ggsci?ggsci?:?error??while??loadi?ng?share?d?libra?ries:?libnn?z11.so:?canno?t?open?share?d?objec?t?file:?No?such?file?or?direc?tory由于没有设?置LD_L?IBRAR?Y_PAT?H环境变量?，所以无法执?行ggsc?i，添加exp?ort?LD_LI?BLARY?_PATH?=$ORACL?E_BAS?E/gg11:$ORACL?E_HOM?E/lib:$ORACL?E_HOM?E/bin到环境变量?.bash_?profi?le并so?urce，或者创建一?个link?文件：[oracl?e@zlm?gg11]$?ln?-s?/u01/app/oracl?e/produ?ct/11.2.0/db_1/lib/libnn?z11.so?-/u01/app/oracl?e/produ?ct/11.2.0/db_1/lib/libnn?z10.so?1.4?创建OGG?专用目录s?ubdir?sGGSCI??(zlm)?1?creat?e?subdi?rsCreat?ing?subdi?recto?ries?under??curre?nt?direc?tory?/u01/app/oracl?e/gg11Param?eter?fi