Oracle_11G搭建单实例GoldenGate步骤

《Oracle_11G搭建单实例GoldenGate步骤》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Oracle11G搭建单实例GoldenGate步骤1GoldenGate安装准备在Oracle官网上下载GoldenGate介质，GoldenGate是包含在FusionMiddleware类目下面，并上传到源数据库和目标数据库主机；2GoldenGate安装过程注意：此步骤需要在两台主机上操作2.1创建GoldenGate操作系统用户这里直接使用Oracle用户安装GoldenGate，而不创建新的用户。2.2创建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编辑用户环境变量[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