Oracle Enterprise Manager Cloud Control 13c for DBAs

ORACLE ENTERPRISE
MANAGER CLOUD
CONTROL 13C FOR DBAS
GOKHAN ATIL

INTRODUCTION
GOKHAN ATIL
▸ DBA Team Lead with 15+ years of experience
▸ Oracle ACE (since 2011)
▸ 10g/11g and R12 OCP
▸ Founding Member and Vice President of TROUG
▸ Co-author of Expert Oracle Enterprise Manager 12c
▸ Blogger (since 2008) gokhanatil.com
▸ Twitter: @gokhanatil
2

INTRODUCTION
AGENDA
▸ Introduction to Enterprise Manager EM13c
▸ Why Enterprise Manager Cloud Control?
▸ Top Features for DBAs
▸ How to Start Using EM13c
▸ Maintaining Enterprise Manager
3

INTRODUCTION TO EM13C
WHAT IS ENTERPRISE MANAGER CLOUD CONTROL?
▸ Enterprise Manager Cloud
Control provides a centralized
monitoring and management
platform for IT infrastructure.
▸ Enterprise Manager can manage
and monitor various targets (host,
ASM, RAC, Database, Listener,
Weblogic, Tomcat, Apache and
more), and it’s possible to add
more target types using plugins.
5

ENTERPRISE MANAGER CLOUD CONTROL ARCHITECTURE
▸ Agents: Collect monitoring
and configuration data from  
the targets and executes
tasks
▸ Management Server (OMS):
Receives and processes
data from Agents, Provides
UI and Target Specific
Management
▸ Repository (OMR):
Persistent store for data
collected from the
managed TargetsNotifications
Connectors
Console (web/cli)
Agent
Agent
Agent
Repository Management Server
6

SOFTWARE LIBRARY
Filesystem repository used to store software entities  
such as:
▸ Software patches
▸ Virtual appliance images
▸ Gold images
▸ Application software
▸ Deployment procedures
7

CONSOLE AND EM CLI
▸ Console: Rich, customisable 
application accessed through 
web browser. Primary  
interface for interactive  
management of targets.
▸ EM CLI: Enterprise Manager command line interface.
It’s used to manage targets from command line
without a browser.
8

WHY ENTERPRISE MANAGER?
WHY ENTERPRISE MANAGER CLOUD CONTROL?
▸ One tool to monitor and manage all Oracle databases
▸ Standardize and automate management tasks
▸ Produced by Oracle: Most comprehensive and up-to-date
management features for Oracle databases.
▸ Easy to maintain: Familiar components (Oracle products),
My Oracle Support
9

EXTENSIBLE ARCHITECTURE
▸ Enterprise Manager 12c redesigned as base platform and
extensible entities
▸ All target speciﬁc management encapsulated in target plug-ins
(e.g. DB plug-in)
You don’t need to wait next version of EM13 to support Oracle
DB 13c
▸ Solution Plug-ins provide additional vertical EM functionality
(Cloud Application Plug-in)
▸ Supports 3rd Party Plugins (MongoDB, PostgreSQL etc)
10

BASE FUNCTIONALITY IS FREE
▸ EM Self Management and Monitoring
▸ Agent Management
▸ EM Support Workbench + My Oracle Support integration
▸ Groups and Systems Management
▸ Information Publisher and Reporting
▸ Job System and Corrective Actions
▸ Alerts and Metric Threshold Management (excluding notiﬁcations*)
▸ Monitoring and Incident Management
11

BASE FUNCTIONALITY IS FREE
▸ Data movement
▸ Error management
▸ Grid Infrastructure management
▸ High availability
▸ Non-structured data management
▸ Object, program and initialization
parameters management
▸ Optimizer Management
▸ Patch Recommendations
▸ Pluggable Database (PDB)
▸ Resource Management
▸ Scheduler Central
▸ Security
▸ SQL Execution
▸ Space and Undo Management
▸ Support Workbench
▸ Upgrade Planner Workspace
management
12

