OEM 12c Upgrade - Best Practices, Key Features, Tips & Techniques - Oracle

1y ago
17 Views
2 Downloads
4.72 MB
37 Pages
Last View : 1d ago
Last Download : 2m ago
Upload by : Camden Erdman
Transcription

OEM 12c Upgrade - BestPractices, Key Features,Tips & TechniquesRavi Ammamuthu – IT Mgr CiscoSarayu Damodaran – IT Architect CiscoVirendra Galotra – CSD OracleCon ID: CON618410/02/2012 2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential1

Integrated Support and Systems ManagementCombined solution that helps to: Avoid problems, real-time access to Oracle proactive alerts Rollout planned changes in a single downtime Solve problems faster with Configuration Management integration Stay current with best practices with configuration drivenrecommendations and community forums99999 2010 Cisco and/or its affiliates. All rights reserved.9SR ManagementProactive Recommendations9HealthchecksIn-context knowledge9Community feedback9Configuration DriftManagementPre-patch dependencyanalysisPatch AutomationConfiguration ComplianceCisco Confidential2

Building On SuccessImproving Your SupportExperience With EnterpriseManager 12cMy Oracle Support @ Oracle Certification Checks Health Checks Mobile View & Update SRs Oracle Configuration Manager Service Requests Knowledge Certification Communities 2010 Cisco and/or its affiliates. All rights reserved.Enterprise Manager 12cEnterprise Manager 11.1 Patch Recommendation Patch Plans Pre-Patch Analysis Patch Automation Community Feedback Upgrade Advisor Upgrade Plans Harvester Service Requests Knowledge Certification Communities Auto Discovery, Agent Push Multi CSI Support In Context Knowledge Recommended Patch Advisor Support Workbench Integration Mobile Incident Manager Patch Recommendation Patch Plans Pre-Patch Analysis Patch Automation Community Feedback Upgrade Advisor Upgrade Plans Harvester Service Requests Knowledge Certification CommunitiesCisco Confidential3

Cisco And OracleCollaboration 2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential4

Cisco and Oracle Collaboration – 12c Upgrade experience Support Account Management Engagement Enterprise customers Oracle team engaged early (in planning ) Diversified Cisco environments Multiple OS platforms and multiple db versions Cisco Transparency for collaboration Best practices per Oracle recommendations Regular checkpoints Leveraging Oracle support processes Two phase upgrade – Non prod & Production footprint 2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential5

What if I am a Premier Support Customer? Leverage Proactive MOS Tools Support.oracle.com; Go proactive with cloud collateral OEM 12c Proactive Upgrade program Leverage ACS onsite services for 12c Upgrade Online Upgrade Material atches-512013.html Follow best practices per Oracle recommendations Leverage Oracle Support for upgrade planning Talk to your account team 2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential6

Agenda OEM Journey OEM Landscape OEM 12c Upgrade Best Practices, Tips & Challenges OEM Future Roadmap 2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential7

OEM Journey In Cisco 2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential8

OEM Journey In Cisco OEM infrastructurebuild Monitoring of prodand life cycledatabases Data masking SQL UDM Total of 2 OEM gridsO10g2009-2010 2010 Cisco and/or its affiliates. All rights reserved. Migration to newworld-class DC Separation of prodand non prod grid Monitoring of multiplestandby DBs(ActivePassive) Total of 4 OEM gridsOEM 10gSJCE2011OEM 10gRCDN Integration of EMdata with Cisco tools Enterprise widepatching through OEM OEM 12c upgrade Jobs and scripts UDM ASM monitoringM2012Cisco Confidential9

OEM Landscape 2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential10

OEM – Borderless Across CiscoGlobal OEM usersPROD1PROD2All ProdTargetsAll NonProdTargetsSTG & DEV Total targets - 2004 Targets by category are: Prod - 353 hosts, 272 DBs NonProd – 520 hosts, 787 DBs DG – 24 hosts, 48 DBs Targets on UCS, Sun-OSSize per Repository DB - 500GB97 Metrics25 Reports & 2 Jobs 2010 Cisco and/or its affiliates. All rights reserved.LegendGrid Control & TargetsTargets OnlyCisco Confidential11

