MaximumApplicationAvailabilitywithOracleDatabase12cKuassiMensah

DirectorProductManagementThefollowingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle’sproductsremainsatthesolediscretionofOracle.MyNextSessionOracleIn-DatabaseMapReduce:WhenHadoopMeetsExadata7/25/13,12:00–13:00,Room431ProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsProblemstoSolveUponDatabaseOutageFourProblemsConfrontApplicationsHangErrorsOutcomeofIn-FlightWorkResubmissionofIn-FlightWorkHang->FastApplicationNotification(FAN)

ErrorsHandling?Notformalized

In-FlightWork?Lost!ResubmissionofIn-FlightWork?N/A!CurrentSituationProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsRecoverableErrorFormalizedOracleException.IsRecoverablepropertyApplicationsNolongerneedtomaintainownlistoferrorcodes

(e.g.,ora-1033,ora-1034,ora-xxx)

JDBCthrows

SQLRecoverableException

DatabaseRequest

UnitofWorkPoolDataSourcepds=GetPoolDataSource();Connectionconn=getConnection(pds);PreparedStatementpstmt=……SQL,PL/SQL,localcalls,RPC …mit();conn.close();RequestBeginsRequestBody

UsuallyendswithCOMMITRequestEndsProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsTransactionGuardToolthatsupportsknownoutcomeforeverytransactionWithoutTransactionGuard,retrycancauselogicalcorruptionUsedbyApplicationContinuityCanbeusedindependentlyofApplicationContinuity4.EnforceOutcomeWorkRequest2.DBCalls12cORACLEDatabase3.Errors4.ReliableCommitOutcomeTransactionGuard–TypicalUsageUpondatabaseinstancecrashFANabortsdeadsessionApplicationgetsanerrorPoolremovesorphanconnectionfrompoolIf“recoverableerror”thenGetlastLTXIDfromdeadsessionObtainnewdatabasesessionGettransactionstatusTransactionGuardInActiongetConnection()Txn.Commit();getLastLTXID<newsession>Commitoutcome?COMMIT/ROLLBACKstarttransactionassignLTXIDCOMMIT?Return&PreserveCOMMITOUTCOMEClient/Mid-tierDatabaseTimeRecoverableErrorCOMMITGetLogicalTXIDSQL,PL/SQL,RPCResultsTGinActionOnServiceCOMMIT_OUTCOMEValues–TRUEandFALSEDefault–FALSEAppliestonewsessionsRETENTION_TIMEOUTUnits–secondsDefault–24hours(86400)Maximumvalue–30days(2592000)TransactionGuard

ConfigurationTransactionGuardinOracledatabase12cJDBC-thin,ODP.NET,OCI,OCCICommitModels

LocalTXNAuto-commit,CommitonSuccessCommitembeddedinPL/SQLDDL,DCL,ParallelDDLRemote,DistributedExclusionsXAR/WDBLinksfromActiveDataGuardorReadOnlyProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityDesignConsiderationsApplicationContinuityMaskDatabaseOutageWhenSuccessfulReplaysin-flightworkonrecoverableerrorsMasksmanyhardware,software,network,storageerrorsandoutageswhensuccessfulImprovesenduserexperience5.ResponseWorkRequest2.DBCalls12cORACLEDatabase4.Replay3.ErrorsPhasesinApplicationContinuity1-Capture2-Reconnect3-ReplayDemarcatesdatabaserequestHoldsoriginalcallswithbinds&validationManagesqueuesChecksrequesthasreplayenabledHandlestimeoutsCreatesanewconnectionValidatestargetdatabaseUsesTransactionGuardtoenforcelastcommitReplaysheldcallsContinuesreplay,ifuservisibleresultsmatch,basedonvalidationsContinuesrequestApplicationContinuityInAction

Call1

Application

Proxy1

Proxy2RACDatabaseInstance1Instance2Instance3

Call2

Connection

ReplayContextOracleJDBCDriverDEMOSolutionCoverage

ApplicationContinuityforJavaClient

JDBC-ThindriverUCP,WebLogicServerDatabaseSQL,PL/SQL,RPCSelect,ALTERSESSION,DML,DDL,COMMIT/ROLLBACK/SAVEPOINTTransactionmodels:Local,Parallel,Remote,DistributedMutablefunctionsupportHardwareaccelerationoncurrentIntel&SPARCchipsExclusions

GlobalRequestTargetDatabaseDonotusedefaultdatabaseserviceExcludesXAForJava,deprecatedconcreteclassesRestrictedcallsAlterSystemAlterDatabaseNotsupportedforActiveDataGuardwithread/writedatabaselinksDoesnotsupport:LogicalStandbyGoldenGateRestrictions

WhenDoesReplayNotOccur?

NormalRuntimeReconnectReplayAnycallinsamerequestaftersuccessfulcommitindynamicmode

(default)arestrictedcalldisableReplayAPIErrorisnotrecoverableReconnectionfailureReplayinitiationtimeoutMaxconnectionretriesMaxretriesperincidentTargetdatabasenotvalidforreplayLastcallcommitted

indynamicmodeValidationdetectsdifferentresultsProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsApplicationAssessment

DecideWhattodoRequestBoundariesMarkRequestBoundaries,ifyouarenotusingOraclePoolsJDBCConcreteClassesReplacedeprecatedconcreteclasseswithJavainterfacesSideEffectsUsedisableAPIifadatabaserequesthasanexternalcallthatshouldnotbereplayedCallbacksEnsureacallbackisregisteredifstatechangesoutsideanyrequest(WLS/UCPlabelingincludedbydefault)MutableFunctionsGrantkeepingmutablevaluesifthesearecompatiblewithyourapplicationSideEffectsWhenReplayisenabled,somecallsmayberepeated.

AppsmayneedtousedisableReplay()APItopreventthis:AutonomoustransactionsUTL_HTTP,

UTL_URLUTL_FILE,UTL_FILE_TRANSFER-filesoperationsUTL_SMPT,UTL_TCP,UTL_MAIL-sendingmessagesDBMS_PIPE,RPCs-toexternalsourcesDBMS_ALERT-emailorothernotificationsConfigureJDBCReplayDriver

Setreplaydatasourceinpropertyfile

datasource=oracle.jdbc.replay.OracleDataSourceImplEnableApplicationContinuityonService

SetFAILOVER_TYPE=TRANSACTIONReviewsettingsfor:

REPLAY_INITIATION_TIMEOUT=1800FAILOVER_DELAY=3secondsFAILOVER_RETRIES=60retriesSESSION_STATE_CONSISTENCY=DYNAMICCOMMIT_OUTCOME=TRUEConfiguration

GRANT[KEEPDATETIME|KEEPSYSGUID]..[to

USER]REVOKE[KEEPDATETIME|KEEPSYSGUID][from

USER]GRANTK