460 likes | 559 Views
Implementing OEM for the First Time. Gary Gelder Sr. Database Administrator Mirant Corporation Gary.Gelder@mirant.com. Agenda. Pieces of the puzzle Preparation Installation Agent deployment Monitoring Q & A. Pieces of the puzzle. Admin. Browsers. OMS. OMR. Software. OMA.
E N D
Implementing OEM for the First Time Gary Gelder Sr. Database Administrator Mirant Corporation Gary.Gelder@mirant.com
Agenda • Pieces of the puzzle • Preparation • Installation • Agent deployment • Monitoring • Q & A
Pieces of the puzzle Admin Browsers OMS OMR Software OMA Hardware Targets Free
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
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
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.
Enterprise Manager 10g Product (OMS) • Enterprise Manager 10g Grid Control • Oracle’s 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 • Oracle’s application server management interface built directly into the Oracle 10g application server infrastructure
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 Enterprise Manager 10g Database Control The following are included for free:
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
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 OC4J’s 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 Enterprise Manager 10gApplication Server Control The following are included for free:
Enterprise Manager 10gApplication Server Control The following are licensable components: • Diagnostics Pack for Application Server • Configuration Management Pack for Application Server
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) Enterprise Manager 10gGrid Control The following are included for free:
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
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
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
Administrators • Default Administrators • DBA • Production and Non-Production • Others
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
Software • Any supported operating system • Sun Solaris • HPUX • HP Tru64 • Linux • IBM AIX • Microsoft Windows
Preparation • Allow plenty of time • Read the Quick Installation Guide (For those of us that don’t 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)
Preparation • O/S (Kernel parameters) • O/S Patches (install all listed) • ssh configuration • Password definitions • Metalink access • Mail Server Information
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
Default Settings • Administrators • SYSMAN • SYS • SYSTEM • Preferences • Rules
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)
Management Pack Definition • Enable/Disable Management Package • All are enabled by default • Alter Management Pack access according to license agreement
Monitoring • Rules • Subscribing • Paging and Emails • Production and Non-Production
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