Oracle Enterprise Manager Cloud Control 12c

1. Oracle Enterprise Manager Cloud Control 12c Top 10 Features for DBAs Leighton L. Nelson

2. About Me @leight0nn • Oracle DBA for 10+ years • Oracle ACE • Oracle Certified Expert: RAC and Grid Infrastructure 11gR2 • Co-Author Expert Oracle Enterprise Manager Cloud Control 12c – Apress 2013 • Oracle RAC SIG US Events Chair/IOUG Liaison

3. Company Information • Sixth largest Catholic health care system in the U.S. • Serves more than 3 million people annually. • Highly integrated organization that includes 32 hospitals, 300 outpatient locations, 39,000 co-workers and 1,700 integrated physicians in Arkansas, Kansas, Missouri and Oklahoma. • Among 10 percent of health care organizations nationwide to have a comprehensive, integrated electric health record that provides real-time, paperless access to patient information • MyMercy, a free service, allows patients to connect online with their doctors, plus see medical information, view test results, renew prescriptions an schedule appointments using a personal computer or smart phone • Health Information and Management Systems Society, a global leader in health care technology, designated Mercy a stage six of a seven-stage process, joining the ranks of health care leaders such as Johns Hopkins and Mayo Clinic • $60 million data center provides fail-safe protection and power. When an EF5 tornado struck Mercy's Joplin facility in 2011, patient records electronically backed up at offsite data center were immediately available • Mercy SafeWatch, the largest electronic ICU in the nation, provides 24-hour vigilance to critically ill patients. Alongside on-site medical teams, high-definition cameras and sophisticated technology allow specialized ICU physicians and nurses in a central command center to expand each patient's care team

4. Agenda • New Features Overview • Top 10 Database Features • Database Lifecycle Management • Real-Time Database Operations • EMCLI • ASH Analytics • Backup & Recovery • Pluggable Database Support • Compare Period ADDM • Real-Time ADDM • DBaaS • Extensibility

5. New Features Overview • What’s in the box?

6. New Features Overview Lots of new stuff. Login page highlights some key features plus new features.

7. New Features Overview 12.1.0.3 • Pluggable database support • Provision • Plug/Unplug • Clone • Advanced EMCLI • Scripting option • JYTHON • Change Activity Planner • Configuration Management • Compliance Management • Automation

8. 1/ Database Lifecycle Management • Database Patching & Updates • Manual patching is time consuming and confusing • PSUs/CPUs • One-offs • Opatch • Error Prone

9. 1/ Database Lifecycle Management • Database Upgrades • Upgrades can be scary • Pre-requisites • Backups • Down-time • Cross-fingers

10. 1/ Database Lifecycle Management • Database Patching & Updates • Use Patch Plans • Out of Place Patching support • Integrates with MOS

11. 1/ Database Lifecycle Management

12. 1/ Database Lifecycle Management • Database Patching & Updates • 5 Step Process to patch many DBs • Patch Description • Select the patches to apply and the targets • Deployment options • Patch Validation & Analysis • Review and Deploy • More automation with EMCLI • emcli submit_patch_plan

13. 2/ Real-Time Database Operations Monitoring • Simple Statements • SQL Monitoring • PL/SQL Monitoring • Composite Database Operations • Enabled by default when STATISTICS_LEVEL=TYPICAL/ALL • Define DB Operation • DBMS_SQL_MONITOR.BEGIN_OPERATION • DBMS_SQL_MONITOR.END_OPERATION 12c

14. 2/ Real-Time Database Operations Monitoring • SQL Monitoring

15. 3/ EM Command Line Interface • Turbo charges EM! • Enables Script Automation • Install from OEM Console • Standard or Advanced with Scripting Option

16. 3/ EM Command Line Interface

17. 3/ EM Command Line Interface • emcli help • emcli verb help

18. 4/ ASH Analytics • Multi-dimensional view of ASH data • DB-Time Analysis • Top Activity + • Resize sample window • More dimensions • Load map tree

19. 4/ ASH Analytics

20. 5/ Backup & Recovery When I ask the sysadmins, “The backups are making it to tape, right?” -DBA Reactions

21. 5/ Backup & Recovery • RMAN Backup • Target-based RMAN backup • Wizard-driven interface • Oracle-Suggested or Customized Backup • Job System based RMAN backup • Use existing RMAN scripts • Group Backups using deployment procedure • Backup multiple databases, homes and filesystems in a single operation

22. 5/ Backup & Recovery

23. 6/ Pluggable Database Support • Oracle Multi-tenant support • Pluggable databases (PDB) • Container databases (CDB)

24. 7/ Compare Period ADDM “Why is the database slower today than yesterday?” Compares database activity over two periods of time

25. 8/ Real-Time Automatic Database Diagnostics Monitor • Real-Time ADDM • Analyzes hung or very slow DB • Finds sources of contention • Performs DB Time Analysis • Uses 2 connection modes • Normal JDBC connection • Latch-less connection • Enhanced Real-Time ADDM 12c

26. 8/ Real-Time ADDM Real-time ADDM Active Reports

27. 9/ ‘C’ is for Cloud • Database-as-a-Service “I promised management that we’d get the project rolling today. Is the database ready?” “What database?”

28. 9/ Database-as-a-Service • DBCA Template • RMAN Backup • Storage Snap Clone (NetApp/Sun ZFS)

29. 9/ Database-as-a-Service • Database-as-a-Service

30. 9/ Database-as-a-Service • Database-as-a-Service

31. When the SAN admin says, “Nah, nothing changed recently.”

32. 10/ Extensibility (3rd Party Plug-ins) • VMware Plug-in (Blue Medora) • Storage Plug-ins • NetApp • EMC VMAX • Amazon AWS Plug-in

33. 10/ Extensibility (3rd Party Plug-ins)

34. There’s more… • Corrective Actions • Metric Extensions • Job System • Incident Management • Administration Groups • Configuration Search • Compliance Standards

35. Thank You • Questions?

36. Contact Information http://blogs.griddba.com linkedin.com/pub/leighton-nelson/4/6b8/a7a @leight0nn leighton.nelson@mercy.net