OEM – Borderless Across CiscoMetric Statistics In CiscoASM21Database Instance19SQL UDM19Host9Cluster8Database7Cluster Database6Agent5Listener2OS UDM1Total97 2010 Cisco and/or its affiliates. All rights reserved.Global OEM usersLegendGrid Control & TargetsTargets OnlyCisco Confidential12

EM Grid ArchitectureEM AgentsLoad BalancerOMS Server 2 active nodes on VMActiveOMSActiveOMSRAC LBOEM Repository DB 2 node RAC DB on CiscoUCS* servers* UCS – Unified Computing System 2010 Cisco and/or its affiliates. All rights reserved.Databaseinstance 1Databaseinstance 2Cisco Confidential13

OEM 12c (12.1.0.1) Upgrade 2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential14

Why We Decided To Upgrade To OEM 12c?Foundation for future Cisco roadmap Database as a Service GoldenGate monitoring Ebiz Fusion & FMW monitoring Database upgradePatching Benefits Create single MOS patch plan, roll across multiple databases 11g database patchingMOS integration Single-click SR creation Incident packaging service Merge patch requestMonitoring and Administration Monitoring of scan listeners Centralized Audit Vault Configuration of standbyDBs12c features Chargeback Real-time ADDM Incident management console Auto discovery of targets 2010 Cisco and/or its affiliates. All rights reserved. Increased productivity Reduced costCisco Confidential15

OEM 12c Upgrade – High Level PlanOneSystem 2010 Cisco and/or its affiliates. All rights reserved.TwoSystemCisco Confidential16

OEM 12c – Upgrade Timelines2012Feb-May2012Jun-AugPOCSTAGE& PROD2 2010 Cisco and/or its affiliates. All rights reserved.2012Jul-SepPROD1263 Man hours ofeffort for PRODupgrade(360 agents)64% less efforts inPROD than STAGEdue to thoroughplanningCisco Confidential17

OEM 12c Upgrade – Single System (Same Hardware)XTargets10gDeploy 12c agentsSwitchover to 12c agentsXem.cisco.comem.cisco.comXXBackup & shutdown 10gOMSUpgrade DB to 11gOEM DB10g RAC10grepositoryXBefore Upgrade 2010 Cisco and/or its affiliates. All rights reserved.Targets12cOEM DBInstall 12c OMS& upgrade repository to 12cStart 12c OMS and accept12c agents11g RAC12crepositoryAfter UpgradeCisco Confidential18

OEM 12c Upgrade – Single System (Same Hardware)XTargets10gDeploy 12c agentsSwitchover to 12c agentsXem.cisco.comem.cisco.comXBackup & shutdown 10gXCisco did OMSnot choose thisapproach due to long outagefor EMUpgrade DB to 11gOEM DB10g RAC10grepositoryXBefore Upgrade 2010 Cisco and/or its affiliates. All rights reserved.Targets12cOEM DBInstall 12c OMS& upgrade repository to 12cStart 12c OMS and accept12c agents11g RAC12crepositoryAfter UpgradeCisco Confidential19

OEM 12c Upgrade – Two System (Different Hardware)XTargets10gXem.cisco.comXXOEM DB10g RAC10grepositoryXBefore Upgrade 2010 Cisco and/or its affiliates. All rights reserved.Deploy 12c agentsClone and upgraderepository DB to 11gTargets12cem12c.cisco.comInstall 12c OMS & upgradeEM repository to 12cStart 12c OMS & DeferredData Migration JobIncremental switchover to12c agentsShutdown 10g OMS andDBOEM DB11g RAC12crepositoryAfter UpgradeCisco Confidential20

OEM 12c Upgrade – Two System (Different Hardware)XTargets10gXem.cisco.comDeploy 12c agentsClone and upgraderepository DB to 11gTargets12cem12c.cisco.comInstall 12c OMS & upgradeXXOEM DB10g RAC10grepositoryXBefore Upgrade 2010 Cisco and/or its affiliates. All rights reserved.Cisco chosethis approach forEM repository to 12cPRODStart 12c OMS & DeferredData Migration JobIncremental switchover to12c agentsShutdown 10g OMS andDBOEM DB11g RAC12crepositoryAfter UpgradeCisco Confidential21

