Implementing OEM for the First Time

1
Implementing OEM for the First Time

• Gary Gelder
• Sr. Database Administrator
• Mirant Corporation
• Gary.Gelder_at_mirant.com

2
Agenda

• Pieces of the puzzle
• Preparation
• Installation
• Agent deployment
• Monitoring
• Q A

3
Pieces of the puzzle
Admin
Browsers
OMS
OMR
Software
OMA
Hardware
Targets
Free
4
Enterprise Manager Architecture
Application Server
Console (Browser)
EM Agent
Oracle Database
HTTP/S
Computer Host
EM Agent
JDBC
Oracle 10g
Management Service
Management Repository (Database)
Oracle 9i
EM Agent
Oracle 10g
Managed Targets
OMA
OMS
OMR
5
Oracle Management Repository (OMR)

• Oracle 10g database
• Includes objects belonging to SYSMAN
• Can be installed in a pre-existing database
• Can be configured to contain other management
  data
• Application server infrastructure database
• RMAN Catalog

6
Oracle Management Agent (OMA)

• Must be installed on each managed host
• Must be in its own ORACLE_HOME
• Communicates with OMS via HTTP or HTTPS
• Installed from OEM (pushed down to the host) or
  can be installed locally.

7
Enterprise Manager 10g Product (OMS)

• Enterprise Manager 10g Grid Control
• Oracles grid-ready framework, allowing IT
  professionals to manage the entire Oracle
  eco-system through one integrated management
  console.
• Enterprise Manager 10g Database Control
• Database Control is the front-end tool for
  managing a single instance of the 10g database or
  single cluster instance.
• Enterprise Manager 10g Application Server Control
• Oracles application server management interface
  built directly into the Oracle 10g application
  server infrastructure

8
Enterprise Manager 10g Database Control
The following are included for free

• Database Monitoring
• Health Status
• Host CPU
• Active Sessions
• High Availability Analysis
• Space Usage Summary
• Diagnostics Summary
• Alerts and Performance Analysis
• Database Administration
• Startup / Shutdown Database Server
• Database Schema Management
• Database Security Administration
• Storage Management
• Warehouse Management

• Scheduler
• Jobs
• Schedules
• Job Classes
• Windows, Window Groups
• Global Attributes
• Backup and Recovery
• Schedule Backup
• Perform Recovery
• Manage Current Backups
• Utilities
• Import / Export
• Make Tablespace Locally Managed

9
Enterprise Manager 10g Database Control
The following are licensable components

• Diagnostics Pack for Database
• Tuning Pack for Database
• Configuration Management Pack for Database
• Change Management Pack

10
Enterprise Manager 10gApplication Server Control
The following are included for free

• Application Server Monitoring
• Application Server Status
• AS Component Status (OC4J, OHS, Web Cache,
  Portal, Reports, Forms, Discoverer, Process
  Connect, etc.)
• Application Monitoring
• Host Monitoring
• Application Server Administration
• Start/Stop/Restart Application Server and
  components
• Enable/Disable components to customize view
• Create/Delete OC4Js
• Manage J2EE Applications Deploy/Undeploy/Redeploy
  applications

• Application Server Management
• Manage servlets JSP, EJBs
• Manage datasources JMS, application security
• Create and Manage Application Server Clusters
• Centralized Identity Management
• Centralized Port Management
• Centralized Log Viewing and Diagnostics
• Full Administration for application server and
  all components

11
Enterprise Manager 10gApplication Server Control
The following are licensable components

• Diagnostics Pack for Application Server
• Configuration Management Pack for Application
  Server

12
Enterprise Manager 10gGrid Control
The following are included for free

• Monitoring
• Enterprise Health Status
• Targets Availability
• All Targets Alerts Critical. Warning, Collection
  Errors
• All Target Jobs Status
• Host/DB Performance Overview
• Real Time Performance Monitoring
• Application Server Monitoring
• Web Application Monitoring
• Administration
• Database Administration
• Application Server Administration
• Create/Manage Groups
• Create/Manage Web Applications

