My Backup DBA - Oracle Configuration Manager on My Oracle Support

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_at_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
• CPUs and PSUs 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

• Download patch then
• Install.if conflict then
• Check if any key patches rolled backif rolled
  then.
• Merge request..then
• Wait.might be too late for this CPU, narrow
  window.maybe next quarter!

• Patch Plan
• Auto checks prerequisites
• Checks Conflicts before downloading
• Request Merge before downloading
• Check Recommendations
• Deployment Plan Available

14
MOS V3.2 Addressing DBAs Needs
No download or install, merge request might
already be available, one click request, no SR.
Patch planMaintenance 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

• Oracle Configuration Manager and My Oracle Support

• No configurations Uploaded to Oracle

• 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 lt2. 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

• opatch ls inventory detail grep patchno
• Spreadsheet on a single desktop
• Perhaps uploaded to IT Wiki or Intranet
• Possibly no documentation

• 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

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
• Dont 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 isnt 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_at_suu.edu
• Presentation will be uploaded to BLOG