Care-and-Feeding-of-Release-11i護(hù)理與喂養(yǎng)釋放我課件

Introduction WelcomeandIntroductionSessionOverviewThefocusofthispresentationistoshare“Real-World“experienceaswellastipsandtechniquestoinstall,upgradeandtunethecomplexOracleApplicationenvironmentdeliveredwithRelease11i1Introduction WelcomeandIntroAdministration

and

MaintenanceAdministration

and

MaintenanceRelease11iGuidingPrinciplesKISSKeepitSimpleandSupportablesmPossiblevs.Practical3Release11iGuidingPrinciplesRelease11iBasicstoRememberRelease11iisnotastaticreleaseRelease11iinstallseverythingregardlessoflicensingRelease11icontainsconstantlyevolvingtechnologyRelease11ipointupgradesintroducesignificantchangestofunctionalityandtechnologyRelease11ihassignificantinterdependenciesofCriticalProducts:AD,FND,AK,HZ(TCA),OWF,TXK,ADX,SHT,ATG,AU,FWK,OAM4Release11iBasicstoRememberHousekeeping ApplyMinimumPatchesLatestADConsolidated(AD.H)–startingwith11.5.7ADmini-packsandADconsolidatedarethesamePasswordUtility–patchrequiredCloneUtility–patchrequiredpre-11.5.7WorkflowOracleApplicationManagerTechnologyValidationADISecurity/WebADIBackupAD/FNDbindirectoriesModifyprocesses,rbs,temp,redos,init.oraResizetheDatabasePinning–installedmodulepackages/sequencesRunADADMINStepsColdBackuptoDisk/Tape5Housekeeping ApplyMinimumPatAutoConfigAutoConfigisaconfigurationtoolthatautomatestheconfigurationofanOracleApplicationssystem.TheinformationrequiredforconfiguringanApplicationssystemiscollectedintoarepository,calledtheApplicationsContext;thereisoneApplicationsContextfortheapplicationtier,andaseparateoneforthedatabasetierWhenAutoConfigruns,itusesinformationfromtheApplicationsContextfiletogenerateallconfigurationfilesandupdatedatabaseprofilesMetaLinkNote165195.1AutoConfigFAQ218089.16AutoConfigAutoConfigisaconfCloningDefinitionofCloning:theprocessofreproducinganentireenvironment,includingtheOraclesoftware($ORACLE_HOME)andApplicationsoftware($APPL_TOP)directorystructures.Whitepapers:MetaLinkNote135792.1LimitationsArchitectureTechnologyStackAutoConfig(11.5.7+)7CloningDefinitionofCloning:CloningMethodsManuallyDozensofConfigurationFilesNumerousSiteProfileValuesNotSupportedOracle’sadclone.plUtility(pre-11.5.7)Oracle’sAutoConfigUtility(11.5.7)Oracle’sRapidCloneUtility(11.5.8+)Nosharingofsoftware8CloningMethodsManually8CloningChecklist–Pre-11.5.7ClonePatchesPERLPathHigh-LevelTasks TargetInstallationadclone.plPre-CloneCopyDirectories(HTML/JAVA)CopyDatabaseadclone.plPost-ClonePost-CloneTasksFND_PRODUCT_GROUPSUpdate9CloningChecklist–Pre-11.5.7AdCloneAdclone.plMetaLinkNote135792.1Patch2115451+Pre-requisiteSupportedLimitations–IdenticalConfiguration,DatabaseandTechnologyPatchesNotCloned10AdCloneAdclone.plMetaLinkNotMigrations–PointReleasesBasicDefinitionandConfigurationTechnologyApplicationsMigrationStrategiesTechnologyMaintenancePack11Migrations–PointReleasesBasPatchingPatchingPatchingStrategy…Priorto11iPatchto“almost”current–Don’tbebleedingedgeatgo-livePatchtofixspecificissues–Ifitain’tbroke,don’tfixit!PatchingwasmostlyatechnicalissuePatchesweretypicallyspecific–fixedeitherabugoraddednewfunctionality…notboth13PatchingStrategy…Priorto1PatchDefinitions CDBundle(50+CDs)EntireApplicationsReleaseMaintenancePack(AU–11.5.9)EntireCodeSetReleaseforAllApplicationModulesNoTechnologyPatchesIncludedLotsofPre/PostTasks,VERYLong-RunningWillbreak…periodConsolidatedUpdatePatch–11.5.9(185patches)FamilyPack(PRC_PF.I)AllProductModulesMini-packsfortheSpecificFamilyLotsofPre/PostTasks,VERYLong-RunningWilllikelybreakProductMini-Pack(GL.H)EntireReleaseforSpecificApplicationModulesOne-OffBugPatch(HighPriority)FixesSpecificIssue,NoRegressionTesting14PatchDefinitions CDBundle(5AutoPatchReviewAutoPatchChecklistResearchonPatch#–MetaLink,OAUGArchivesReadme.txt,README.htmlShutdownApplicationProcessesPre-RequisitePatches/Tasks,Post-PatchTasksTraditionalC(ode),D(atabase),G(enerate)driversNewU(nified)Driversoptions=nodatabaseportion,nogenerateportion="C"driveroptions=nocopyportion,nogenerateportion="D"driveroptions=nocopyportion,nodatabaseportion="G"driverMigrationtoOtherEnvironments–ToolsManual(AD.HEnhancements)15AutoPatchReviewAutoPatchChecAutoPatchDriverDefinitionsCopydriver(cdriver):Namedc<patchnumber>.drv,andcontainscommandstochangeOracleApplicationsfiles.Thecommandsincludedirectivestocopy/updatefiles,libraries,and/orJava,andcommandsforgeneratingJARfilesand/orCexecutablesDatabasedriver(ddriver):Namedd<patchnumber>.drv,andcontainscommandstochangeOracleApplicationsdatabaseobjects,suchasPL/SQLandtabledefinitions,ortoupdateormigratedataGeneratedriver(gdriver):Namedg<patchnumber>.drv,andcontainscommandstogenerateforms,reports,and/orgraphicsfiles.Inamulti-nodesystem,runitonallapplicationtierAPPL_TOPs,unlesstheAPPL_TOPonlyimplementstheadminserver.Unifieddriver(udriver):Namedu<patchnumber>.drv,itisaconsolidateddrivercontainingallcopy,database,andgenerateactions.ApplythisdrivertoallAPPL_TOPsonallapplicationtierservers.AutoPatchknowswhichcommandshouldberunoneachtypeofapplicationtier.TheunifieddriverrequiresonlyasingleexecutionofAutoPatch16AutoPatchDriverDefinitionsCoStandards–PatchNaming,DriverLogFiles,PatchStatus,IssueTrackingSpreadsheetProcess–Discovery,EvaluationandExamination,Pre/PostPatchTasks,Testing,MigrationApproval,FreezePatchLevels(Install–Int.Testingvs.Upgrade–Latest)Installation–RapidInstall,ADConsolidated,FNDMini-PackOngoingMaintenance–Frequency,BusinessRequirements/Impact11.5.8–allproductfamilypacksoutofdate11.5.9–10monthsold11.5.10–terminalrelease;10gcertificationpendingAutoPatchDocumentation

…thepartsthataren’t“auto”17Standards–PatchNaming,DrivOAMPatchAdvisorOAM.GMini-PackMetaLinkDocument226826.1UsesInfoBundle11i.zip18OAMPatchAdvisorOAM.GMini-PInfoBundle11i.zipUpdatedNightlybyOracleUpdatesPatchSnapshotRepositoryRecommendedPatchListIncludesPatchPrerequisitesMetaLinkDocument233039.119InfoBundle11i.zipUpdatedNighOraclePatchDocumentation MaintenanceProcedures–June2019(B10641-01)MaintenanceUtilities–June2019(B10640-01)20OraclePatchDocumentation MaiSecurityPatchesApplicationsCodesetAPPL_TOPWebTierOracleHomeApplicationTierOracleHomeDatabaseTierOracleHomeOracle’sQuarterlyPatchUpdateSometimesSignificantPlanforitaspartofReleaseMgmt21SecurityPatchesApplicationsPatchTipsPre-Patched/StagedAPPL_TOPSharedAPPL_TOPDistributedADPatching22PatchTipsPre-Patched/StagedPatchMetaLinkFAQsQ:Howoftenshouldcustomersapplymini-packs,familypacks,andmaintenancepacks?

Ataminimum,applymaintenancepackstostaywithintwomaintenancereleases.Forexample,since11.5.9iscurrentlyavailable,customersatthe11.5.7(orearlier)levelshouldbeplanningtheirupgradeto11.5.9.Usemini-packsandfamilypacksifyouhaveanimmediateneedforthelatestpatchlevelforaproductorproductfamilyandcannotwaittoapplythecorrespondingmaintenancepack.23PatchMetaLinkFAQsQ:HowoftePatchMetaLinkFAQsQ:HowcanIfindthelatestavailablemini-pack,familypack,ormaintenancepack?

A:OnOracleMetaLink,clickthePatchesbuttonontheleft-handside.ChoosetheQuickLinkstotheLatestPatchsets,MiniPacks,andMaintenancePackslinktogeteither:

Q:WherecanIfindalistofAutoPatchfeaturesandtheADmini-packsthatintroducedthem?

A:TheOracleApplicationsDBA11i+FeaturesMatrix(OracleMetaLinkID:210326.1)containsalistofmajorADfeaturesinRelease11iandidentifieswhichADmini-packintroducedeachfeature.24PatchMetaLinkFAQsQ:HowcanPatchMetaLinkFAQsQ:WhatistheADFeaturesmatrixprintedontheAutoPatchscreenandlogfiles?

A:ADFeatureVersionsisaframeworkcreatedtohandlemismatchesbetweentheADcodeonthefilesystemandtheADobjectsinthedatabase.Boththeversionofthefeatureonthefilesystemandtheversionofthefeatureinthedatabasearetrackedseparately.Whenthetwoversionsdonotmatch,thefeatureisdisabled,andwhenthetwoversionsmatch,thefeatureis(normally)enabled.

25PatchMetaLinkFAQsQ:WhatisPatchFAQs

Q:CanIrunmultipleAutoPatchsessionsatthesametime?A:Youcannotcurrentlyrunmultiplesessionssimultaneously;however,patchescanbemergedandcanbeappliedinasinglepatchingsession;anewADfeaturecalledADConcurrentSessionsiscurrentlybeingtested26PatchFAQs

Q:CanIrunmultipPatchFAQsQ:HowcanIdeterminetheeffectsapatchwillhaveonmysystem?A:YoucansubmitaspecificpatchanalysisrequestthroughthePatchAdvisortodeterminetheimpactofapatchonyoursystem.PatchAdvisorImpactAnalysisprovidesreportson:ThetotalnumberoffilesinthepatchThenumberoffilesthepatchwillinstallTheproductsthatwillhaveupdatedfilesThefilesthatwillbeintroducedbythepatchThefilesonthetargetsystemthatwillbechangedbythepatchThefileswithdependenciesonpatchedfiles27PatchFAQsQ:HowcanIdetermiQ&AHopeyouenjoyedthisRelease11isession!Remember:KISSKeepItSimpleandSupportablesmRandyGieferrgiefersolutionbeacon

solutionbeacon

28Q&AHopeyouenjoyedthisReleaCare-and-Feeding-of-Release-11i護(hù)理與喂養(yǎng)釋放我課件Care-and-Feeding-of-Release-11i護(hù)理與喂養(yǎng)釋放我課件Introduction WelcomeandIntroductionSessionOverviewThefocusofthispresentationistoshare“Real-World“experienceaswellastipsandtechniquestoinstall,upgradeandtunethecomplexOracleApplicationenvironmentdeliveredwithRelease11i31Introduction WelcomeandIntroAdministration

and

MaintenanceAdministration

and

MaintenanceRelease11iGuidingPrinciplesKISSKeepitSimpleandSupportablesmPossiblevs.Practical33Release11iGuidingPrinciplesRelease11iBasicstoRememberRelease11iisnotastaticreleaseRelease11iinstallseverythingregardlessoflicensingRelease11icontainsconstantlyevolvingtechnologyRelease11ipointupgradesintroducesignificantchangestofunctionalityandtechnologyRelease11ihassignificantinterdependenciesofCriticalProducts:AD,FND,AK,HZ(TCA),OWF,TXK,ADX,SHT,ATG,AU,FWK,OAM34Release11iBasicstoRememberHousekeeping ApplyMinimumPatchesLatestADConsolidated(AD.H)–startingwith11.5.7ADmini-packsandADconsolidatedarethesamePasswordUtility–patchrequiredCloneUtility–patchrequiredpre-11.5.7WorkflowOracleApplicationManagerTechnologyValidationADISecurity/WebADIBackupAD/FNDbindirectoriesModifyprocesses,rbs,temp,redos,init.oraResizetheDatabasePinning–installedmodulepackages/sequencesRunADADMINStepsColdBackuptoDisk/Tape35Housekeeping ApplyMinimumPatAutoConfigAutoConfigisaconfigurationtoolthatautomatestheconfigurationofanOracleApplicationssystem.TheinformationrequiredforconfiguringanApplicationssystemiscollectedintoarepository,calledtheApplicationsContext;thereisoneApplicationsContextfortheapplicationtier,andaseparateoneforthedatabasetierWhenAutoConfigruns,itusesinformationfromtheApplicationsContextfiletogenerateallconfigurationfilesandupdatedatabaseprofilesMetaLinkNote165195.1AutoConfigFAQ218089.136AutoConfigAutoConfigisaconfCloningDefinitionofCloning:theprocessofreproducinganentireenvironment,includingtheOraclesoftware($ORACLE_HOME)andApplicationsoftware($APPL_TOP)directorystructures.Whitepapers:MetaLinkNote135792.1LimitationsArchitectureTechnologyStackAutoConfig(11.5.7+)37CloningDefinitionofCloning:CloningMethodsManuallyDozensofConfigurationFilesNumerousSiteProfileValuesNotSupportedOracle’sadclone.plUtility(pre-11.5.7)Oracle’sAutoConfigUtility(11.5.7)Oracle’sRapidCloneUtility(11.5.8+)Nosharingofsoftware38CloningMethodsManually8CloningChecklist–Pre-11.5.7ClonePatchesPERLPathHigh-LevelTasks TargetInstallationadclone.plPre-CloneCopyDirectories(HTML/JAVA)CopyDatabaseadclone.plPost-ClonePost-CloneTasksFND_PRODUCT_GROUPSUpdate39CloningChecklist–Pre-11.5.7AdCloneAdclone.plMetaLinkNote135792.1Patch2115451+Pre-requisiteSupportedLimitations–IdenticalConfiguration,DatabaseandTechnologyPatchesNotCloned40AdCloneAdclone.plMetaLinkNotMigrations–PointReleasesBasicDefinitionandConfigurationTechnologyApplicationsMigrationStrategiesTechnologyMaintenancePack41Migrations–PointReleasesBasPatchingPatchingPatchingStrategy…Priorto11iPatchto“almost”current–Don’tbebleedingedgeatgo-livePatchtofixspecificissues–Ifitain’tbroke,don’tfixit!PatchingwasmostlyatechnicalissuePatchesweretypicallyspecific–fixedeitherabugoraddednewfunctionality…notboth43PatchingStrategy…Priorto1PatchDefinitions CDBundle(50+CDs)EntireApplicationsReleaseMaintenancePack(AU–11.5.9)EntireCodeSetReleaseforAllApplicationModulesNoTechnologyPatchesIncludedLotsofPre/PostTasks,VERYLong-RunningWillbreak…periodConsolidatedUpdatePatch–11.5.9(185patches)FamilyPack(PRC_PF.I)AllProductModulesMini-packsfortheSpecificFamilyLotsofPre/PostTasks,VERYLong-RunningWilllikelybreakProductMini-Pack(GL.H)EntireReleaseforSpecificApplicationModulesOne-OffBugPatch(HighPriority)FixesSpecificIssue,NoRegressionTesting44PatchDefinitions CDBundle(5AutoPatchReviewAutoPatchChecklistResearchonPatch#–MetaLink,OAUGArchivesReadme.txt,README.htmlShutdownApplicationProcessesPre-RequisitePatches/Tasks,Post-PatchTasksTraditionalC(ode),D(atabase),G(enerate)driversNewU(nified)Driversoptions=nodatabaseportion,nogenerateportion="C"driveroptions=nocopyportion,nogenerateportion="D"driveroptions=nocopyportion,nodatabaseportion="G"driverMigrationtoOtherEnvironments–ToolsManual(AD.HEnhancements)45AutoPatchReviewAutoPatchChecAutoPatchDriverDefinitionsCopydriver(cdriver):Namedc<patchnumber>.drv,andcontainscommandstochangeOracleApplicationsfiles.Thecommandsincludedirectivestocopy/updatefiles,libraries,and/orJava,andcommandsforgeneratingJARfilesand/orCexecutablesDatabasedriver(ddriver):Namedd<patchnumber>.drv,andcontainscommandstochangeOracleApplicationsdatabaseobjects,suchasPL/SQLandtabledefinitions,ortoupdateormigratedataGeneratedriver(gdriver):Namedg<patchnumber>.drv,andcontainscommandstogenerateforms,reports,and/orgraphicsfiles.Inamulti-nodesystem,runitonallapplicationtierAPPL_TOPs,unlesstheAPPL_TOPonlyimplementstheadminserver.Unifieddriver(udriver):Namedu<patchnumber>.drv,itisaconsolidateddrivercontainingallcopy,database,andgenerateactions.ApplythisdrivertoallAPPL_TOPsonallapplicationtierservers.AutoPatchknowswhichcommandshouldberunoneachtypeofapplicationtier.TheunifieddriverrequiresonlyasingleexecutionofAutoPatch46AutoPatchDriverDefinitionsCoStandards–PatchNaming,DriverLogFiles,PatchStatus,IssueTrackingSpreadsheetProcess–Discovery,EvaluationandExamination,Pre/PostPatchTasks,Testing,MigrationApproval,FreezePatchLevels(Install–Int.Testingvs.Upgrade–Latest)Installation–RapidInstall,ADConsolidated,FNDMini-PackOngoingMaintenance–Frequency,BusinessRequirements/Impact11.5.8–allproductfamilypacksoutofdate11.5.9–10monthsold11.5.10–terminalrelease;10gcertificationpendingAutoPatchDocumentation

…thepartsthataren’t“auto”47Standards–PatchNaming,DrivOAMPatchAdvisorOAM.GMini-PackMetaLinkDocument226826.1UsesInfoBundle11i.zip48OAMPatchAdvisorOAM.GMini-PInfoBundle11i.zipUpdatedNightlybyOracleUpdatesPatchSnapshotRepositoryRecommendedPatchListIncludesPatchPrerequisitesMetaLinkDocument233039.149InfoBundle11i.zipUpdatedNighOraclePatchDocumentation MaintenanceProcedures–June2019(B10641-01)MaintenanceUtilities–June2019(B10640-01)50OraclePatchDocumentation MaiSecurityPatchesApplicationsCodesetAPPL_TOPWebTierOracleHomeApplicationTierOracleHomeDatabaseTierOracleHomeOracle’sQuarterlyPatchUpdateSometimesSignificantPlanforitaspartofReleaseMgmt51SecurityPatchesApplicationsPatchTipsPre-Patched/StagedAPPL_TOPSharedAPPL_TOPDistributedADPatching52PatchTipsPre-Patched/StagedPatchMetaLinkFAQsQ:Howoftenshouldcustomersapplymini-packs,familypacks,andmaintenancepacks?

Ataminimum,applymaintenancepackstostaywithintwomaintenancereleases.Forexample,since11.5.9iscurrentlyavailable,customersatthe11.5.7(orearlier)levelshouldbeplanningtheirupgradeto11.5.9.Usemini-packsandfamilypacksifyouhaveanimmediateneedforthelatestpatchlevelforaproductorproductfamilyandcannotwaittoapplythecorrespondingmaintenancepack.53PatchMetaLinkFAQsQ:HowoftePatchMetaLinkFAQsQ:HowcanIfindthelatestavailablemini-pack,familypack,ormaintenancepack?

A:OnOracleMetaLink,clickthePatchesbuttonontheleft-handside.ChoosetheQuickLinkstotheLatestPatchsets,MiniPacks,andMaintenancePackslinktogeteither:

Q:Wherec