Why Cisco Chose Two-System Approach?No downtimeEarlier OMSupgraderequired outageIncremental agent switchoverEasy fallbackConsider following before choosing 2 system approach:Additional H/W neededAdditional firewall ports may need to beopened for agents 2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential22

Post Upgrade StepsPost Upgrade ConsoleDeferred datamigration 2010 Cisco and/or its affiliates. All rights reserved.Accrued targetdata migration(2-system only)Diff reportsSign-off 10gagentsCisco Confidential23

Agent Home Location - Finding In POC ORACLE BASE & AGENT HOME was using same directory in 10g Deployment of 12c agents on same directory failed due to existing 10gAgent Home Created a sub-directory in 10g Agent Home and 12c agents installed Deleting old agents (post upgrade) wiped out both 12c & 10g Agent HomesPointed ORACLE BASE and AGENT HOME to different directoriesNever install agent inORACLE BASE 2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential24

Best racticeBestPracticeBestPracticeBestPractice 2010 Cisco and/or its affiliates. All rights reserved.Use current version with latest patch bundleReview documents and plan upgradeNever use same directory for ORACLE BASE & ORACLE HOMEAlways use central oraInventory including Agent HomeCentral oraInventory should not reside in Agent HomeVerify and validate target status in pre-upgrade consolePerform test rounds before production upgradeCisco Confidential25

Upgrade TipsDisable status notification rule before agent switchover in 10gIssueAgent status change in 10g triggers multiple false notificationsConfigure java env variable to use different mount point as tmp (only if /tmp 2GB)IssueAdditional OMS deployment procedure fails due to lack of space in /tmpStage the plugins for enabled target types onlyIssueOMS repository upgrade failed for missing EBS targetsSign-off only 25 agents at a time if on 12.1.0.1, Fixed in 12.1.0.2IssueSign-off job errors out for larger batches during post upgrade 2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential26

Upgrade/Post-Upgrade ngeSolutionChallengeSolution 2010 Cisco and/or its affiliates. All rights reserved.LegendFixed in 12.1.0.2Cisco Confidential27

What Functional Testing We Did?Load balancingPatch automationUser Defined Metrics (UDM) (OS/SQL)EM alerts and maintenance jobsCustom notification scriptORA errors alert generation (8i/9i/10g/11g)Tablespace alert generationAgent install procedureReview the Role DBA privilegesAll monitoring and DB performance pages 2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential28

What Functional Testing Did We Miss? 2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential29

Wow Factors Of EM 12c UpgradePre/Postupgradeconsole 2010 Cisco and/or its affiliates. All rights reserved.Mass agentdeploymentNodowntimeduringupgradeLuxury ofnot working24/7 forupgradeAutoremoval ofPre-NGAgentCisco Confidential30

OEM Future Roadmap 2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential31

OEM - Looking Into The FutureDatabase as a ServiceHA For OEMDR For OEMCrons Lights-outFMW/SOA Monitoring 2010 Cisco and/or its affiliates. All rights reserved.Database UpgradesCorrective ActionsIntegration WithTicketing SystemERP MonitoringCisco Confidential32

EM12c Maximum Availability ArchitectureAgentsAgentsGlobal Site Selector (GSS)MVDCDRLoad BalancerACEACEActiveOMSActiveOMSS/W LibraryReplicationActiveOMSActiveOMSACES/W ase Databaseinstance 1 instance 2 2010 Cisco and/or its affiliates. All rights reserved.RedoShippingDB ReposDB ReposRCDN DCAllen DCDB ReposRTP1 DCCisco Confidential33

EM Team @ CiscoManager Ravi Ammamuthu (rammamut@cisco.com)Architect Sarayu Damodaran (sardamod@cisco.com)Technical Team S Venky Sadagopan (svsadago@cisco.com) Pascal Laporte (plaporte@cisco.com) Manickaraja Kumarappan (mkumarap@cisco.com) Vikram Dodiya (vdodiya@cisco.com) Venkat Kiran Gunturi (vgunturi@cisco.com)PM Meena Chanda (mechanda@cisco.com) 2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential34

