1 / 31

My Backup DBA - Oracle Configuration Manager on My Oracle Support

My Backup DBA - Oracle Configuration Manager on My Oracle Support. April Sims OCP 8i 9i 10g Southern Utah University. Submit an Article or become a Reviewer. select@ioug.org Contributing Editor. New Book Just Released. Personal Experience with My Oracle Support.

marcin
Download Presentation

My Backup DBA - Oracle Configuration Manager on My Oracle Support

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. My Backup DBA - Oracle Configuration Manager on My Oracle Support April Sims OCP 8i 9i 10g Southern Utah University

  2. Submit an Article or become a Reviewer select@ioug.org Contributing Editor

  3. New Book Just Released

  4. Personal Experience with My Oracle Support • Lone DBA at a University of 8,000 students • 110 Targets in Grid Control • All Targets have Configurations in My Oracle Support • Used Configurations since Alpha and Beta Release • Consider My Oracle Support …My Backup DBA as well as a Disaster Site Document Repository

  5. Oracle Configuration Manager • Manage automatic uploads to MOS • Viewable with same CSI number • Contains details about hardware, software, databases and application servers • GUI interface along with configurations provide a personalized visit to MOS • New Mass Deployment Utility for OCM deployment

  6. OCM Mass Deployment Utility • Version 3.2+ • Found on the MOS collector tab – Configuration Manager Repeater and Mass Deployment Tools • Find the OCM Companion Distribution Guide. • Edit csv template file to enter all servers • Executed on a single node with ssh access to entries in template

  7. OCM Install in Oracle Universal Installer

  8. RDA, Service Requests • Oracle Support Engineers use uploaded configuration • May still ask for an RDA output • Recommendation: Customize your RDAs to eliminate sensitive information

  9. 11g Diagnosability Framework • Support Workbench in OEM dashboard • Automatic Diagnostic Repository Utility – adrci • Package, upload problems or incidents • Integrated with OCM for the uploads

  10. Use OCM Securely • Use disconnected mode with Oracle Support Hub • Manual upload of a single node • Mask IP, MAC addresses, Schema usernames • Request deletion of configuration information

  11. GC 10g- Single EM Harvester instead of OCM collectors • Collecting and uploading configuration data to My Oracle Support • White paper – MOS Doc ID 848962.1 • Requires OMS 10.2.0.5, connected mode • Only need to install OCM in the OMS home, not all of the targets. • No database PL/SQL install required • Will work with older agents • Supported configurations – Hosts, ORACLE_HOMEs, Database, OAS

  12. Patching Issues Facing DBAs • Patch Conflicts – Rollbacks • No advance notification there is a Conflict • Troubleshooting Patch Application Failure • Hours needed to resolve a failure • CPU’s and PSU’s – conflicting • What to install when ? • Recommended Patches • Am I the first person to deploy this patch ? • Merge Requests • Am I the first person to request this Merge? • Documenting • Many ad-hoc vehicles to document install patches Based on polling DBAs on Oracle-L

  13. Issues with Conflicts and Rollbacks Without My Oracle Support With My Oracle Support Patch Plan Auto checks prerequisites Checks Conflicts before downloading Request Merge before downloading Check Recommendations Deployment Plan Available • Download patch then… • Install….if conflict then… • Check if any key patches rolled back…if rolled then…. • Merge request…..then • Wait….might be too late for this CPU, narrow window….maybe next quarter!

  14. MOS V3.2 Addressing DBAs Needs No download or install, merge request might already be available, one click request, no SR. Patch plan=Maintenance window No download or install needed Merge request may already be available if previously requested….not having to download would save bandwidth, time and wasted effort just to test for conflict.

  15. Troubleshooting Patch Application Failure No configurations Uploaded to Oracle Oracle Configuration Manager and My Oracle Support Fewer Patch Install Attempts Less Failures Less Time Wasted Less stumbling blocks to getting the patch process completed • Most nodes have unique patch history due to hardware rotations • Usually requires a Service Request • Completely manual process • May take weeks to resolve

  16. Recommended Patches No configurations Uploaded to Oracle Community and Oracle Recommended Patches Community Reviews - Customers Experience Download Statistics - Is it considered important? Upgrade Companion - Recommendations Listed Tested as a single unit - Targeted Configurations – Business Suite, Database, OAS • Manual Process • No patch plans available • Time Consuming • Patches are not diligently applied on a timely basis due to time and effort

  17. Bugs fixed by this patchSee download trends and community feedback SUU expects to save at least 50% of the time spent reviewing and deploying patches from 4 hours/week to <2. Moving to more secure model of patching consistently on a quarterly basis.

  18. Documenting Versions and Patches No Configurations Uploaded to Oracle Oracle Configuration Manager and My Oracle Support Patch Plans will contain all current information Configurations will also contain version information Requires a collector install then auto uploaded on a daily basis Not dependable yet • opatch ls inventory –detail | grep patchno • Spreadsheet on a single desktop • Perhaps uploaded to IT Wiki or Intranet • Possibly no documentation

  19. PSUs vs. CPUs Oracle Recommendations • Apply PSUs from now on (since DB Version 10.2.0.4) • Both CPU & PSU Released Quarterly • PSUs include CPUs • PSUs are a Superset of CPUs • Might need merge patch if migrating from a CPU • Don’t revert back to CPU once on PSU – this can be a insurmountable technical obstacle. http://blogs.oracle.com/gridautomation/

  20. OMS GC 11g Differences • GUI Flash-based • GC Integrated with My Oracle Support • Requires WebLogic Install

  21. OMS 11g - Still not officially available

  22. Note the Upgrade Option

  23. Kept with defaults

  24. Recommended or Required? Halts process if not installed. Partitioning License included with GC, no extra cost

  25. Take a snapshot of this screen for port assignment

  26. First Time OEM GC Login

  27. MOS tab on OMS11g GC console

  28. Different than normal MOS login – missing favorites?? Not sure why? Once supported I will enter an SR. Maybe the functionality just isn’t there yet.

  29. Nice red tag for remainder of session

  30. Agent Clone GUI Interface

  31. Questions?? • Leave Business Card – put question or interest on back. • Linked In • Twitter http://www.twitter.com/aprilcsims • BLOG http://aprilcsims.wordpress.com • sims@suu.edu • Presentation will be uploaded to BLOG

More Related