BASE COMPONENTS DO NOT REQUIRE LICENSING
▸ Repository Database: Oracle Enterprise Edition
Dedicated to EM (+ AWR Warehouse), no data guard, no RAC
▸ Weblogic Cluster: Dedicated to Publisher and EM
▸ Oracle Business Intelligence Publisher and Business Intelligence
Mobile
▸ Oracle ZFS Storage Appliance Cloning is included with
Enterprise Manager Snap Clone (Oracle Cloud Management
Pack for Oracle Database)
13

TOP FEATURES FOR DBAS
ARE YOUR SYSTEMS UP AND RUNNING?
15

WHAT’S HAPPENING ON YOUR DATABASES?
16

METRICS, ALERTS AND INCIDENTS
PREDEFINED METRICS
+ METRIC EXTENSIONS
WARNING AND CRITICAL
THRESHOLDS
MONITORING TEMPLATE
TARGETGENERATES ALERTINCIDENT RULES
INCIDENT CREATED NOTIFICATION
tablespace usage
%75 warning 
%90 critical

MONITORING AND INCIDENT HANDLING
▸ Create a copy of the system default Incident Rule Sets.
The default rule sets are locked.
▸ Create monitoring templates, set critical metric values.
▸ Create groups. Assign monitoring templates to groups and
set different notiﬁcation types based on groups.
▸ Update all notiﬁcation so only critical alerting is
performed*. You use the EM Console to view non-critical
warnings
18

INCIDENT DASHBOARD
NEW ON
EM13C
19

CORRECTIVE ACTIONS
▸ Automate routine administrative tasks to resolve common
incidents
▸ Create a corrective action (OS command, SQL, RMAN
Script or EM actions such as start/stop agent)
▸ Assign the corrective action to a metric alert (on a
monitoring template)
▸ Apply the monitoring template to the targets
20

DATABASE PROVISIONING
Repeatable, reliable, automated, unattended deployment
procedures for creating, cloning, updating databases
LIFECYCLE
MANAGEMENT
PACK
21

PROVISIONING ORACHK
Install and set up ORAchk from the Enterprise Manager console
instead of the command line on individual hosts
22NEW ON
EM13C

DATABASE PATCHING
▸ Integrated patching workflow with My Oracle Support (MOS). EM can
recommend patches
▸ Complete, end-to-end orchestration of patching workflow using Patch Plans.
1. Create a Patch Plan
2. Select patches
3. Set the Deployment Options (Stage Location, Targets, Credentials)
4. Validation (Analyze)
5. Review and Deploy
Common issues: Directory/file permissions or disk space
23

ASH ANALYTICS
▸ Interactive version of
ASH Reports
▸ Select the dimensions,
drill down to undertake
a performance review
on a single page
▸ The report can be
saved (as HTML) or
mailed
DATABASE
DIAGNOSTICS
PACK
24

ASH ANALYTICS (MULTI DIMENSIONAL ANALYTICS)
Drill into a loadmap view to display the different waits indicating the importance
of each by the size of the box
DATABASE
DIAGNOSTICS
PACK
25

COMPARE PERIOD ADDM
Why is the database slow? Is it slower than yesterday?
DATABASE
DIAGNOSTICS
PACK
26

AWR WAREHOUSE
▸ Consolidation of AWR data
from multiple target databases
▸ Provides long term historical
information
▸ Requires Database version
11.2.0.4 or higher
▸ AWR data from source
databases moves as dump
ﬁles
27DATABASE
DIAGNOSTICS
PACK

EMERGENCY PERFORMANCE PAGE
EM Agent will connect directly to SGA to collect data when you navigate to Emergency Monitoring.
DATABASE
DIAGNOSTICS
PACK
28

REALTIME ADDM
Real-Time ADDM performs a complementary analysis, a root
cause analysis that Emergency Monitoring does not provide.
DATABASE
DIAGNOSTICS
PACK
29

HOW TO INSTALL
ENTERPRISE MANAGER CLOUD CONTROL SIZING
Minimum requirements, recommended to add much more
RAM to OMS.
Size
Agent
Count
Target
Count
OMS
Machine
Count*
Cores per
OMS
Memory
per OMS
(GB)
Database
Machine
Count
Cores per
Database
Machine
Memory
per DB
(GB)
Small < 100 < 1000 1 4 10 1 4 7
Medium
>= 100 
< 1000
>= 1000 
< 10,000
2 6 12
2 (Oracle
RAC)
6 10
Large >= 1000 >= 10,000 2 12 24
2 (Oracle
RAC)
12 18
31