ReferencesUpgrade Guidehttp://docs.oracle.com/html/E22625 09/toc.htmBundle Patch 1 Application Guidehttp://docs.oracle.com/cd/E24628 01/doc.121/e35229/toc.htmAdvanced Installation and Configuration Guidehttp://docs.oracle.com/html/E24089 15/toc.htm 2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential35

2010 Cisco and/or its affiliates. All rights reserved.Cisco Confidential36

Coming Up Next .Thursday, Oct 4 2:15 PM - 3:15 PMMoscone West - 3018Thank You

OEM 12c Upgrade - Two System (Different Hardware) em.cisco.com. OEM DB. 10g RAC. 10g repository. Targets 10g. Targets 12c. em12c.cisco.com. OEM DB. 11g RAC. 12c repository. Deploy 12c agents. Clone and upgrade repository DB to 11g. Install 12c OMS & upgrade EM repository to 12c. Start 12c OMS & Deferred Data Migration Job. Incremental .

Related Documents:

Oracle SOA Suite 12c Oracle Cloud Control 12c Oracle OSB 12c y Consulting Architecture Analysis and Development Testing and Production Support Infrastructure and Tuning Application Maintenance Technology Oracle BPM 12c Oracle SOA 12c OAG 12c OER 12c Oracle Virtual Directory Oracle Identity Manager

Direct Upgrade to Oracle Database 12c A direct upgrade is one where either the Database Upgrade Assistant (DBUA) or command-line upgrade script is used to upgrade your database to Oracle Database 12c. Direct upgrade is supported when the source database is running one of the releases shown in the following table: TABLE 1.File Size: 545KBPage Count: 23

Harshita Mruthinti Kamath 04C 14G, Hindu Nabil Ahmed Jaffar 12C, Islamic Ariel Wolpe 12C, Jewish Alma Mater Jacob Light 12C Rashon Murrill 10OX 12C Collin Shepard 14C Benjamin Sperling 12C Michael Tseng 12C Recessional Atlanta Symphony Brass Quintet Guests are asked to plea

OEM: ZF Model: EC10/11/12/14 OEM: ZF ERF Model: ECS OEM: ZF Extended Input Power Steering Boxes 15 Contact us now / 01692 406017 / sales@pss.co.uk / www.pss.co.uk Model: TRIDENT OEM: ZF ERF Model: E/EC SERIES OEM: ZF Long Input Model: EC/ECX OEM: ZF Model: LANCE OEM: ZF Long Input 655010 8095 955 140 Vehicle Part No. PSS Part No.

PRECISION Spec SheetSpec Sheet XE OEM-Ready Industrial OEM equipped Meeting OEM requirements off-the-shelf with OEM-Ready, unbranded platforms, OEM XE longevity, stability and visibility and OEM Industrialized attributes with extended operating temperatures* making it an ideal edge solution. OEM XE Sharpen your competitive edge. Focus on

NI USB-621x OEM M Series USB-6211/6212/6216/6218 OEM Devices This document provides information about the dimensions, mounting options, connectors, and other components of the National Instruments USB-6211 OEM, USB-6212 OEM, US B-6216 OEM, and USB-6218 OEM devices. It also explains how to modify the USB device name in Microsoft Windows.

ORACLE DATABASE UPGRADE MOHAMMAD SHOAIB ANSARI Page 2 of 37 Oracle database upgrade steps can be summarised as follows 1. PRE-REQUISITES a. Check Database Upgrade Certification Matrix b. Check OS Certification Matrix c. Oracle 19c Binaries Installation for Upgrade d. Oracle 12c Database RMAN Backup e. Check For Invalid Objects f.

Artificial intelligence (AI) in healthcare and research. RECENT INTEREST IN AI AI is not new, but there have been rapid advances in the field in recent years.This has in part been enabled by developments in computing power and the huge volumes of digital data that are now generated.5 A wide range of applications of AI are now being explored with considerable public and private investment and .