MySQL Installation and Setup Guide

Oracle®GoldenGateMySQLInstallationandSetupGuide11gRelease1(11.1.1)E17798-01October2010OracleGoldenGateMySQLInstallationandSetupGuide11gRelease1(11.1.1)E17798-01Copyright©1995,2010Oracleand/oritsaffiliates.Allrightsreserved.Thissoftwareandrelateddocumentationareprovidedunderalicenseagreementcontainingrestrictionsonuseanddisclosureandareprotectedbyintellectualpropertylaws.Exceptasexpresslypermittedinyourlicenseagreementorallowedbylaw,youmaynotuse,copy,reproduce,translate,broadcast,modify,license,transmit,distribute,exhibit,perform,publish,ordisplayanypart,inanyform,orbyanymeans.Reverseengineering,disassembly,ordecompilationofthissoftware,unlessrequiredbylawforinteroperability,isprohibited.Theinformationcontainedhereinissubjecttochangewithoutnoticeandisnotwarrantedtobeerror-free.Ifyoufindanyerrors,pleasereportthemtousinwriting.IfthissoftwareorrelateddocumentationisdeliveredtotheU.S.GovernmentoranyonelicensingitonbehalfoftheU.S.Government,thefollowingnoticeisapplicable:U.S.GOVERNMENTRIGHTSPrograms,software,databases,andrelateddocumentationandtechnicaldatadeliveredtoU.S.GovernmentcustomersarecommercialcomputersoftwareorcommercialtechnicaldatapursuanttotheapplicableFederalAcquisitionRegulationandagency-specificsupplementalregulations.Assuch,theuse,duplication,disclosure,modification,andadaptationshallbesubjecttotherestrictionsandlicensetermssetforthintheapplicableGovernmentcontract,and,totheextentapplicablebythetermsoftheGovernmentcontract,theadditionalrightssetforthinFAR52.227-19,CommercialComputerSoftwareLicense(December2007).OracleUSA,Inc.,500OracleParkway,RedwoodCity,CA94065.Thissoftwareisdevelopedforgeneraluseinavarietyofinformationmanagementapplications.Itisnotdevelopedorintendedforuseinanyinherentlydangerousapplications,includingapplicationswhichmaycreateariskofpersonalinjury.Ifyouusethissoftwareindangerousapplications,thenyoushallberesponsibletotakeallappropriatefail-safe,backup,redundancy,andothermeasurestoensurethesafeuseofthissoftware.OracleCorporationanditsaffiliatesdisclaimanyliabilityforanydamagescausedbyuseofthissoftwareindangerousapplications.OracleisaregisteredtrademarkofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.Thissoftwareanddocumentationmayprovideaccesstoorinformationoncontent,products,andservicesfromthirdparties.OracleCorporationanditsaffiliatesarenotresponsibleforandexpresslydisclaimallwarrantiesofanykindwithrespecttothird-partycontent,products,andservices.OracleCorporationanditsaffiliateswillnotberesponsibleforanyloss,costs,ordamagesincurredduetoyouraccesstooruseofthird-partycontent,products,orservices.1OracleGoldenGateMySQLInstallationandSetupGuide........................................................................Contents...............Chapter1Systemrequirementsandpreinstallationinstructions..................................3OverviewofOracleGoldenGateforMySQL...............................................3Supportedplatforms.......................................................................3Operatingsystemrequirements...........................................................3Databaserequirements....................................................................5Supporteddatatypes......................................................................6Non-supporteddatatypes.................................................................6Supportedobjectsandoperations........................................................7Non-supportedobjectsandoperations...................................................7Supportedandnon-supportedobjectnamesandcase..................................7Objectnamesandowners............................................................7Casesensitivity........................................................................8Supportedcharacters.................................................................8Non-supportedcharacters............................................................9Chapter2InstallingOracleGoldenGate..............................................................11Installationoverview......................................................................11Upgrades............................................................................11Newinstallations....................................................................11DownloadingOracleGoldenGate........................................................11SettinglibrarypathsfordynamicbuildsonUNIXsystems..............................12InstallingOracleGoldenGateonLinuxandUNIX........................................13InstallingtheOracleGoldenGatefiles..............................................13ConfiguringManagerandotherprocesses.........................................14InstallingOracleGoldenGateonWindowsandWindowsCluster.......................14InstallingOracleGoldenGateintoaWindowsCluster.............................14InstallingtheOracleGoldenGatefiles..............................................14SpecifyingacustomManagername..............