Oracle®TransparentGatewayforSybaseAdministrator’sGuide10gRelease2(10.2)forHP-UXB14283-02June2008OracleTransparentGatewayforSybaseAdministrator’sGuide,10gRelease2(10.2)forHP-UXB14283-02Copyright©2002,2008,Oracle.Allrightsreserved.PrimaryAuthor:AmitaiSelaContributingAuthor:LaurelHale,CynthiaKibbe,KishanPeyettiContributor:OritCuriel,JaccoDraaijer,ViraGoorahThePrograms(whichincludeboththesoftwareanddocumentation)containproprietaryinformation;theyareprovidedunderalicenseagreementcontainingrestrictionsonuseanddisclosureandarealsoprotectedbycopyright,patent,andotherintellectualandindustrialpropertylaws.Reverseengineering,disassembly,ordecompilationofthePrograms,excepttotheextentrequiredtoobtaininteroperabilitywithotherindependentlycreatedsoftwareorasspecifiedbylaw,isprohibited.Theinformationcontainedinthisdocumentissubjecttochangewithoutnotice.Ifyoufindanyproblemsinthedocumentation,pleasereportthemtousinwriting.Thisdocumentisnotwarrantedtobeerror-free.ExceptasmaybeexpresslypermittedinyourlicenseagreementforthesePrograms,nopartoftheseProgramsmaybereproducedortransmittedinanyformorbyanymeans,electronicormechanical,foranypurpose.IftheProgramsaredeliveredtotheUnitedStatesGovernmentoranyonelicensingorusingtheProgramsonbehalfoftheUnitedStatesGovernment,thefollowingnoticeisapplicable:U.S.GOVERNMENTRIGHTSPrograms,software,databases,andrelateddocumentationandtechnicaldatadeliveredtoU.S.GovernmentcustomersarecommercialcomputersoftwareorcommercialtechnicaldatapursuanttotheapplicableFederalAcquisitionRegulationandagency-specificsupplementalregulations.Assuch,use,duplication,disclosure,modification,andadaptationofthePrograms,includingdocumentationandtechnicaldata,shallbesubjecttothelicensingrestrictionssetforthintheapplicableOraclelicenseagreement,and,totheextentapplicable,theadditionalrightssetforthinFAR52.227-19,CommercialComputerSoftware--RestrictedRights(June1987).OracleUSA,Inc.,500OracleParkway,RedwoodCity,CA94065.TheProgramsarenotintendedforuseinanynuclear,aviation,masstransit,medical,orotherinherentlydangerousapplications.Itshallbethelicensee'sresponsibilitytotakeallappropriatefail-safe,backup,redundancyandothermeasurestoensurethesafeuseofsuchapplicationsiftheProgramsareusedforsuchpurposes,andwedisclaimliabilityforanydamagescausedbysuchuseofthePrograms.Oracle,JDEdwards,PeopleSoft,andSiebelareregisteredtrademarksofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.TheProgramsmayprovidelinkstoWebsitesandaccesstocontent,products,andservicesfromthirdparties.Oracleisnotresponsiblefortheavailabilityof,oranycontentprovidedon,third-partyWebsites.Youbearallrisksassociatedwiththeuseofsuchcontent.Ifyouchoosetopurchaseanyproductsorservicesfromathirdparty,therelationshipisdirectlybetweenyouandthethirdparty.Oracleisnotresponsiblefor:(a)thequalityofthird-partyproductsorservices;or(b)fulfillinganyofthetermsoftheagreementwiththethirdparty,includingdeliveryofproductsorservicesandwarrantyobligationsrelatedtopurchasedproductsorservices.Oracleisnotresponsibleforanylossordamageofanysortthatyoumayincurfromdealingwithanythirdparty.iiiContentsPreface.................................................................................................................................................................ixAudience.......................................................................................................................................................ixDocumentationAccessibility.....................................................................................................................ixRelatedDocuments.....................................................................................................................................xConventions.................................................................................................................................................x1IntroductionOverview....................................................................................................................................................1-1HeterogeneousServicesTechnology....................................................................................................1-2OracleTransparentGateways................................................................................................................1-22ConfiguringtheGatewayConfiguringtheGateway.......................................................................................................................2-1Task1:ChooseaSystemIdentifierfortheGateway....................................................................2-1Task2:CustomizetheInitializationParameterFile.....................................................................2-1ConfiguringOracleNetServicesListenerfortheGateway............................................................2-2Task1:ConfigureOracleNetServicesTNSListenerfortheGateway......................................2-2ExampleofAddresstoListenOninlistener.oraFile...........................