mangled or managed
DESCRIPTION
Presentation on Enterprise Management, reality vs hype, to be delivered to UKOUG Dec 1 2009. V0.9 (some additions and tweaks left)TRANSCRIPT
Mangled or Managed?Does Grid Control Deliver
Agenda
• About – Maxima– Me
• Enterprise Manager– Architecture– Good– Bad– Troubleshooting– Licensing– Plugins
• Conclusion Q&A
Who we are
Maxima is one of the UK and Ireland’s leading IT solution and service providers, offering a unique blend of deep industry knowledge and specialist technology expertise to deliver real business value to organizations of all sizes across a wide range of commercial sectors.
Who I am
• UKOUG – Chair of UKOUG Oracle on Windows SIG (come present for us)
• Maxima – Consultant DBA, Maxima Managed Services• Oak Table – Windows, “you always make me laugh”, “and
another thing”. • www.orawin.info/• Manager of apps dbas• Manager of developers• Auditor• Father of 3 under 8 – try it, managing developers is easier. • Sussex CCC – long suffering then glory.• Liverpool FC – glory then long suffering.
ARCHITECTUREUnderstanding the design
Enterprise Manager Architecture
Oracle Management Server
Oracle Management Repository
Oracle 10.1.0.4 - End Premier Support Jan 2009
All EM Releases are patches to base release. Can’t use a supported release as an install target.
Note 467677.1 – How to Install Grid Control to use 11g for the Repository
Oracle Management Agent
• 32bit Java application.• Does most of the work• Communicates
Infrastructure Communications
• http 7777 – EM Website• https 4889 – EM Website including agent to
OMS• https 1831 – OMS to Agent• jdbc - OMS to Repository• Check Ports carefully
THE GOOD
Performance Tuning
Blackouts
• Provide a way to schedule reduced monitoring
• Server room outage• Database Upgrade in multi-standby
environment
Reporting
Remember I used to be a manager!
Scripting
• Perl jobs
Job System
• Stats Gathering• ETL• Data Movement
Service Level Management
• Availability and Performance
Monitoring Templates
• Work properly as of 10.2.0.5
Helpdesk Integration
• Email customisation• Remedy Connector
– Remedy Connector
THE BAD
Notable bugs
• Healthcheck for different db version• Clone db files must be smaller than 2gb till
current version• Target Discovery Selects Wrong Database
Name For Dataguard Target• Agent Installation Hangs at the Target
Discovery Process Due to Customized glogin.sql File
Configuration Issues
• .properties files• Status of database instance• Non-oracle clusters (lifekeeper ,vcs, etc)• Web cache• Statspack integration
TROUBLESHOOTING
Basic Approach
• Identify the problem component• Record symptoms (error messages, response
time).• Locate related logfiles• Review log files around time of exception for
any related error entries.• Resolve the error.
Web Server
• Oracle HTTP Server (Apache)• $ORACLE_HOME/Apache/Apache/logs• The following log files can be reviewed:
– Access Log– Error Log– SSL Log (If using SSL, and error is SSL related)
• $ORACLE_HOME oms10g
Web Cache
• Runs in Oracle HTTP Server home• $ORACLE_HOME/Apache/Apache/logs• Event.log
– Note 454533.1 Common Troubleshooting Techniques for OracleAS Web Cache
– Note 259796.1 OracleAS Web Cache event_log messages: Format and Meaning
Oracle Management Server
• Managed by opmn– PATH=$ORACLE_HOME/oms10g/opmn/bin:$PATH
export $PATH– Makes it easier to use correct opmnctl
• Start/Stop components individually– opmnctl start
opmnctl startproc ias-component=WebCacheopmnctl startproc ias-component=HTTP_Serveropmnctl startproc process-type=homeopmnctl startproc process-type=OC4J_EMopmnctl startproc process-type=OC4J_EMPROV
Management Server Status
• [oracle@gcserver ~]$ opmnctl status –v
Processes in Instance: EnterpriseManager0.gcserver.domain-------------------+--------------------+---------+----------+------------+----------+-----------+------ias-component | process-type | pid | status | uid | memused | uptime | ports-------------------+--------------------+---------+----------+------------+----------+-----------+------DSA | DSA | N/A | Down | N/A | N/A | N/A | N/AHTTP_Server | HTTP_Server | 20759 | Alive | 1327300712 | 42332 | 291:14:29 |
http1:7778,http2:7200,https1:4444,https2:1159,http3:4889LogLoader | logloaderd | N/A | Down | N/A | N/A | N/A | N/Adcm-daemon | dcm-daemon | N/A | Down | N/A | N/A | N/A | N/AOC4J | home | 20760 | Alive | 1327300713 | 26852 | 291:14:57 |
ajp:12501,rmi:12401,jms:12601OC4J | OC4J_EMPROV | 20761 | Alive | 1327300714 | 29772 | 291:14:57 |
ajp:12502,rmi:12402,jms:12602OC4J | OC4J_EM | 14041 | Alive | 1327300754 | 452092 | 86:09:11 |
ajp:12503,rmi:12403,jms:12603WebCache | WebCache | 20771 | Alive | 1327300716 | 27612 | 291:14:57 |
http:7777,invalidation:9401,statistics:9402WebCache | WebCacheAdmin | 20764 | Alive | 1327300717 | 5924 | 291:14:57 |
administration:9400
OC4J Verification
• home - IsWebCacheWorking– HTTP://<GC_URL/ IsWebCacheWorking
OC4J Verification
• EM – Rules Manager Login – http://<GC_URL>/rlmgr/rlmgr_login.htm
OC4J Verification
• EM Prov – Agent Deploy Page– <EM URL>/EMAgentPush/home.jsp
OC4J - Logs• $ORACLE_HOME/j2ee/<OC4J_instance>/log/<OC4J_instance>_default_island_1/logfile
• default-web-access.log• server.log• 2gb limit on some platforms
LICENSING
License basis
• Grid control free• Infrastructure Repository Databases A separate Oracle Database can be installed and used as a Recovery Manager
(RMAN) repository without additional license requirements, provided that all the Oracle databases managed in this repository are correctly licensed. This repository database may also be used for the Oracle Enterprise Grid Control repository. It may not be used or deployed for other uses.
• A separate Oracle Database can be installed and used as a Oracle Enterprise Manager Grid Control (OEM Grid Control) repository without additional license requirements, provided that all the targets (databases, applications, and so forth) managed in this repository are correctly licensed. This database may also be used for the RMAN repository. It may not be used or deployed for other uses
• Management packs do cost• Management packs still cost without GC
– Eg awrrpt.sql
Plugins
• A wide variety of extra cost options• http://www.pythian.com/news/mysql-plugin-f
or-oracle-grid-control• Oracle-l (self developed sqlserver)
Conclusions
• Grid Control is a mature product.• Grid Control can be complex. • Probably not worth it for small installations <
5 databases/3 servers• Strategic product