1 / 29

Database Software Currency Using EM 12c Provisioning and Patching

Gary Henderson. Database Software Currency Using EM 12c Provisioning and Patching. About Me. Nationwide employee for 22 years Application Programming background Joined DBA Team at the beginning of 2000 EM Administrator since 2008 ( 10g ) EM 12c Early Adopter

bradley-mcpherson
Download Presentation

Database Software Currency Using EM 12c Provisioning and Patching

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Gary Henderson Database Software CurrencyUsing EM12cProvisioning and Patching

  2. About Me • Nationwide employee for 22 years • Application Programming background • Joined DBA Team at the beginning of 2000 • EM Administrator since 2008 (10g) • EM12c Early Adopter • NW Champion of EM Provisioning and Patching

  3. Nationwide Insurance and Financial Services Company Fortune 100 Company Founded in 1925 34.5 Billion in Revenues 171 Billion in Assets 33,000 Employees 26 core DBAs with combined 410 years DBA experience

  4. Agenda • Why software currency is important • Current Configuration State • Patching • Traditional - OPatch • With EM – In Place • With EM – Out of Place • Provisioning • Maturity Stages • Nationwide Experiences • Success • Challenges • Future • Questions

  5. Database Software Currency • Why software currency is important to us ..at Nationwide • Availability • Security • Efficiency • Stability

  6. Current Situation -- Versions

  7. Current Situation -- Configuration

  8. Enterprise Manager 12c Deployment Architecture

  9. EM12c Monitoring & Management – Current Target Availability

  10. Patching (Classic) • Find the proper patch(s) • Download • Stage the patch(s) on target server • Unzip patch(s) • Upgrade Opatch • Analyze patch(s) for conflicts • Schedule Downtime • Blackout targets (databases & listeners) • Bring down database(s) & listener(s) • Apply patch(s) • Process post upgrade steps (if any) • Start database(s) & listener(s) • End Blackout

  11. Patching with EM12c – My Oracle Support Integration

  12. Patching with EM12c – Patch Selection

  13. Patching with EM12c – Create New Plan & Pick Target

  14. Patching with EM12c – Plan Information

  15. Patching with EM12c – Specify Patches

  16. Patching with EM12c – Deployment Options

  17. Patching with EM12c – Specify Credentials

  18. Patching with EM12c - Analyze

  19. Patching with EM12c – Execution Status,Logs

  20. Complex Configuration – Real World example

  21. Lifecycle of an Oracle Home – Out of Place patching Oracle Home Oracle Home + PSU DB 1 DB 2 DB 1 DB 2 DB 3 DB 3

  22. EM12c Provisioning

  23. Crawl … Walk … Run … Fly In-place patching via EM12c Some provisioning of Database homes Some provisioning of Cluster Ready Services (CRS) Out of place patching of database homes Gold Copies for each unique configuration Leveraging templates and profiles All provisioning via EM12c Patch frequency increased to semiannual or quarterly Utilizing Change Activity Planner Cloud Provisioning

  24. EM12c Provisioning – Lessons Learned - Success • Test EM12cpatches/upgrades • Oracle Home and inventory verification (especially for Veritas) • Sticking with Oracle (RAC) vs other Clustering (Veritas) • Having a dedicated EM12c team (we have 2 people) • Global Credentials • Maintain currency with EM12c and database codebase • Extensive testing of provisioning and patching

  25. EM12c Provisioning – Lessons Learned - Challenges • Initial /tmp space too small • Assign to single person • Tried to implement prior to proper training • Entrenched DBA team with decades of experience • New approach to one-off patches • “Configuration Pollution”

  26. EM12c Provisioning – Future • Leverage Patch templates more • Leverage Provisioning Profiles more and better • Integrate • Patch Levels • Gold Copies • Patch templates • Change Activity Planner • Attempt the 100% provisioning goal • Accelerate the patching cycle • Develop Cloud Proof of Concept

  27. EM12c Lifecycle Management Pack • Configuration Management • Compliance • Change Management • Patching • Provisioning Prerequisite to Cloud Provisioning • Features used currently at Nationwide

  28. Summary:Recognition:Questions???

  29. Other Sessions:HOL9532Achieving Standardization with Oracle Enterprise Manager Database Lifecycle Management

More Related