1 / 46

Implementing OEM for the First Time

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.

iokina
Download Presentation

Implementing OEM for the First Time

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Implementing OEM for the First Time Gary Gelder Sr. Database Administrator Mirant Corporation Gary.Gelder@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 • 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

  8. 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:

  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. 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:

  11. Enterprise Manager 10gApplication Server Control The following are licensable components: • Diagnostics Pack for Application Server • Configuration Management Pack for Application Server

  12. 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:

  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 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)

  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

More Related