ORACLE ENTERPRISE MANAGER 12C: THE ORACLE MONITORING TOOL OF
CHOICEWhy you should care about the new architecture
and licensing
OEM 12C: WHO IS JEFF KAYSER?
‣ Oracle E-Business Suite DBA since 1989 (25 years now).‣ Has managed Oracle E-Business Suite since version 6.‣ Has managed Oracle Databases since version 5.‣ DBA for E-Business Suite 9 Beta and 10 Alpha at Sequent.‣ First 10.7 NCA implementation in the world at Nike.‣ RMAN 8.0 implementation and EBS upgrades at OHSU.‣ Lots of stuff at Jibe, including managing DBAs who oversee all our
Managed Services customers.‣ Technical DBA lead (“Give it to Jeff. He’ll figure it out.”)‣ Uses OEM every day to monitor and manage our customers’
systems.
Jibe & Client Confidential
JIBE AT-A-GLANCE
Established: 2004
Employees: 175+
Customers: 225+ Over 1000 Projects
Industry Focus: Retail, Manufacturing (process, industrial, & high tech), Consumer Products, Oil & Gas, Engineering and Construction, Life Sciences, Healthcare, Software and Clean Technologies.
Principal Business Areas:
Management Consulting Technology Consulting
• Business & IT Alignment Strategy • Implementations & Upgrades
• Application & Technology Roadmaps • Application Process Optimization
• Lean Enterprise Process Analysis & Design • Training
• Program / Project Management • Staff Augmentation
• Information Management & Business Intelligence
• Managed Services & Cloud Offerings
OEM 12C: OVERVIEW
Huge number of new features More features not requiring a license New architecture – Wow! Installation New user interface and menus Pluggable target types New security model ITIL-like event management Best practices for implementing
OEM 12C: 108 PAGES OF NEW FEATURES…
‣OEM 12c is basically a new product.‣Some of what you know about OEM will still be useful.‣At Jibe, we use OEM every day to monitor our clients.‣ I have 7 years experience working with OEM.‣OEM 10g‣OEM 11g‣ . . . but . . .‣OEM 12c is WAY DIFFERENT…
OEM 12C: LICENSING CHANGES
‣ Oracle® Enterprise Manager Licensing Information‣ 12c Release 4 (12.1.0.4), E24474-32‣ Chapter 10 Base Enterprise Manager Functionality
• “The base installation of Enterprise Manager Cloud Control 12c includes several features free of charge with the purchase of any Oracle software license or Support contract.”
• “The release of Oracle Enterprise Manager Cloud Control 12c makes several licensing changes. Some features that were part of licensed packs are now included in the base functionality. This chapter outlines the list of features that are included with the base functionality of Oracle Enterprise Manager…”
• Use it to help manage the Oracle products you have already licensed.
OEM 12C: ADD-ON MANAGEMENT PACKS(SAMPLE BELOW -- THERE ARE LOTS MORE…)
Named User Plus
Software Update License and Support
Processor License
Software Update License and Support
Database Enterprise Management
Diagnostics Pack 150 33.00 7,500 1,650.00
Tuning Pack 100 22.00 5,000 1,100.00
Database Lifecycle Management Pack 240 52.80 12,000 2,640.00
Data Masking and Subsetting Pack 230 50.60 11,500 2,530.00
Cloud Management Pack for Oracle Database 100 22.00 5,000 1,100.00
OEM 12C: LICENSING SUMMARY…
‣ Check out what’s included in the base platform. You may be pleasantly surprised.
‣ Figure out which functionality requires add-on packs:• Setup => Management Packs => Show Management Pack Information.
It will tell you which features are enabled by which packs.• Turn off packs that are not licensed. OEM will grey out the features not
included in the base platform.
‣ The Diagnostic Pack is pretty basic and important:• Enables detection of blocking locks.• Enables you to create custom metrics.
‣ The Tuning Pack enables some truly awesome tuning capabilities.
OEM 12C: INSTALLATION: PREP WORK…
‣ Obtain your servers (or create your VMs)‣ Install all the appropriate OS packages‣ Build staging area for Oracle software‣ Install the Oracle Database software
• RDBMS 12.1.0.x not yet supported for repository
‣ Run netca to create a listener‣ Run dbca to create a database‣ Run EMCA to delete the seeded OEM repository‣ Launch the OEM 12c installer…
OEM 12C: SHAMELESS PLUG: WHY CHOOSE JIBEJibe is a management and technology consultancy that specializes in driving business results through process automation.
Our team of Industry experts assist our clients in delivering mission critical projects with predictable results. With over 1000 Oracle projects under our belt our clients come to expect high performance teams that contribute to their success. At Jibe, it is
not just about the technology, but how the technology allows our clients to achieve their operational objectives.
Management & Technology Consulting
Pacific Northwest ~ Rocky Mountain Region ~ California ~ Western Canada
5000 Meadows Road Suite 300Lake Oswego, OR 97035
503.274.0788
127 Bellevue Way SE. Suite 108 Bellevue, WA 98004
425.457.7461
4600 S. Syracuse 9th FloorDenver, CO 80237
720.213.6566
OEM 12C: NEW MENU HIERARCHY
‣ I was going to screenshot some of the new menus, but there is a better way…
Help => Sitemap
OEM 12C: NEW MENU HIERARCHY
‣Navigate: Help => Sitemap.‣Choose where you want to go.‣Click on the link.‣Voila! You are there.
‣P.S. Using the Sitemap will help you learn the layout of the new menus.
OEM 12C: PLUGGABLE TARGET TYPES
‣ The previous architecture of the OEM 12c made it difficult to add additional target types, because the logic for the common target types was bundled into the agent.
‣ Oracle has split out the different parts of the OEM agents into separately-installed ORACLE_HOMEs.
‣ When you install an OEM agent on a server, OEM installs a number of ORACLE_HOMEs behind the scenes, depending on the target types you want to monitor/manage.
OEM 12C: LOGIC FOR EACH TYPE OF TARGET IS INSTALLED IN IT’S OWN ORACLE_HOME
‣ [oem12c@oem12cr4 ~]$ cd /u01/oem12c/fmw/plugins‣ [oem12c@oem12cr4 plugins]$ ls -d oracle*‣ oracle.sysman.cfw.oms.plugin_12.1.0.1.0‣ oracle.sysman.db.oms.plugin_12.1.0.6.0‣ oracle.sysman.emas.oms.plugin_12.1.0.6.0‣ oracle.sysman.mos.oms.plugin_12.1.0.6.0‣ oracle.sysman.xa.oms.plugin_12.1.0.6.0‣ [oem12c@oem12cr4 plugins]$
OEM 12C: EXTENSIBILITY EXCHANGE
http://www.oracle.com/goto/emextensibility
OEM 12C: DON’T SEE A PLUGIN FOR SOMETHING YOU WANT TO MONITOR AND MANAGE?
Oracle® Enterprise Manager Cloud Control Extensibility Programmer's Guide12c Release 4 (12.1.0.4)E25159-10(PDF: 76 pages)
Oracle® Enterprise Manager Cloud Control Extensibility Programmer's Reference12c Release 4 (12.1.0.4)E25161-15(PDF: 932 pages)
OEM 12C: EVENTS, INCIDENTS, AND PROBLEMS, OH MY!
‣ Event: • A change of state that has significance for the management of an IT
service or other configuration item. The term is also used to mean an alert or notification created by any IT service, configuration item or monitoring tool.
‣ Incident:• An unplanned interruption to an IT service or reduction in the quality of an
IT service. Failure of a configuration item that has not yet affected service is also an incident.
‣ Problem:• A cause of one or more incidents. The cause is not usually known at the
time a problem record is created, and the problem management process is responsible for further investigation.
OEM 12C: INCIDENT MANAGEMENT: TICKET CREATION
See: 3.4.6.3 Creating a Rule to Create a Ticket for Incidents
Large number of pre-defined connectors:
OEM 12C: CLOUD CONTROL: ONLINE RESOURCES
‣ http://www.slideshare.net/OTNArchbeat/cloud-management-with-oracle-enterprise-manager
‣ https://blogs.oracle.com/zerotocloud/entry/amazon_web_services_aws_plug
‣ http://www.oracle.com/technetwork/oem/cloud-mgmt/wp-em12c-public-cloud-1907213.pdf
OEM 12C: BEST PRACTICES: READ THE FREE MANUALS
‣Actually, there is so much that is new, that you won’t understand how to configure or use OEM 12c unless you spend time reading the manuals or going to OEM 12c training.
‣Read the 108 pages of new features. You can’t use it if you don’t know that it exists.
OEM 12C: BEST PRACTICES: READ THE FREE MANUALS
‣ Some areas of OEM 12c where there are significant changes:• Groups: Groups, Dynamic Groups, Administration Groups.• Security. Lots of new roles, and a new role hierarchy.
• You need to know what the new roles do.
• Security. New credential system. Incredibly great! Know how to use.• Incident Management, Incident Rules, and Notifications.• Metrics Extensions. Way different than the old UDMs and much, much
better.• The Software Library. Keep OEM 12c up-to-date.• The compliance system is completely new. Thank goodness.• Provisioning and Patching.
OEM 12C: WHY SHOULD I READ THE FREE MANUALS?
‣Dynamic Groups: You can define a group based on target criteria, and OEM will automatically determine members (e.g. all DBs of version 11.2.0.4), and then run a job against members of that group.
‣Administrative Groups: Like Dynamic Groups, but hierarchically organized. You can have monitoring templates automatically applied when OEM determines that a new target is a member of that Administrative Group.
OEM 12C: WHY SHOULD I READ THE FREE MANUALS?
‣New OEM CLI functionality: As of 12.1.0.3, there is now an interactive interpreter. Wow! Jython is the scripting engine for EM CLI scripts. Wow! Access the repository views from your EM CLI Jython scripts. Wow! Create super awesome Jython scripts to manage your environments. Impress your friends (and your employer) with your Java/Python skills.
‣Some functionality not available from console: There is some OEM 12c functionality that is only available via the CLI.
OEM 12C: WHY SHOULD I READ THE FREE MANUALS?
‣ If you find yourself struggling to do something with OEM 12c, or think some task is way too labor intensive, RTFM.
‣Remember: Oracle Corporation uses OEM 12c to manage many, many (hundreds? thousands?) of Oracle environments. They are very concerned about the scalability of administrative tasks.
OEM 12C: BEST PRACTICE: EXPERIMENT!
How else are you going to learn the nuances of
how it really works?
OEM 12C: BEST PRACTICE: EXPERIMENT!
‣You should probably have an OEM 12c available for testing. It should be completely separate from your production OEM 12c environment.
‣You can run multiple agents on a single server, but I would not recommend that.
‣Have a DEV, TEST, and PROD OEM 12c install.‣Connect your DEV environments to the DEV OEM.‣Connect your TEST environments to the TEST OEM.‣Connect your PROD environments to the PROD OEM.
OEM 12C: SOME THINGS WE’VE LEARNED
‣ Pay careful attention to the database requirements before installing OEM 12c. There are some very specific setups required.
‣ IMPORTANT: Adopt a naming convention for credentials.• Example: NC_<TARGETTYPE>_<TARGETNAME>_<USER>• You will be managing lots of credentials.
‣ Credential scope: global or target specific. (You didn’t mean that password to be used EVERYWHERE, did you?)
‣ Get to know the repository views. Lots of great information there, all waiting to be extracted by you. Will require SQL knowledge .
‣ Use monitoring templates to gain consistency in monitoring.‣ If you use the OEM 12c job scheduler (instead of cron), you can
consolidate your alerting and notification.
WHY COMPANIES CHOOSE JIBEJibe is a management and technology consultancy that specializes in driving business results through process automation.
Our team of Industry experts assist our clients in delivering mission critical projects with predictable results. With over 1000 Oracle projects under our belt our clients come to expect high performance teams that contribute to their success. At Jibe, it is
not just about the technology, but how the technology allows our clients to achieve their operational objectives.
Management & Technology Consulting
Pacific Northwest ~ Rocky Mountain Region ~ California ~ Western Canada
5000 Meadows Road Suite 300Lake Oswego, OR 97035
503.274.0788
127 Bellevue Way SE. Suite 108 Bellevue, WA 98004
425.457.7461
4600 S. Syracuse 9th FloorDenver, CO 80237
720.213.6566