資源描述：
《Oracle_11G搭建單實(shí)例GoldenGate步驟》由會員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在教育資源-天天文庫。
1、Oracle11G搭建單實(shí)例GoldenGate步驟1GoldenGate安裝準(zhǔn)備在Oracle官網(wǎng)上下載GoldenGate介質(zhì)，GoldenGate是包含在FusionMiddleware類目下面，并上傳到源數(shù)據(jù)庫和目標(biāo)數(shù)據(jù)庫主機(jī)；2GoldenGate安裝過程注意：此步驟需要在兩臺主機(jī)上操作2.1創(chuàng)建GoldenGate操作系統(tǒng)用戶這里直接使用Oracle用戶安裝GoldenGate，而不創(chuàng)建新的用戶。2.2創(chuàng)建GoldenGate安裝路徑[root@GMDBA~]#mkdir-p/u01/ggs/11.2.0[root@GMDBA~]#mv/
2、u01/software/ogg112101_fbo_ggs_Linux_x86_ora11g_32bit.zip/u01/ggs/11.2.0/[root@GMDBA~]#chown-Roracle:oinstall/u01/ggs/[root@GMDBA~]#su-oracle2.3編輯用戶環(huán)境變量[oracle@GMDBAogg]$vi~/.bash_profile#.bash_profile#Getthealiasesandfunctionsif[-f~/.bashrc];then.~/.bashrcFi#Userspecificenviro
3、nmentandstartupprogramsPATH=$PATH:$HOME/binexportPATHexportORACLE_SID=GMDBAexportORACLE_BASE=/u01/app/oracleexportORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1exportPATH=$ORACLE_HOME/bin:/u01/ggs/11.2.0:$PATHexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/u01/ggs/11.2.0:/libaliassql
4、plus='rlwrapsqlplus'aliasrman='rlwraprman'2.4安裝GoldenGate文件[oracle@GMDBA~]$cd/u01/ggs/11.2.0/[oracle@GMDBA11.2.0]$unzipogg112101_fbo_ggs_Linux_x86_ora11g_32bit.zipArchive:ogg112101_fbo_ggs_Linux_x86_ora11g_32bit.zipinflating:fbo_ggs_Linux_x86_ora11g_32bit.tarinflating:OGG_WinUn
5、ix_Rel_Notes_11.2.1.0.1.pdfinflating:OracleGoldenGate11.2.1.0.1README.txtinflating:OracleGoldenGate11.2.1.0.1README.doc[oracle@GMDBA11.2.0]$tar-xvffbo_ggs_Linux_x86_ora11g_32bit.tar[oracle@GMDBA11.2.0]$cd[oracle@GMDBA~]$cd/u01/ggs/11.2.0[oracle@GMDBA11.2.0]$ggsciOracleGoldenGat
6、eCommandInterpreterforOracleVersion11.2.1.0.1OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBOLinux,x86,32bit(optimized),Oracle11gonApr23201208:09:25Copyright(C)1995,2012,Oracleand/oritsaffiliates.Allrightsreserved.GGSCI(GMDBA)1>createsubdirsCreatingsubdirectoriesundercurrentdirecto
7、ry/u01/ggs/11.2.0Parameterfiles/u01/ggs/11.2.0/dirprm:alreadyexistsReportfiles/u01/ggs/11.2.0/dirrpt:createdCheckpointfiles/u01/ggs/11.2.0/dirchk:createdProcessstatusfiles/u01/ggs/11.2.0/dirpcs:createdSQLscriptfiles/u01/ggs/11.2.0/dirsql:createdDatabasedefinitionsfiles/u01/ggs/
8、11.2.0/dirdef:createdExtractdatafiles/u01/ggs/11.2.0/d