• Job System
• Create Job
• Monitor Job Status
• Job Search
• EM Framework
• Create/Delete EM Administrators
• Manage Preferred Credentials
• Create/Modify/Delete Roles
• Create/Modify/Delete Preferences
• SDK (Extensibility)

13
Enterprise Manager 10gGrid Control
The following are licensable components

• Service Level Management Pack
• Configuration Management Pack for Non-Oracle
  Systems
• Provisioning Pack
• System Monitoring Plug-in for host
• System Monitoring Plug-in for non-Oracle
  databases
• System Monitoring Plug-in for non-Oracle
  middleware
• System Monitoring Plug-in for storage
• System Monitoring Plug-in for Network Device
• Tuning Pack for Database
• Diagnostics Pack for Database
• Change Management Pack for Database
• Configuration Management Pack for Database
• Diagnostics Pack for Application Server
• Configuration Management Pack for Application
  Server

14
Managed Targets

• Databases
• Listeners
• Application servers
• Collaboration Suite
• Most O/S systems that are certified to run Oracle
  Products
• Third Party products and applications
• API available that enables you to create custom
  targets not provided by Oracle

15
Accessing the Grid Control Console

• Netscape Navigator 4.78, 4.79, 7.01, or 7.1.0
• Mozilla 1.3.1
• Microsoft IE 5.5 (SP1) or 6.0 (SP2)
• Microsoft Pocket IE 2.0 for HTTP or 3.0 for HTTPS

16
Administrators

• Default Administrators
• DBA
• Production and Non-Production
• Others

17
Hardware

• General guidelines
• Small enterprise
• Memory 1-2 GB
• Disk space 2.5 GB
• Large enterprise
• Memory 2-4 GB
• Disk space 5 mb for each managed target

18
Software

• Any supported operating system
• Sun Solaris
• HPUX
• HP Tru64
• Linux
• IBM AIX
• Microsoft Windows

19
Preparation

• Allow plenty of time
• Read the Quick Installation Guide (For those of
  us that dont like to read installation manuals)
• Review Installation guide
• Determine Configuration (1 or 2 servers, Oracle
  recommends separate)
• Hardware requirements
• Disk space (It will stop the install if not
  available, including /tmp space)

20
Preparation

• O/S (Kernel parameters)
• O/S Patches (install all listed)
• ssh configuration
• Password definitions
• Metalink access
• Mail Server Information

21
Installation
Option B single servers
Option A 2 separate servers
Management Repository (Database)
Management Service
Management Repository (Database)
Management Service
Server A
Server B
Server C
22
Default Settings

• Administrators
• SYSMAN
• SYS
• SYSTEM
• Preferences
• Rules

23
Administrators
24
Notification Rules
25
General Information
26
Notification Methods
27
Agent Deployment

• Installs agent at the host server
• Installs Oracle Home for agent
• Could take some time to deploy.
• Gather Stats on host after install (may cause
  some performance issues first time through)

28
Agent Deployment access via Deployment Tab
29
Host AccessFollowing Agent Deployment
30
Configure Host
31
DatabasesFrom Hosts/Targets
32
Database detail information
33
Configure database connection
34
Database connection
35
Management Pack Definition

• Enable/Disable Management Package
• All are enabled by default
• Alter Management Pack access according to license
  agreement

36
Host Management Pack Access
37
Database Management Pack Access
38
Preferred CredentialsFrom Preferences
39
Host Credentials
40
Database Credentials
41
Monitoring

• Rules
• Subscribing
• Paging and Emails
• Production and Non-Production

42
Notification Rules
43
Monitoring
44
General Information
45
Summary

• We Have
• Reviewed components of OEM
• Looked at some of the configuration items
• Determined that there are a lot of pieces to OEM
• It takes time to utilize OEM
• Put in a timeline
• Practice on sandbox
• Installed on prod server
• Setup about 1 week (with other duties)
• Will be expanding use this year
• Hopefully this will help with your implementation
  of OEM

46
Q A