Ha And Oem Grid Control
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Ha And Oem Grid Control as PDF for free.
More details
- Words: 1,180
- Pages: 72
Rob Zoeteweij Zoeteweij Consulting
Rob Zoeteweij
◦ Working with Oracle technology since 1985 (Oracle 3) ◦ Many Oracle DBA, Oracle Development projects ◦ Last 6 Years Oracle Expert Services RAC/ASM OEM Grid Control
Independent Consultant Primary Focus OEM Grid Control Rabobank, Shell ING
Copyright 2009 (c) - Zoeteweij Consulting
2
Agenda ◦ ◦ ◦ ◦ ◦
High Availability – What’s that? System monitoring and detection of errors Monitoring of Database Health Wrap Up Q&A
Copyright 2009 (c) - Zoeteweij Consulting
3
Degree to which an application, service, or functionality is available upon user demand Measured by the perception of an application's end user!
Copyright 2009 (c) - Zoeteweij Consulting
4
Primary characteristics ◦ Reliability Hardware, Software – Database, Webserver etc.
◦ Recoverability Does your architecture provide the ability to recover in the time specified in a SLA?
◦ Timely error detection Fast detection is an essential component in recovering from a possible unexpected failure
◦ Continuous operations Continuous access to your data is essential when very little or no downtime is acceptable Copyright 2009 (c) - Zoeteweij Consulting
5
Copyright 2009 (c) - Zoeteweij Consulting
6
Oracle Maximum Availability Architecture (MAA) Best Practices (An Example) ◦ Identically configured primary and secondary sites ◦ Primary Site - Multiple application servers and a production database using RAC ◦ Secondary Site - Similarly configured application servers and a physical standby database kept synchronized with the primary database by Oracle Data Guard.
Copyright 2009 (c) - Zoeteweij Consulting
7
Oracle Maximum Availability Architecture – MAA ◦ http://www.oracle.com/technology/deploy/availabi lity/htdocs/maa.htm ◦ HA Best Practices for Oracle Database ◦ HA Best Practices for Oracle Enterprise Application Server ◦ HA Best Practices for Oracle Applications ◦ HA Best Practices for Oracle Beehive ◦ HA Best Practices for Grid Control ◦ HA Best Practices for Oracle VM
Copyright 2009 (c) - Zoeteweij Consulting
8
Monitoring of Systems and detection of errors
Copyright 2009 (c) - Zoeteweij Consulting
9
Copyright 2009 (c) - Zoeteweij Consulting
10
Monitoring of Systems and detection of errors ◦ Monitoring Templates – Metrics Detect Database down or events like: corrupted blocks, missing data files, etc.
◦ Systems and Services If a Business Service application has very bad performance, the user might consider the Service as unavailable, even if Databases, Application Server etc. are Up and Running!
Copyright 2009 (c) - Zoeteweij Consulting
11
Copyright 2009 (c) - Zoeteweij Consulting
12
Copyright 2009 (c) - Zoeteweij Consulting
13
Copyright 2009 (c) - Zoeteweij Consulting
14
Recommended events to monitor ◦ Status
Up/Down
◦ Space
Tablespace Space used (%) Archive Hung Alert Log Error Archive Area used (%) Dump Area used (%)
◦ Alert Log
Alert - ORA-6XX, ORA-1578 (database corruption), or ORA-0060 (deadlock detected) Database Block Corruption ORA-01157 and ORA27048
Copyright 2009 (c) - Zoeteweij Consulting
15
Recommended events to monitor (cont) ◦ Processing Capacity Process Limit Session Limit
◦ Think Availability!
Copyright 2009 (c) - Zoeteweij Consulting
16
Monitoring of Database Health
Copyright 2009 (c) - Zoeteweij Consulting
17
Database Health ◦ Status ◦ Performance ◦ Configuration
Archivelog Mode Backup Standby Database Etc.
◦ Vulnerability Storage / Configuration / Security Patching
Copyright 2009 (c) - Zoeteweij Consulting
18
Copyright 2009 (c) - Zoeteweij Consulting
19
Copyright 2009 (c) - Zoeteweij Consulting
20
Copyright 2009 (c) - Zoeteweij Consulting
21
High Availability Console ◦ ◦ ◦ ◦ ◦
Availability Summary Backup/Recovery Summary Flash Recovery Area Service (RAC) Summary Data Guard Summary
Copyright 2009 (c) - Zoeteweij Consulting
22
Copyright 2009 (c) - Zoeteweij Consulting
23
Maximum Availability Architecture (MAA) Advisor ◦ Summary of possible Oracle solutions to optimize the availability of a Database ◦ Provides Short Cuts to implement each of the suggested Oracle Solutions
Copyright 2009 (c) - Zoeteweij Consulting
24
Copyright 2009 (c) - Zoeteweij Consulting
25
Copyright 2009 (c) - Zoeteweij Consulting
26
Copyright 2009 (c) - Zoeteweij Consulting
27
Copyright 2009 (c) - Zoeteweij Consulting
28
Copyright 2009 (c) - Zoeteweij Consulting
29
Copyright 2009 (c) - Zoeteweij Consulting
30
Copyright 2009 (c) - Zoeteweij Consulting
31
Copyright 2009 (c) - Zoeteweij Consulting
32
Copyright 2009 (c) - Zoeteweij Consulting
33
Copyright 2009 (c) - Zoeteweij Consulting
34
Copyright 2009 (c) - Zoeteweij Consulting
35
Copyright 2009 (c) - Zoeteweij Consulting
36
Copyright 2009 (c) - Zoeteweij Consulting
37
Copyright 2009 (c) - Zoeteweij Consulting
38
Copyright 2009 (c) - Zoeteweij Consulting
39
Copyright 2009 (c) - Zoeteweij Consulting
40
Copyright 2009 (c) - Zoeteweij Consulting
41
Copyright 2009 (c) - Zoeteweij Consulting
42
Copyright 2009 (c) - Zoeteweij Consulting
43
Copyright 2009 (c) - Zoeteweij Consulting
44
Copyright 2009 (c) - Zoeteweij Consulting
45
Copyright 2009 (c) - Zoeteweij Consulting
46
Copyright 2009 (c) - Zoeteweij Consulting
47
Copyright 2009 (c) - Zoeteweij Consulting
48
Copyright 2009 (c) - Zoeteweij Consulting
49
Copyright 2009 (c) - Zoeteweij Consulting
50
Copyright 2009 (c) - Zoeteweij Consulting
51
Copyright 2009 (c) - Zoeteweij Consulting
52
Copyright 2009 (c) - Zoeteweij Consulting
53
Copyright 2009 (c) - Zoeteweij Consulting
54
Copyright 2009 (c) - Zoeteweij Consulting
55
Copyright 2009 (c) - Zoeteweij Consulting
56
Copyright 2009 (c) - Zoeteweij Consulting
57
Copyright 2009 (c) - Zoeteweij Consulting
58
Copyright 2009 (c) - Zoeteweij Consulting
59
Copyright 2009 (c) - Zoeteweij Consulting
60
Copyright 2009 (c) - Zoeteweij Consulting
61
Copyright 2009 (c) - Zoeteweij Consulting
62
Copyright 2009 (c) - Zoeteweij Consulting
63
Policies – Policy Groups ◦ Categories
Configuration Insufficient Number of Control Files / Redo Logs Not using Spfile, Automatic Undo Management …
Storage Default Permanent Tablespace Set to a System Tablespace Dictionary Managed Tablespaces …
Security
Default Passwords Execute Privileges on UTL_FILE To PUBLIC …
Copyright 2009 (c) - Zoeteweij Consulting
64
Copyright 2009 (c) - Zoeteweij Consulting
65
Patch Advisories ◦ ◦ ◦ ◦
Based on connection with My Oracle Support RefreshFromMyOracleSupport Automatic download Patches Automated Patching Provisioning & Automated Patching
Copyright 2009 (c) - Zoeteweij Consulting
66
Patch Procedures (Deployment Procedures) ◦ ◦ ◦ ◦ ◦ ◦
Patch Standalone ASM Patch Hosts Linux, Windows, Solaris Application Server Oracle Database Clusterware RAC Databases
Copyright 2009 (c) - Zoeteweij Consulting
67
Copyright 2009 (c) - Zoeteweij Consulting
68
Wrap Up
Copyright 2009 (c) - Zoeteweij Consulting
69
Monitoring & Configuring of HA Databases ◦ Monitoring Templates ◦ Metrics / Policies
Wizard based: ◦ ◦ ◦ ◦ ◦
Creation of Standby Databases Data Guard Role switch Migration to ASM Migration to RAC Creation of additional Instances
HA Console MAA (Advisor) Automated Patching - Provisioning
Copyright 2009 (c) - Zoeteweij Consulting
70
[email protected] Training at 5-Hart Educations ◦ http://www.vijfhart.nl/oracle/opleidingen/oraclecursus-pagina/training-id/3451/oracle-enterprisemanager-grid-control-10g.htm
Blog: http://oemgc.wordpress.com Linkedin Group: Oracle Enterprise Manager Grid Control http://www.linkedin.com/groups?gid=17760 07&trk=hb_side_g
Copyright 2009 (c) - Zoeteweij Consulting
71
Q&A Copyright 2009 (c) - Zoeteweij Consulting
72
Rob Zoeteweij
◦ Working with Oracle technology since 1985 (Oracle 3) ◦ Many Oracle DBA, Oracle Development projects ◦ Last 6 Years Oracle Expert Services RAC/ASM OEM Grid Control
Independent Consultant Primary Focus OEM Grid Control Rabobank, Shell ING
Copyright 2009 (c) - Zoeteweij Consulting
2
Agenda ◦ ◦ ◦ ◦ ◦
High Availability – What’s that? System monitoring and detection of errors Monitoring of Database Health Wrap Up Q&A
Copyright 2009 (c) - Zoeteweij Consulting
3
Degree to which an application, service, or functionality is available upon user demand Measured by the perception of an application's end user!
Copyright 2009 (c) - Zoeteweij Consulting
4
Primary characteristics ◦ Reliability Hardware, Software – Database, Webserver etc.
◦ Recoverability Does your architecture provide the ability to recover in the time specified in a SLA?
◦ Timely error detection Fast detection is an essential component in recovering from a possible unexpected failure
◦ Continuous operations Continuous access to your data is essential when very little or no downtime is acceptable Copyright 2009 (c) - Zoeteweij Consulting
5
Copyright 2009 (c) - Zoeteweij Consulting
6
Oracle Maximum Availability Architecture (MAA) Best Practices (An Example) ◦ Identically configured primary and secondary sites ◦ Primary Site - Multiple application servers and a production database using RAC ◦ Secondary Site - Similarly configured application servers and a physical standby database kept synchronized with the primary database by Oracle Data Guard.
Copyright 2009 (c) - Zoeteweij Consulting
7
Oracle Maximum Availability Architecture – MAA ◦ http://www.oracle.com/technology/deploy/availabi lity/htdocs/maa.htm ◦ HA Best Practices for Oracle Database ◦ HA Best Practices for Oracle Enterprise Application Server ◦ HA Best Practices for Oracle Applications ◦ HA Best Practices for Oracle Beehive ◦ HA Best Practices for Grid Control ◦ HA Best Practices for Oracle VM
Copyright 2009 (c) - Zoeteweij Consulting
8
Monitoring of Systems and detection of errors
Copyright 2009 (c) - Zoeteweij Consulting
9
Copyright 2009 (c) - Zoeteweij Consulting
10
Monitoring of Systems and detection of errors ◦ Monitoring Templates – Metrics Detect Database down or events like: corrupted blocks, missing data files, etc.
◦ Systems and Services If a Business Service application has very bad performance, the user might consider the Service as unavailable, even if Databases, Application Server etc. are Up and Running!
Copyright 2009 (c) - Zoeteweij Consulting
11
Copyright 2009 (c) - Zoeteweij Consulting
12
Copyright 2009 (c) - Zoeteweij Consulting
13
Copyright 2009 (c) - Zoeteweij Consulting
14
Recommended events to monitor ◦ Status
Up/Down
◦ Space
Tablespace Space used (%) Archive Hung Alert Log Error Archive Area used (%) Dump Area used (%)
◦ Alert Log
Alert - ORA-6XX, ORA-1578 (database corruption), or ORA-0060 (deadlock detected) Database Block Corruption ORA-01157 and ORA27048
Copyright 2009 (c) - Zoeteweij Consulting
15
Recommended events to monitor (cont) ◦ Processing Capacity Process Limit Session Limit
◦ Think Availability!
Copyright 2009 (c) - Zoeteweij Consulting
16
Monitoring of Database Health
Copyright 2009 (c) - Zoeteweij Consulting
17
Database Health ◦ Status ◦ Performance ◦ Configuration
Archivelog Mode Backup Standby Database Etc.
◦ Vulnerability Storage / Configuration / Security Patching
Copyright 2009 (c) - Zoeteweij Consulting
18
Copyright 2009 (c) - Zoeteweij Consulting
19
Copyright 2009 (c) - Zoeteweij Consulting
20
Copyright 2009 (c) - Zoeteweij Consulting
21
High Availability Console ◦ ◦ ◦ ◦ ◦
Availability Summary Backup/Recovery Summary Flash Recovery Area Service (RAC) Summary Data Guard Summary
Copyright 2009 (c) - Zoeteweij Consulting
22
Copyright 2009 (c) - Zoeteweij Consulting
23
Maximum Availability Architecture (MAA) Advisor ◦ Summary of possible Oracle solutions to optimize the availability of a Database ◦ Provides Short Cuts to implement each of the suggested Oracle Solutions
Copyright 2009 (c) - Zoeteweij Consulting
24
Copyright 2009 (c) - Zoeteweij Consulting
25
Copyright 2009 (c) - Zoeteweij Consulting
26
Copyright 2009 (c) - Zoeteweij Consulting
27
Copyright 2009 (c) - Zoeteweij Consulting
28
Copyright 2009 (c) - Zoeteweij Consulting
29
Copyright 2009 (c) - Zoeteweij Consulting
30
Copyright 2009 (c) - Zoeteweij Consulting
31
Copyright 2009 (c) - Zoeteweij Consulting
32
Copyright 2009 (c) - Zoeteweij Consulting
33
Copyright 2009 (c) - Zoeteweij Consulting
34
Copyright 2009 (c) - Zoeteweij Consulting
35
Copyright 2009 (c) - Zoeteweij Consulting
36
Copyright 2009 (c) - Zoeteweij Consulting
37
Copyright 2009 (c) - Zoeteweij Consulting
38
Copyright 2009 (c) - Zoeteweij Consulting
39
Copyright 2009 (c) - Zoeteweij Consulting
40
Copyright 2009 (c) - Zoeteweij Consulting
41
Copyright 2009 (c) - Zoeteweij Consulting
42
Copyright 2009 (c) - Zoeteweij Consulting
43
Copyright 2009 (c) - Zoeteweij Consulting
44
Copyright 2009 (c) - Zoeteweij Consulting
45
Copyright 2009 (c) - Zoeteweij Consulting
46
Copyright 2009 (c) - Zoeteweij Consulting
47
Copyright 2009 (c) - Zoeteweij Consulting
48
Copyright 2009 (c) - Zoeteweij Consulting
49
Copyright 2009 (c) - Zoeteweij Consulting
50
Copyright 2009 (c) - Zoeteweij Consulting
51
Copyright 2009 (c) - Zoeteweij Consulting
52
Copyright 2009 (c) - Zoeteweij Consulting
53
Copyright 2009 (c) - Zoeteweij Consulting
54
Copyright 2009 (c) - Zoeteweij Consulting
55
Copyright 2009 (c) - Zoeteweij Consulting
56
Copyright 2009 (c) - Zoeteweij Consulting
57
Copyright 2009 (c) - Zoeteweij Consulting
58
Copyright 2009 (c) - Zoeteweij Consulting
59
Copyright 2009 (c) - Zoeteweij Consulting
60
Copyright 2009 (c) - Zoeteweij Consulting
61
Copyright 2009 (c) - Zoeteweij Consulting
62
Copyright 2009 (c) - Zoeteweij Consulting
63
Policies – Policy Groups ◦ Categories
Configuration Insufficient Number of Control Files / Redo Logs Not using Spfile, Automatic Undo Management …
Storage Default Permanent Tablespace Set to a System Tablespace Dictionary Managed Tablespaces …
Security
Default Passwords Execute Privileges on UTL_FILE To PUBLIC …
Copyright 2009 (c) - Zoeteweij Consulting
64
Copyright 2009 (c) - Zoeteweij Consulting
65
Patch Advisories ◦ ◦ ◦ ◦
Based on connection with My Oracle Support RefreshFromMyOracleSupport Automatic download Patches Automated Patching Provisioning & Automated Patching
Copyright 2009 (c) - Zoeteweij Consulting
66
Patch Procedures (Deployment Procedures) ◦ ◦ ◦ ◦ ◦ ◦
Patch Standalone ASM Patch Hosts Linux, Windows, Solaris Application Server Oracle Database Clusterware RAC Databases
Copyright 2009 (c) - Zoeteweij Consulting
67
Copyright 2009 (c) - Zoeteweij Consulting
68
Wrap Up
Copyright 2009 (c) - Zoeteweij Consulting
69
Monitoring & Configuring of HA Databases ◦ Monitoring Templates ◦ Metrics / Policies
Wizard based: ◦ ◦ ◦ ◦ ◦
Creation of Standby Databases Data Guard Role switch Migration to ASM Migration to RAC Creation of additional Instances
HA Console MAA (Advisor) Automated Patching - Provisioning
Copyright 2009 (c) - Zoeteweij Consulting
70
[email protected] Training at 5-Hart Educations ◦ http://www.vijfhart.nl/oracle/opleidingen/oraclecursus-pagina/training-id/3451/oracle-enterprisemanager-grid-control-10g.htm
Blog: http://oemgc.wordpress.com Linkedin Group: Oracle Enterprise Manager Grid Control http://www.linkedin.com/groups?gid=17760 07&trk=hb_side_g
Copyright 2009 (c) - Zoeteweij Consulting
71
Q&A Copyright 2009 (c) - Zoeteweij Consulting
72
Related Documents
Ha And Oem Grid Control
June 2020 7
Oem
May 2020 16
Oem
December 2019 37
Em 10g Grid Control
November 2019 20
Alv Grid Control
November 2019 5More Documents from ""
Oem - Ogh - 9 Juli 2009
June 2020 3
