[book] oracle enterprise manager 10g grid control - scalable management for databases, application...
TRANSCRIPT
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
1/59
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
2/59
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
3/59
Oracle Enterprise Manager
10g Grid Control:Scalable Management forDatabases, Applications
Servers and More
September 7, 2004
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
4/59
Anil KhilaniSenior Product ManagerSystem Management Products
Oracle Corporation
Daniel Roberts
Senior Product ManagerOracle AS Product ManagementEMEA, Oracle Corporation
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
5/59
Agenda
Objective
Enterprise Manager 10g Design Goals
Architecture
Grid Control vs. Database Control
Comprehensive Database Management
Application Server Control
J2EE & Web Application Monitoring Q & A
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
6/59
Objective
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
7/59
Enterprise Manager 10g Design Goals
Facilitate management of sets of systems
Access from anywhere
Zero implementation time-to-value Intimate connection to Oracle
1-Hour Integration, Industry Standards
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
8/59
Enterprise Manager 10gDeployment
Fir
ewa
ll
Mobile Device
HTML Console
Portals
HTTP/S
HTTP/S
HTTP/S
HTTP/S
Open Repository
Manage from Anywhere
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
9/59
Host andHardware
Enterprise Manager Eco-SystemManagement Depth
DatabaseOracle AS
Storage
Network andLoad Balancer
Applications
Administration
Monitoring
Diagnostics
Configuration
Enterprise
Manager
*
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
10/59
Deployment Modes
Enterprise
Manager
Grid Control Database ControlAA
AA
AS
OCS
AA
Enterprise
ManagerAAAA
http(s) http(s)
http(s)
SQL*Net
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
11/59
Database Management Grid Control vs. Database Control
Feature Grid Control Database Control
Installation Separate Database 10g
Enterprise Manager repository Centralized In local 10g database
Enterprise Manager agent One per host in separate home One per 10g database home
# of databases Many One
Target types Many Single 10g database
EM job system Yes Yes
Cluster database (RAC) Yes Yes
Standby database (Data Guard) Yes No
Configuration management Enterprise-wide Local system
Mobile access (EM2Go) Yes No
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
12/59
Complete Database Administration
Enterprise
Manager
MemoryMemory
ManagementManagement
Database ParameterDatabase Parameter
ManagementManagement
SchemaSchema
ManagementManagement
UserUser
ManagementManagement
SpaceSpace
ManagementManagement
Data ExportData Export
& Import& Import
Backup &Backup &
RecoveryRecovery
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
13/59
Comprehensive DatabaseManagement
EnterpriseManager
ManagingManagingHigh AvailabilityHigh Availability
DBA DashboardDBA Dashboard& Administration& Administration
ManagingManagingStorageStorage
ConfigurationConfigurationManagementManagement
TuningTuning
DiagnosticsDiagnostics
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
14/59
Database Home Page
Dashboard for the DBA Database status
Host information
Availability
Performance
Alerts
Drill-down capability
Launch pad for all DBA
activities
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
15/59
Enterprise Manager Groups
Efficient way to manage large numbers of
systems
Grant access by group
Homogeneous groups Group of databases
Heterogeneous groups
Group of application components (database,listener, application server, host systems)
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
16/59
Database Group Page
Manage all yourdatabases from oneplace
At a glance: Availability
Performance
Alerts
Drill-downs
Database details Host details
Storage details
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
17/59
Policy-Based Standardization
Policy Management
Best-practice rules
Violation detection
Types
Configuration
Installation
Objects
Security Storage
Drives Consistency and Automation
Policy
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
18/59
Versatile Enterprise ManagerJob System
Execute simple or
complex tasks across
one or many systems
Pre-packaged jobs Backup, patch, clone
Ad-hoc job creation SQL script
Host command Use or override
preferred credentials
Enterprise
Manager
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
19/59
D E M O N S T R A T I O N
Resolving a
Tablespace Full Alert
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
20/59
Demonstration Tablespace Full Alert
1
2
Database Home Page
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
21/59
3
Demonstration Tablespace Full Alert
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
22/59
Comprehensive DatabaseManagement
EnterpriseManager
ManagingManagingHigh AvailabilityHigh Availability
DBA DashboardDBA Dashboard& Administration& Administration
ManagingManagingStorageStorage
ConfigurationConfigurationManagementManagement
TuningTuning
DiagnosticsDiagnostics
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
23/59
D E M O N S T R A T I O N
Investigating a
Runaway Session
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
24/59
Scenario
Tablespace with manual
segment management
Multiple sessions
repeatedly insertingrows into the same table
Only one physical write
operation possible at a
time Result: waiting due to
concurrent access
Demonstration Investigating a runaway session
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
25/59
Database Performance Page
Near real-time 15 secrefresh
Interactive graphicsAdobe SVG
Host performance Run queue length
Paging rate
Waiting and working
sessions
Instance throughput
Demonstration Investigating a runaway session
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
26/59
Determining the Wait Class
Demonstration Investigating a runaway session
1
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
27/59
SQL and Session Details
Demonstration Investigating a runaway session
2
3
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
28/59
ADDM Performance Findings
1
2
Demonstration Investigating a runaway session
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
29/59
Comprehensive DatabaseManagement
EnterpriseManager
ManagingManagingHigh AvailabilityHigh Availability
DBA DashboardDBA Dashboard& Administration& Administration
ManagingManagingStorageStorage
ConfigurationConfigurationManagementManagement
TuningTuning
DiagnosticsDiagnostics
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
30/59
State-of-the-Art AvailabilityManagement
Standby System
(Data Guard)
Production
System (RAC)
Backup and Recovery
Real Application Clusters (RAC)
Data GuardEnterprise
Manager
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
31/59
RAC Management User transparency
Same functionality as single instance
Cluster awareness Database
Hosts (OS)
Database-level alerts e.g. storage alerts
Cluster-aware EM jobs
RAC-specific performance
management e.g. Cluster cache coherency
Service / module / action and client
ID
Service Assurance Management(Oracle Database 10g)
Preferred and available instances to
deliver service
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
32/59
Comprehensive DatabaseManagement
EnterpriseManager
ManagingManagingHigh AvailabilityHigh Availability
DBA DashboardDBA Dashboard& Administration& Administration
ManagingManagingStorageStorage
ConfigurationConfigurationManagementManagement
TuningTuning
DiagnosticsDiagnostics
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
33/59
Integrated Storage Management
Database Storage Administration Tablespaces
Datafiles
Redo logs
Rollback segments
Archive logs
OMF Support
Management of ASM
*
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
34/59
Comprehensive DatabaseManagement
EnterpriseManager
ManagingManagingHigh AvailabilityHigh Availability
DBA DashboardDBA Dashboard& Administration& Administration
ManagingManagingStorageStorage
ConfigurationConfigurationManagementManagement
TuningTuning
DiagnosticsDiagnostics
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
35/59
System Life Cycle Management
Install
Configure
Activate
Operate
Clone
Upgrade
Patch
Uninstall
Deactivate
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
36/59
View/Search
Compare/Diff
Change Tracking
Reference
Configurations
Analy
ze
Install/Clone
Configure
Patch
Secure
LiveLink
Oracle.com
Product Updates
Patches
Product
Configuration
Oracle
Inventory
Software
Configurations
Hardware
Configurations
Discover
Automated ProvisioningScale Out to More Systems at Minimal Incremental Cost
Enterprise
Manager
Prov
ision
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
37/59
Comprehensive DatabaseManagement
EnterpriseManager
ManagingManagingHigh AvailabilityHigh Availability
DBA DashboardDBA Dashboard& Administration& Administration
ManagingManagingStorageStorage
ConfigurationConfigurationManagementManagement
TuningTuning
DiagnosticsDiagnostics
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
38/59
Host Information
*
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
39/59
Mobile Access EM2Go
Access through a PDA
Automatically availablewith Grid Control noseparate installation
Targeted subset offunctionality fortroubleshooting andfixing problems on the
go Ability to run an arbitrary
OS/SQL command
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
40/59
Oracle Application Server 10g Management
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
41/59
EM Website/App Server Console
iAS 9.0.2/9.0.3 called EM Website Application Server 10g called
Oracle Application Server Console
Installs with each AS instance
Administration console
Real-time monitoring of single AS
instance
Relies upon AS management stack
DCM
OPMN
DMS
Oracle App Server
Agent
App Server
Console
Oracle Home
Central and App Server
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
42/59
Host
Storage
OracleAS 10g
Clients
Application
Network
Oracle Database
Management
Repository
App Server
Console
Central
Agent
Oracle
Management
Service
Agent
Central
Management
Console
Central and App ServerConsoles
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
43/59
OracleAS 10gConsoleUnified Management Operations
Access all Application Server diagnostic logs froma single point in the Application Server Console
Automatically load log data into a repository foreasier investigation
Configure Application Server component ports froma single Console page
Enable disable components
Manage all application server components in a
consistent manner Consolidates and simplifies management of the
application server platform
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
44/59
OracleAS 10gConsoleInfrastructure Administration
Infrastructure association and reassocation
Modify metadata repository passwords
Link to a central management consoleProvides more flexibility in managing your
application server environment
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
45/59
OracleAS 10gConsoleEnhanced J2EE Administration
Consolidated view of J2EE applications across allOC4J instances
Enhanced deployment wizard
Configure Java Messaging Services for J2EEapplications
Configure and monitor Message Driven Beans
Configure J2EE data sources more easily with
new create-like feature Clustering
E i M
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
46/59
Enterprise Manager -Central Management Console
Integrated web-based central Oracle management
Manage the entire OracleAS stack J2EE and Web Cache
Business Intelligence & Forms Portal & Wireless
Process Connect
Identify Management
Centrally monitor distributed application server
performance
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
47/59
Application Server Home Page
Availability
J2EE applications
Resource usage Responsiveness
Alerts
Diagnostics
Administration
Consolidated view of key OracleAS information
O t f B O l AS 10
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
48/59
Out-of-Box OracleAS 10gPerformance Monitoring
Real time charts and automated alertnotifications
Monitors all key application server
performance points Server availability and response time
System resource usage
Server usage and performance
Performance baselines and thresholds Historical management data repository
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
49/59
Application Server Historical DataTrends and Comparisons
Whats the current CPU usage for server #1?
How did it do over the past 24 hours?
How does that compare to server #2 over the same
timeframe?
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
50/59
J2EE Application Diagnostics
Real-time and historical performance Easily identify top resource consumers
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
51/59
J2EE Diagnostic Drilldowns What are my top web modules, servlets &
JSPs?
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
52/59
J2EE Diagnostic Drilldowns What are my top EJBs and EJB methods?
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
53/59
Application PerformanceManagement
Web application client experience Direct measurement of real end-user performance
against your Web Application
Business Transaction Monitoring Emulate and monitor client experience from
remote locations
Monitor availability of web applications
Monitor performance of application transactions
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
54/59
Web Application Monitoring
C ti T i f
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
55/59
Cross-tier Tracing ofBusiness Transactions
Trace web site transactions through the
application server stack
Breakdown of processing time Web Server
OC4J Container
Data Source
W b A li ti
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
56/59
Web ApplicationTransaction Tracing
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
57/59
Summary
Simplify systems management
Improve quality of management Manage the application end-user experience
Reduce overall costs
Robust management service means moreproductive administrators
Oracle provides a single managementtool for the Oracle stack, so you can
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
58/59
AQ&Q U E S T I O N SQ U E S T I O N SA N S W E R SA N S W E R S
-
8/7/2019 [Book] Oracle Enterprise Manager 10g Grid Control - Scalable Management for Databases, Application Servers
59/59