goldengate安装指南一阶段测试

软件解压安装[oracle@localhost~]$cd inflating:fbo_ggs_Linux_x64_ora10g_64bit.tarinflating:OGG_WinUnix_Rel_Notes_11.1.1.1.1.pdf[oracle@localhost/]$cdoracle[oracle@localhostoracle]$mkdirgoldengate[oracle@localhost/]$cdhome[oracle@localhosthome]$cdoracle[oracle@localhost~]$vim.bash_profileexportGGATE=/oracle/goldengate初始化源端数据库SQL>conn/assysdba;SQL>archivelogDatabaselogmode Automaticarchival Archivedestination Oldestonlinelogsequence Currentlog SQL>shorameter booleanSQL>shutdownDatabaseSQL>startupmount;ORACLEinstancestarted.TotalSystemGlobalArea285212672bytesFixedSize 2095704bytesVariableSize 138413480bytesDatabaseBuffers138412032bytesRedoBuffers 6291456bytesDatabasemounted.SQL>alterdatabaseSQL>alterdatabaseSQL>archivelogDatabaselog Oldestonlinelog Nextlogsequenceto Currentlog SQL>shorameter biginteger2G SQL>altersystemsetdrwxr- 3oracleoinstall409609-2619:12drwxr-xr-x2oracleoinstall409610-2510:15drwxr- 3oracleoinstall409609-2619:14drwxr-xr-x5oracleoinstall409610-2509:54drwxr- 4oracleoinstall409609-2709:36 6oracleoinstall409609-2709:15 3oracleoinstall409609-2619:01SQL*Plus:Release10.2.0.5.0-ProductiononTueOct2510:20:292011Copyright(c)1982,2010,Oracle. s.SQL>conn/asSQL>altersystemsetSQL>altersystemsetSQL>archivelogDatabaselog Archivedestination Oldestonlinelogsequence Nextlogsequenceto Currentlog SQL>alterdatabaseaddsupplementallogSQL>alterdatabaselogging;Databasealtered.SQL>conn/asSQL>MarkersetupYouwillbepromptedforthenameofaschemafortheGoldenGatedatabaseobjects.NOTE:Theschemamustbecreatedpriortorunningthisscript.NOTE:StopallDDLreplicationbeartingthisEnterGoldenGateschemaMarkersetuptablescriptcomplete,runningverificationPleaseenterthenameofaschemafortheGoldenGatedatabaseobjects:SettingschemanaGGScriptSQL>GoldenGateDDLReplicationsetupVerifyingthatcurrentuserhasprivilegestoinstallDDLYouwillbepromptedforthenameofaschemafortheGoldenGatedatabaseNOTE:ForanOracle10gsource,thesystemrecyclebinmustbedisabled.ForOracle11gandlater,itcanbeenabled.NOTE:Theschemamustbecreatedpriortorunningthisscript.NOTE:StopallDDLreplicationbeartingthisEnterGoldenGateschemaYouwillbepromptedforthemodeofToupgradeDDLreplication,enterNORMALEntermodeofWorking,pleasewaitSpoolingtofileCheckingforsessionsthatareholdinglocksonOracleGoldenGatemetadatatables...Checkcomplete.UsingOGGasaGoldenGateschemaname,INITIALSETUPasamodeofinstallation.Working,pleasewait...RECYCLEBINmustbeThisinstallationwillpurgeRECYCLEBINforallusers.EnteryesorDDLreplicationsetupscriptcomplete,runningverificationscript...PleaseenterthenameofaschemafortheGoldenGatedatabaseobjects:SettingschemanaGG Noerrors Noerrors Noerrors Noerrors Noerrors Noerrors No NoINITIAL_SETUP Noerrors Noerrors Noerrors Noerrors No No Noerrors DDLHISTORYTABLEDDLDUMPTABLESDDLDUMPLOGGROUPSDDLDUMPPRIMARYKEYSDDLTRIGGERCODE No NoDDLTRIGGERRUNNINGSTATUSDDLTRIGGERSQLTRACINGDDLTRIGGERTRACE0LOCATIONOFDDLTRACEyzinginstallationstatus...Scriptcomplete.SQL>GGSRolesetupThisscriptwilldropandrecreatetheroleTouseadifferentrolename,quitthisscriptandthenedittheparams.sqlscripttochangethegg_roleparametertothepreferreme.(Donotrunthescript.)YouwillbepromptedforthenameofaschemafortheGoldenGatedatabaseobjects.NOTE:Theschemamustbecreatedpriortorunningthisscript.NOTE:StopallDDLreplicationbeartingthisWrotefilerole_setup_set.txtRolesetupscriptGrantthisroletoeachuserassignedtotheExtract,GGSCI,andManagerprocesses,byusingthefollowingSQLcommand:where<loggedUser>istheuserassignedtotheGoldenGateSQL>grantGGS_GGSUSER_ROLEtoGrantSQL>SQL>createtablespacetbs_gguserdatafile'/oracle/oradata/orcl/gguser.dbf'size100Mautoextendon;SQL>createuseroggidentifiedbyoggdefaulttablespacetbs_ggusertemporarytablespaceTEMPquotaunlimitedontbs_gguser;UserGrantSQL>grantcreatesession,altersessiontoGrantSQL>grantselectanydictionary,selectanytabletoGrantSQL>grant nytabletoGrantSQL>grantflashbackanytabletoGrantSQL>grantexecuteondbms_flashbacktoGrant初始化目标数据库SQL>conn/assysdba;SQL>archivelogDatabaselogmode Automaticarchival Oldestonlinelog Currentlog booleanSQL>shutdownDatabaseSQL>startupmount;ORACLEinstancestarted.TotalSystemGlobalArea285212672bytesFixedSize 2095704bytesVariableSize 138413480bytesDatabaseBuffers138412032bytesRedoBuffers 6291456bytesDatabasemounted.SQL>alterdatabaseSQL>alterdatabaseSQL>archivelogDatabaselog Archivedestination Oldestonlinelogsequence Nextlogsequenceto Currentlog SQL>shorameter biginteger2G SQL>altersystemsetdrwxr-x---3oracleoinstall409609-2619:12drwxr-xr-x2oracleoinstall409610-2510:15drwxr-x---3oracleoinstall409609-2619:14drwxr-xr-x5oracleoinstall409610-2509:54drwxr-x---4oracleoinstall409609-2709:36drwxrwx---6oracleoinstall409609-2709:15drwxrwx---3oracleoinstall409609-2619:01SQL*Plus:Release10.2.0.5.0-ProductiononTueOct2510:20:292011Copyright(c)1982,2010,Oracle. s.SQL>conn/asSQL>altersystemsetSQL>altersystemsetSQL>archivelogDatabaselog Oldestonlinelog Nextlogsequenceto Currentlog SQL>alterdatabaseaddsupplementallogSQL>alterdatabaselogging;Databasealtered.SQL>conn/asSQL>SQL>@ddl_setupSQL>@role_setupEnterGoldenGateschemaname:oggSQL>grantGGS_GGSUSER_ROLEtoogg;SQL>SQL>createtablespacetbs_gguserdatafile'/oracle/oradata/orcl/gguser.dbf'size100Mautoextendon;SQL>createuseroggidentifiedbyoggdefaulttablespacetbs_ggusertemporarytablespaceTEMPquotaunlimitedontbs_gguser;UserGrantSQL>grantcreatesession,altersessiontoGrantSQL>grantselectanydictionary,selectanytabletoGrantSQL>grant nytabletoGrantSQL>grantflashbackanytabletoGrantSQL>grantexecuteondbms_flashbacktoGrantSQL>grsertanytabletoGrantSQL>grantdeleteanytabletoGrantSQL>grantupdateanytabletoGrant[oracle@localhostgoldengate]$./ggsciLinux,x64,64bit(optimized),Oracle10gonJul29201119:43:29Copyright(C)1995,2011,Oracleand/oritsaffiliates.s. Report Checkpoint SQLscriptfiles /oracle/goldengate/dirsql:createdDatabasedefinitionsfiles /oracle/goldengate/dirdef:createdExtractdatafiles /oracle/goldengate/dirdat:createdTemporaryfiles VeridataLockfiles /oracle/goldengate/dirver/lock:createdVeridataOut-Of-Syncfiles /oracle/goldengate/dirver/oos:createdVeridataOut-Of-SyncXMLfiles/oracle/goldengate/dirver/oosxml:createdVeridataParameterfiles VeridataReportfiles /oracle/goldengate/dirver/report:createdVeridataStatusfiles /oracle/goldengate/dirver/status:createdVeridataTracefiles /oracle/goldengate/dirver/trace:createdStdoutfiles /oracle/goldengate/dirout:createdGGSCI(localhost.local)4>Linux,x64,64bit(optimized),Oracle10gonJul29201119:43:29Copyright(C)1995,2011,Oracleand/oritsaffiliates.s.GGSCI(localhost.local)1>dbloginuseridogg,passwordGGSCI(localhost.local)2>editparamsPORTGGSCI(localhost.local)3>editparamsGGSCHEMA2011-10-2514:23:22 WARNINGOGG-01756 CannotregisterEXTRACTEINI_1withdatabasebecauseofthefollowingSQLerror:OCIErrorORA-06550:line1,column3128:PL/SQL:ORA-00942:tableorviewdoesnotexistORA-06550:line1,column3117:PL/SQL:SQLStatementignored(status=0).SeeExtractuserprivilegesintheOracleGoldenGateforOracleInstallationandSetupGuide.YoucanlyregisterthisgroupwiththeREGISTEREXTRACTcommand.EXTRACTGGSCI(localhost.local)7>addrmttrail/oracle/goldengate/dirdat/ma,megabytes100,extracteini_1RMTTRAILGGSCI(localhost.local)8>editparamsEXTRACTUSERIDoggPASSWORDoggRMTHOST192.168.103.58,MGRPORT7809 CLUDEUSERogg///DDLLUDEtable GGSCI(localhost.local)9>startGGSCI(localhost.local)10>startextractGGSCI(localhost.local)9>stopGGSCI(localhost.local)10>stopextractGGSCI(localhost.local)9>infomgrGGSCI(localhost.local)10>infoeini_1[oracle@localhostgoldengate]$./ggsciLinux,x64,64bit(optimized),Oracle10gonJul29201119:43:29Copyright(C)1995,2011,Oracleand/oritsaffiliates.s.Creatingsubdirectoriesundercurrentdirectory/oracle/goldengateParameterfiles Report Checkpoint SQLscriptfiles /oracle/goldengate/dirsql:createdDatabasedefinitionsfiles /oracle/goldengate/dirdef:createdExtractdatafiles /oracle/goldengate/dirdat:createdTemporaryfiles VeridataLockfiles /oracle/goldengate/dirver/lock:createdVeridataOut-Of-Syncfiles /oracle/goldengate/dirver/oos:createdVeridataOut-Of-SyncXMLfiles/oracle/goldengate/dirver/oosxml:createdVeridataParameterfiles VeridataReportfiles /oracle/goldengate/dirver/report:createdVeridataStatusfiles /oracle/goldengate/dirver/status:createdVeridataTracefiles /oracle/goldengate/dirver/trace:createdStdoutfiles /oracle/goldengate/dirout:createdGGSCI(localhost.local)2>Linux,x64,64bit(optimized),Oracle10gonJul29201119:43:29Copyright(C