Care-and-Feeding-of-Release-11i护理与喂养释放我课件

Introduction WelcomeandIntroductionSessionOverviewThefocusofthispresentationistoshare“Real-World“experienceaswellastipsandtechniquestoinstall,upgradeandtunethecomplexOracleApplicationenvironmentdeliveredwithRelease11i1Administration

and

MaintenanceRelease11iGuidingPrinciplesKISSKeepitSimpleandSupportablesmPossiblevs.Practical3Release11iBasicstoRememberRelease11iisnotastaticreleaseRelease11iinstallseverythingregardlessoflicensingRelease11icontainsconstantlyevolvingtechnologyRelease11ipointupgradesintroducesignificantchangestofunctionalityandtechnologyRelease11ihassignificantinterdependenciesofCriticalProducts:AD,FND,AK,HZ(TCA),OWF,TXK,ADX,SHT,ATG,AU,FWK,OAM4Housekeeping ApplyMinimumPatchesLatestADConsolidated(AD.H)–startingwith11.5.7ADmini-packsandADconsolidatedarethesamePasswordUtility–patchrequiredCloneUtility–patchrequiredpre-11.5.7WorkflowOracleApplicationManagerTechnologyValidationADISecurity/WebADIBackupAD/FNDbindirectoriesModifyprocesses,rbs,temp,redos,init.oraResizetheDatabasePinning–installedmodulepackages/sequencesRunADADMINStepsColdBackuptoDisk/Tape5AutoConfigAutoConfigisaconfigurationtoolthatautomatestheconfigurationofanOracleApplicationssystem.TheinformationrequiredforconfiguringanApplicationssystemiscollectedintoarepository,calledtheApplicationsContext;thereisoneApplicationsContextfortheapplicationtier,andaseparateoneforthedatabasetierWhenAutoConfigruns,itusesinformationfromtheApplicationsContextfiletogenerateallconfigurationfilesandupdatedatabaseprofilesMetaLinkNote165195.1AutoConfigFAQ218089.16CloningDefinitionofCloning:theprocessofreproducinganentireenvironment,includingtheOraclesoftware($ORACLE_HOME)andApplicationsoftware($APPL_TOP)directorystructures.Whitepapers:MetaLinkNote135792.1LimitationsArchitectureTechnologyStackAutoConfig(11.5.7+)7CloningMethodsManuallyDozensofConfigurationFilesNumerousSiteProfileValuesNotSupportedOracle’sadclone.plUtility(pre-11.5.7)Oracle’sAutoConfigUtility(11.5.7)Oracle’sRapidCloneUtility(11.5.8+)Nosharingofsoftware8CloningChecklist–Pre-11.5.7ClonePatchesPERLPathHigh-LevelTasks TargetInstallationadclone.plPre-CloneCopyDirectories(HTML/JAVA)CopyDatabaseadclone.plPost-ClonePost-CloneTasksFND_PRODUCT_GROUPSUpdate9AdCloneAdclone.plMetaLinkNote135792.1Patch2115451+Pre-requisiteSupportedLimitations–IdenticalConfiguration,DatabaseandTechnologyPatchesNotCloned10Migrations–PointReleasesBasicDefinitionandConfigurationTechnologyApplicationsMigrationStrategiesTechnologyMaintenancePack11PatchingPatchingStrategy…Priorto11iPatchto“almost”current–Don’tbebleedingedgeatgo-livePatchtofixspecificissues–Ifitain’tbroke,don’tfixit!PatchingwasmostlyatechnicalissuePatchesweretypicallyspecific–fixedeitherabugoraddednewfunctionality…notboth13PatchDefinitions 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,NoRegressionTesting14AutoPatchReviewAutoPatchChecklistResearchonPatch#–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)15AutoPatchDriverDefinitionsCopydriver(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.TheunifieddriverrequiresonlyasingleexecutionofAutoPatch16Standards–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”17OAMPatchAdvisorOAM.GMini-PackMetaLinkDocument226826.1UsesInfoBundle11i.zip18InfoBundle11i.zipUpdatedNightlybyOracleUpdatesPatchSnapshotRepositoryRecommendedPatchListIncludesPatchPrerequisitesMetaLinkDocument233039.119OraclePatchDocumentation MaintenanceProcedures–June2019(B10641-01)MaintenanceUtilities–June2019(B10640-01)20SecurityPatchesApplicationsCodesetAPPL_TOPWebTierOracleHomeApplicationTierOracleHomeDatabaseTierOracleHomeOracle’sQuarterlyPatchUpdateSometimesSignificantPlanforitaspartofReleaseMgmt21PatchTipsPre-Patched/StagedAPPL_TOPSharedAPPL_TOPDistributedADPatching22PatchMetaLinkFAQsQ:Howoftenshouldcustomersapplymini-packs,familypacks,andmaintenancepacks?

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

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

Q:WherecanIfindalistofAutoPatchfeaturesandtheADmini-packsthatintroducedthem?

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

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

25PatchFAQs

Q:CanIrunmultipleAutoPatchsessionsatthesametime?A: