Implementing OEM for the First Time

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