HOW TO INSTALL
REQUIREMENTS FOR ENTERPRISE MANAGER 13.1.0.0
▸ You can perform fresh Install of EM 13.1.0.0 or upgrade
from (12.1.0.3, 12.1.0.4, 12.1.0.5)
▸ DB Repository version supported: 12.1.0.2
▸ Weblogic versions supported: 12.1.0.3
▸ JDK version supported: 1.7.0_80
▸ BI Publisher 12.1.0.3 integrated
32

HOW TO INSTALL EM13C
BEST PRACTICES FOR EM 13.1.0.0 INSTALL
▸ Download and install Oracle RDBMS 12.1.0.2 and use DB template to
create database
▸ Download the EM13c installer from OTN
▸ Do not unzip the binaries files. Just execute the
em13100_<platform>.bin file to invoke the installer
▸ Use EM installer to install WLS
Always refer to Official Install guide
Whenever you download a file from OTN, check if the file has correct
bytes/checksum values as displayed on OTN
33

HOW TO INSTALL EM13C
THE INSTALLER WILL HANDLE THE REST
34

POST INSTALL TASKS
INITIAL SETUP CONSOLE
After you install, visit Initial Setup Console to complete “recommeded”
post-install tasks.
35NEW ON
EM13C

POST INSTALL TASKS
MANAGEMENT PACK ACCESS
Disable auto licensing to prevent license violations.
36

DEPLOY AGENTS
DOWNLOAD AGENT SOFTWARE USING SELF UPDATE
You can download EM agents for Solaris, Linux, Windows, IBM AIX, HP-UX
37

DEPLOY AGENTS
DEPLOY AGENTS (ADD HOST TARGETS)
First deploy agents to hosts to convert them managed hosts, then add
targets running on the host (ASM, Listener, Database)
38

HOW TO BACKUP
BACKUPS
You need to back up following components:
▸ The Oracle Management Service: Filesystem backup of
installed software* and backup of OMS configuration:
$OMS_HOME/bin/emctl exportconfig oms
▸ The Management Repository: Backups can be taken using
RMAN
▸ The software library: Taking file system backups daily is
sufficient in most cases.
39

MAINTAINING ENTERPRISE MANAGER
40

HEALTH OVERVIEW
41

MANAGEMENT AGENTS
Start, stop, block, unblock, synchronise agents

IMPORTANT LOG LOCATIONS
▸ Management Server side:
EM_INSTANCE_BASE/em/EMGC_OMS1/sysman/log
EM_INSTANCE_BASE/user_projects/domains/GCDomain/servers/ohs1/logs
Various Logs/Trace ﬁles in a 12c OMS Installation (Doc ID 1448308.1)
▸ Management Agent side:
AGENT_INSTANCE_HOME/sysman/log
Understanding the Management Agent Logs Files (Doc ID
1386781.1)
43

KEEP YOUR ENTERPRISE MANAGER UP-TO-DATE
▸ Oracle Recommended Patches for Enterprise Manager Base Platform (MOS Doc
ID 822485.1 needs update)
▸ You need to use OPatch to patch OMS and the repository DB
▸ Database Recommended Patches (MOS Doc ID 756671.1)
▸ Keep your plugins and agents up to date using “Self-Update”
▸ Agents are patched via EM
▸ Create a patch plan, check for conﬂicts and deploy to a test server
▸ Create a gold image and use it to mass deploy
▸ Get to know EMDIAG Troubleshooting Kits Master Index (MOS Note 421053.1) -
hopefully they will be released for EM13c soon
44

THANK YOU FOR ATTENDING!  
ANY QUESTIONS?
45

Oracle Enterprise Manager Cloud Control 13c for DBAs

Recommended

Recommended

More Related Content

What's hot

What's hot (20)

Similar to Oracle Enterprise Manager Cloud Control 13c for DBAs

Similar to Oracle Enterprise Manager Cloud Control 13c for DBAs (20)

More from Gokhan Atil

More from Gokhan Atil (14)

Recently uploaded

Recently uploaded (20)

Oracle Enterprise Manager Cloud Control 13c for DBAs