Oracle Enterprise Manager 2.2 2000 11 : J02261-01
Oracle Enterprise Manager 2.2 : J02261-01 Oracle Enterprise Manager Concepts Guide, Release 2.2 A85250-01 Copyright 1996, 2000, Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Corporation Restricted Rights Notice Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial computer software" and use, duplication, and disclosure of the Programs, including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR 52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.
... vii... vii... viii... viii... ix... x 1 Oracle Enterprise Manager 3... 1-2... 1-3 Oracle Management Server... 1-4... 1-5 Oracle Enterprise Manager... 1-6... 1-6... 1-7... 1-7... 1-8... 1-8 Intelligent Agent... 1-8... 1-8... 1-9... 1-9 Oracle Management Server... 1-11... 1-11... 1-12 i
... 1-12... 1-12... 1-13... 1-14 /... 1-14... 1-14... 1-16... 1-16 DBA Management Pack... 1-16 2... 2-1... 2-3... 2-3... 2-4... 2-5... 2-7... 2-8 3... 3-2... 3-3... 3-4... 3-4... 3-5... 3-5... 3-5 Intelligent Agent... 3-5... 3-5... 3-5... 3-6... 3-6... 3-8... 3-8... 3-8 ii
... 3-8... 3-9... 3-9... 3-10... 3-10 4 DBA Management Pack DBA Studio... 4-2 DBA Management Pack... 4-2... 4-2... 4-3... 4-3... 4-3... 4-3 DDL... 4-3 SQL... 4-3... 4-3... 4-4... 4-4... 4-4 DBA Management Pack... 4-4 Instance Management... 4-5... 4-6... 4-7... 4-7... 4-8... 4-8... 4-8... 4-8 Schema Management... 4-9... 4-10... 4-11... 4-11 Security Management... 4-11... 4-12... 4-13 iii
... 4-13 Storage Management... 4-14... 4-15... 4-16... 4-16... 4-16 REDO... 4-16... 4-16 Replication Management... 4-16 JServer Management... 4-17 Cache Management... 4-17 SQL*Plus Worksheet... 4-18... 4-18 5 Oracle Management Pack Oracle Diagnostics Pack... 5-2 Oracle Advanced Events... 5-2... 5-3... 5-3 Microsoft SQL Server... 5-4... 5-4 Web... 5-4 Oracle Performance Manager... 5-4 Oracle Capacity Planner... 5-5 Oracle TopSessions... 5-5 Oracle Trace... 5-5 E-Business Management Tools... 5-6 Web... 5-6 Web... 5-7... 5-7 Oracle Tuning Pack... 5-8 Oracle Expert... 5-8 Oracle Index Tuning Wizard... 5-9 Oracle SQL Analyze... 5-10 Oracle Tablespace Map... 5-11 Reorg Wizard... 5-11 Oracle Change Management Pack... 5-12 iv
Change Manager... 5-13... 5-13... 5-13 DB Quick Change... 5-14 DB Alter... 5-14 DB Propagate... 5-14... 5-14 Plan Manager... 5-15 Oracle Standard Management Pack... 5-15 Oracle Management Pack for Oracle Applications... 5-15... 5-16 Oracle Applications Manager... 5-16 Oracle Enterprise Security Manager... 5-17 Oracle8i intermedia Text... 5-17 Oracle Parallel Server Manger... 5-18 Oracle Spatial Index Advisor... 5-18 Oracle Directory Manager... 5-18 Oracle Distributed Access Manager... 5-18 Oracle Developer Server Forms Manager... 5-19 v
vi
Oracle Enterprise Manager vii viii viii ix x Oracle Enterprise Manager 2.2 Oracle Enterprise Manager Intelligent Agent Oracle Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager vii
Oracle Enterprise Manager Oracle Oracle8i Oracle8i Oracle8i Oracle8i Oracle Enterprise Manager Oracle8i Microsoft Windows UNIX Windows UNIX 1 Oracle Enterprise Manager 2 3 4 DBA Management Pack 5 Oracle Management Pack A 1 Oracle Management Server Oracle Enterprise Manager 2 Oracle Enterprise Manager 3 4 Oracle Enterprise Manager DBA Management Pack 5 Oracle Enterprise Manager Oracle Enterprise Manager Management Pack A Windows viii
Oracle Enterprise Manager Management Pack Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Intelligent Agent Oracle Enterprise Manager Oracle Intelligent Agent Oracle SNMP SNMP Oracle SNMP Oracle Enterprise Manager Oracle Enterprise Manager Oracle Management Pack Oracle Change Management Oracle Diagnostics Oracle Tuning Pack Oracle Change Management Pack Oracle Diagnostics Pack Oracle Tuning Pack Oracle Change Management Pack, Diagnostics Pack, Oracle Tuning Pack Oracle Change Management Pack Oracle Diagnostics Pack Oracle Tuning Pack Oracle Change Management Pack Oracle Change Management Pack Oracle Change Management Pack Oracle Diagnostics Pack Oracle Diagnostics Pack Oracle Diagnostics Pack ix
Oracle Enterprise Manager Oracle Trace Oracle Trace Oracle Oracle Tuning Pack Oracle Tuning Pack Oracle Tuning Pack Oracle Standard Management Pack Oracle Standard Management Pack Standard Management Pack Oracle Standard Management Pack Oracle Standard Management Pack Oracle Standard Management Pack Oracle Standard Management Pack Oracle Management Pack for Oracle Applications Oracle Management Pack for Oracle Applications Management Pack for Oracle Applications Oracle Management Pack for Oracle Applications Management Pack for Oracle Applications Oracle Management Pack for Oracle Applications Management Pack for Oracle Applications Oracle8i Getting to Know Oracle8i Oracle8i Oracle8i Oracle8i Oracle Oracle8i Oracle SQL Oracle8i SQL x
Oracle8i Oracle8i Oracle Oracle8i Oracle Oracle Parallel Server Oracle8i Parallel Server Oracle Parallel Server Oracle Enterprise Manager Oracle8i Oracle Parallel Server Oracle Parallel Server Oracle8i Oracle Parallel Server xi
xii
1 Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Management Server Oracle Intelligent Agent Oracle Oracle Enterprise Manager Oracle Oracle 1 24 Oracle Enterprise Manager 3 1-2 Oracle Enterprise Manager 1-9 1-9 Oracle Enterprise Manager 1-1
3 3 Oracle Enterprise Manager 3 2 / Oracle Enterprise Manager 2 3 1 Oracle Management Server 2 3 Oracle Enterprise Manager 1 Oracle Management Server Oracle Management Server 1-1 3 1-2 Oracle Enterprise Manager
3 Oracle Enterprise Manager 1 Web 1 2 Oracle Management Server CORBA IIOP 1 Oracle Management Server 1-2 1 Oracle Enterprise Manager 1-3
3 Oracle Management Server Oracle Enterprise Manager 2 1 Oracle Management Server Management Server Enterprise Manager 1 3 1-3 2 Oracle Management Server Management Pack Oracle Management Server Oracle Oracle Management Server Oracle Management Server 1 Oracle Management Server 1 3 Oracle Intelligent Agent Intelligent Agent 1-4 Oracle Enterprise Manager
3 Oracle Enterprise Manager 3 Oracle Intelligent Agent Oracle Management Server 1-4 3 Oracle Intelligent Agent Oracle Management Server Intelligent Agent Oracle Management Server Intelligent Agent Intelligent Agent SNMP Simple Network Management Protocol Intelligent Agent Oracle Intelligent Agent Capacity Planner Performance Manager I/O CPU Capacity Planner Performance Manager Oracle Diagnostics Pack Oracle Management Pack for Oracle Applications Oracle Enterprise Manager 1-5
Oracle Enterprise Manager : Intelligent Agent Oracle Intelligent Agent Oracle Diagnostics Pack Oracle Management Pack for Oracle Applications 5 Oracle Management Pack Oracle Enterprise Manager Oracle Enterprise Manager Quick Tour Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager 1-6 1-7 1-7 1-8 1-8 Intelligent Agent 1-8 1-8 Oracle Enterprise Manager Oracle Oracle Enterprise Manager Oracle Enterprise Manager 1-6 Oracle Enterprise Manager
Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Management Server Oracle Management Server Oracle Management Server Oracle Management Server Oracle Management Server 3 Oracle Enterprise Manager Oracle Management Server Oracle Management Server Oracle Management Server 1 Oracle Management Server Oracle Management Server Oracle Management Server Oracle Parallel Server Oracle Enterprise Manager 1-7
Oracle Enterprise Manager Intelligent Agent Oracle Enterprise Manager Oracle Enterprise Manager CORBA IIOP Oracle Enterprise Manager Intelligent Agent Oracle Management Server Intelligent Agent Intelligent Agent Oracle Enterprise Manager Oracle Enterprise Manager 1-8 Oracle Enterprise Manager
Oracle Enterprise Manager Oracle Enterprise Manager Quick Tour Oracle Management Server Oracle Enterprise Manager 1-9 Oracle Management Server 1-11 1-11 DBA Management Pack 1-16 Oracle Enterprise Manager Oracle 4 Oracle Enterprise Manager 1-9
1-5 1-5 Oracle Enterprise Manager : 2 Oracle Enterprise Manager 1-10 Oracle Enterprise Manager
Oracle Management Server Oracle Management Server Oracle Enterprise Manager Oracle Management Server Intelligent Agent 1-6 Management Server Oracle Management Server Oracle Enterprise Manager Oracle Oracle Enterprise Manager 1-11
/ Oracle Oracle Management Server Management Pack Oracle Enterprise Manager Configuration Assistant Oracle Management Server Oracle Management Server Oracle Management Server Oracle Enterprise Manager Intelligent Agent Oracle Management Server Oracle Enterprise Manager 1-12 Oracle Enterprise Manager
: 3 Oracle CPU : Oracle Enterprise Manager Intelligent Agent Intelligent Agent 1 1 Intelligent Agent Oracle Enterprise Manager : 3 Oracle Enterprise Manager 1-13
/ Oracle Enterprise Manager / / / Oracle Enterprise Manager 1-7 1-14 Oracle Enterprise Manager
1-7 DBA Oracle Enterprise Manager 1-15
HTML Oracle Enterprise Manager DBA Management Pack DBA Management Pack Oracle Enterprise Manager Oracle Enterprise Manager Oracle 1-16 Oracle Enterprise Manager
: 4 DBA Management Pack Oracle Enterprise Manager 5 Oracle Management Pack Oracle Enterprise Manager 1-17
1-18 Oracle Enterprise Manager
2 Oracle Enterprise Manager 1 Oracle 2-1 2-3 Oracle Enterprise Manager 4 4 Oracle Oracle Enterprise Manager 2-1
2-1 Oracle Enterprise Manager Oracle Management Pack Oracle Enterprise Manager Oracle Management Pack 1 DBA Management Pack Management Pack Oracle Tuning Pack Oracle Diagnostics Pack Oracle Change Management Pack 2-2 Oracle Enterprise Manager
4 2-3 2-5 2-7 2-8 2-2 2-3
1 2 2-3 2-3 2-4 2-4 Oracle Enterprise Manager
2-4 : Oracle Enterprise Manager 1 2-5
2-5 1 1 : Oracle Enterprise Manager 2-6 Oracle Enterprise Manager
2-6 2 Intelligent Agent 1 2-7
SQL OS 1 Intelligent Agent Intelligent Agent Oracle Management Server : 3 Oracle Enterprise Manager Intelligent Agent 1 1 1 1 Intelligent Agent Oracle Management Server Oracle Management Server 2-8 Oracle Enterprise Manager
Intelligent Agent 2-7 2-9
: 3 2-10 Oracle Enterprise Manager
3 Oracle Enterprise Manager Intelligent Agent 1 Intelligent Agent Intelligent Agent 3-2 3-6 3-1
SQL Oracle Enterprise Manager 3 Oracle Management Server Intelligent Agent 1. 1 1 2. Oracle Management Server Intelligent Agent Oracle Management Server 3. Oracle Management Server Intelligent Agent 4. Intelligent Agent 5. Intelligent Agent Oracle Management Server Intelligent Agent Oracle Management Server 3-3 3-4 3-4 3-5 3-5 3-5 Intelligent Agent 3-5 3-2 Oracle Enterprise Manager
3-5 3-5 3-6 1 Oracle SQL DBA 3-1 3-3
Enterprise Manager 1 Oracle Management Server Intelligent Agent Intelligent Agent Management Server 1 Intelligent Agent Management Server Intelligent Agent Intelligent Agent Intelligent Agent Oracle Management Server Intelligent Agent Oracle Management Server Intelligent Agent Oracle Management Server Oracle Management Server Oracle Management Server Web Intelligent Agent 3-4 Oracle Enterprise Manager
TclTcl UNIX NT Intelligent Agent Intelligent Agent Intelligent Agent Intelligent Agent Intelligent Agent Oracle Management Server 3-5
Intelligent Agent Oracle Management Server Intelligent Agent Intelligent Agent Intelligent Agent Intelligent Agent Intelligent Agent : Oracle Enterprise Manager Intelligent Agent 1 True Oracle Enterprise Manager 3-6 Oracle Enterprise Manager
1 1. 1 1 2. 3. Oracle Management Server Oracle Management Server Intelligent Agent Oracle Management Server 4. Intelligent Agent Oracle Management Server Intelligent Agent 5. Intelligent Agent 6. 1 True Intelligent Agent Oracle Management Server Oracle Management Server 7. Oracle Management Server 3-7
3-8 3-8 3-8 3-10 Intelligent Agent 1 1 100 1 1 24 Intelligent Agents 1 3-8 Oracle Enterprise Manager
/ 1. 2. 3. 4. 5. 3-9
Enterprise Manager Oracle Intelligent Agent Intelligent Agent : 3-10 Oracle Enterprise Manager
4 DBA Management Pack Oracle Enterprise Manager Oracle Enterprise Manager DBA Management Pack DBA Studio Oracle Enterprise Manager DBA Management Pack Oracle DBA Studio DBA Management Pack Oracle Enterprise Manager 3 Oracle Management Server DBA Management Pack Instance Management Schema Management Security Management Storage Management Replication Management JServer Management Cache Management SQL*Plus Worksheet SQL Oracle Enterprise Manager DBA Management Pack 4-1
DBA Studio Oracle DBA Management Pack DBA Studio 4-2 DBA Management Pack 4-2 DBA Management Pack 4-4 DBA Studio DBA Management Pack Oracle Enterprise Manager DBA Studio DBA Studio DBA Management Pack SQL*Plus Worksheet Oracle Enterprise Manager 3 Oracle Management Server DBA Studio DBA DBA DBA Studio Enterprise Manager DBA Management Pack DAB Management Pack DBA 4-2 Oracle Enterprise Manager
DBA Management Pack DBA Management Pack SQL HTML DDLDML DDL DDL DBA Studio DDL SQL DBA Management Pack 1 SQL DBA SQL SQL SQL DBA Management Pack 4-3
DBA Management Pack DBA Management Pack DBA Studio DBA Management Pack DBA Management Pack DBA Management Pack DBA Studio Instance Management 4-5 Schema Management 4-9 Security Management 4-11 Storage Management 4-14 Replication Management JServer Management Cache Management Oracle Replication CORBA EJB Java main() Oracle8i Cache 4-16 4-17 4-17 4-4 Oracle Enterprise Manager
DBA Management Pack DBA Studio SQL*Plus Worksheet SQL PL/SQL 4-18 4-18 Instance Management Instance Management Oracle Instance Management SQL EXPLAIN PLAN Oracle Management Server Oracle8i Oracle8i Oracle Management Server Oracle8i Oracle8i Oracle8i 2 DBA Management Pack 4-5
DBA Management Pack 4-1 Instance Management REDO Oracle8i 4-6 Oracle Enterprise Manager
DBA Management Pack 4-2 Instance Management Oracle Management Server INIT<SID>.ORA Oracle Enterprise Manager DBA Management Pack 4-7
DBA Management Pack SQL SQL EXPLAIN PLAN PREPARED CPU : DBMS_JOB 4-8 Oracle Enterprise Manager
DBA Management Pack Schema Management DBA Management Pack Schema Management Oracle Schema Management Java Oracle8i 4-3 Schema Management DBA Management Pack 4-9
DBA Management Pack 4-4 1 4-10 Oracle Enterprise Manager
DBA Management Pack Schema Management Schema Management Security Management DBA Management Pack Security Management 4-5 DBA Management Pack 4-11
DBA Management Pack 4-6 Security Management Security Management Security Management 4-12 Oracle Enterprise Manager
DBA Management Pack Security Management Security Management Security Management Oracle8 / DBA Management Pack 4-13
DBA Management Pack Storage Management DBA Management Pack Storage Management REDO 4-7 Storage Management 4-14 Oracle Enterprise Manager
DBA Management Pack Storage Management 5 5 REDO 4-8 Storage Management DBA Management Pack 4-15
DBA Management Pack REDO REDO REDO REDO REDO REDO Replication Management Replication Management DBA Studio Oracle Replication Management Replication Management DBA Studio 4-16 Oracle Enterprise Manager
DBA Management Pack JServer Management JServer Oracle8i Java Java CORBA EJB DBA Studio CORBA EJB Java main() Cache Management Cache Manager Oracle8i Cache Oracle8i Cache Web ERP Oracle8i Cache Oracle8i Cache Oracle8i Cache Oracle8i Cache Cache Manager 1 1 DBA Management Pack 4-17
DBA Management Pack SQL*Plus Worksheet SQL PL/SQL SQL*Plus Oracle SQL*Plus Worksheet Oracle SQL*Plus Worksheet SQL PL/SQL DBA SQL*Plus Worksheet SQL*Plus Worksheet 50 SQL*Plus Worksheet SQL*Plus Worksheet Enterprise Manager : DBA Management Pack Oracle Enterprise Manager DBA Management Pack / / DBA DBA Management Pack Quick Tour Oracle Enterprise Manager 4-18 Oracle Enterprise Manager
5 Oracle Management Pack Oracle Enterprise Manager 1 Management Pack Oracle Enterprise Manager Management Pack Oracle Enterprise Manager Oracle Diagnostics Pack Oracle Tuning Pack Oracle Change Management Pack Oracle Standard Management Pack Oracle Management Pack for Oracle Applications Oracle Enterprise Manager Oracle Enterprise Manager Oracle Applications Manager Oracle Enterprise Security Manager Oracle8i intermedia Text Oracle Parallel Server Manger Oracle Spatial Index Advisor Oracle Directory Manager Oracle Distributed Access Manager Oracle Management Pack 5-1
Oracle Diagnostics Pack Oracle Developer Server Forms Manager Oracle Management Pack Oracle Diagnostics Pack Oracle Diagnostics Pack Oracle Diagnostics Pack : Oracle Enterprise Manger 2.2 E-Business Management Apache i AS Web Oracle Diagnostics Pack Oracle Advanced Events Oracle Performance Manager Oracle Capacity Planner Oracle TopSessions Oracle Trace E-Business Management Tools Oracle Advanced Events Enterprise Manager Diagnostics Pack Enterprise Manager 5-2 Oracle Enterprise Manager
Oracle Diagnostics Pack Oracle Enterprise Manager EMS EMS Oracle Enterprise Manager Oracle Diagnostics Pack Microsoft SQL Server Windows NT Oracle Advanced Events : : : : : SQL : SQL Oracle Management Pack 5-3
Oracle Diagnostics Pack Microsoft SQL Server Microsoft SQL Server Compaq Tru64 HP-UX IBM AIX Solaris Windows NT Web Web Oracle E-Business Management Tools Advanced Event Oracle Performance Manager Performance Manager Oracle Server 5-4 Oracle Enterprise Manager
Oracle Diagnostics Pack Oracle Capacity Planner Oracle TopSessions Performance Manager Diagnostics Pack Capacity Planner Performance Manager Capacity Planner CPU 1 TopSessions n TopSessions I/O SQL SQL SQL EXPLAIN PLAN Oracle Trace Trace Oracle Server Trace API Trace Oracle Management Pack 5-5
Oracle Diagnostics Pack Trace Trace Manager Trace Data Viewer Trace Manager Trace API Trace Trace Manager Oracle Management Server Trace Trace Oracle Server 7.3.3 Data Viewer Trace Data Viewer Trace Trace Data Viewer SQL E-Business Management Tools Oracle E-Business Management Tools E-Business Tools Web E-Business E-Business Tools E-Business Web Oracle Enterprise Manager 2.2 Web Apache HTTP Server 1.3.9 Oracle i AS 1.0 E-Business Tools 2.2 Web Web Oracle Enterprise Manager Web Web Web Web Apache Web Oracle i AS Web Web I/O Web Web Oracle E-Business Management Tools Web 2 Web Web 5-6 Oracle Enterprise Manager
Oracle Diagnostics Pack Web Apache Server Access Log Traffic Web Apache HTML Apache Web HTML Apache Server Access Log Traffic 1 1 Oracle Performance Manager Web Web Performance Overview Performance Overview I/O I/O I/O Oracle Management Pack 5-7
Oracle Tuning Pack Server Utilization Server Utilization Oracle Tuning Pack Oracle Tuning Pack SQL 6 Oracle Tuning Pack Oracle Tuning Pack Oracle Tuning Pack Oracle Oracle Expert Oracle Index Tuning Wizard Oracle SQL Analyze Oracle Tablespace Map Reorg Wizard Oracle Expert Oracle Tuning Pack Oracle Expert 5-8 Oracle Enterprise Manager
Oracle Tuning Pack Oracle Expert Oracle Expert 3 SGA I/O SQL / Oracle Expert Oracle Expert Oracle Oracle Expert Oracle Expert Oracle Expert Oracle Tuning Pack Oracle SQL Analyze Oracle Expert Oracle SQL Analyze Oracle Tuning Pack SQL Oracle Expert Oracle SQL Analyze SQL Oracle Index Tuning Wizard Oracle Tuning Pack Oracle Tuning Pack Oracle Management Pack 5-9
Oracle Tuning Pack Oracle SQL Analyze SQL Oracle Expert Oracle Tuning Pack SQL Oracle SQL Analyze Oracle SQL Analyze SQL SQL Analyze SQL I/O SQL SQL SQL SQL Analyze Oracle SQL Analyze SQL SQL SQL SQL EXPLAIN PLAN SQL 1 EXPLAIN PLAN SQL Analyze EXPLAIN PLAN EXPLAIN PLAN SQL Analyze EXPLAIN PLAN SQL Analyze 1 CPU SQL Analyze Oracle8i SQL Analyze SQL SQL SQL SQL SQL Analyze 2 SQL 2 EXPLAIN PLAN 5-10 Oracle Enterprise Manager
Oracle Tuning Pack Oracle Tablespace Map SQL SQL Oracle Tuning Pack Oracle Tablespace Map Tablespace Map Oracle Tablespace Map ID ID Tablespace Map 1 Reorg Wizard Oracle Tuning Pack Reorg Wizard Reorg Wizard Reorg Wizard Reorg Wizard 3 Oracle Reorg Wizard Oracle Management Pack 5-11
Oracle Change Management Pack Oracle Agent Oracle Enterprise Manager : Reorg Wizard Oracle Enterprise Manager Oracle Management Server Agent Agent Oracle Change Management Pack Oracle Change Management Pack Oracle Server Oracle Change Management Pack Oracle Oracle Change Management Pack Oracle Change Management Pack 1 2 Change Management Pack Oracle Change Management Pack 2 5-12 Oracle Enterprise Manager
Oracle Change Management Pack 1 Oracle Change Management Pack Oracle Change Management Pack Oracle Change Management Pack Change Manager Change Manager Oracle Change Management Pack Change Manager Change Management Pack SQL DDL SQL DDL CASE Compare Database Objects 2 1 Oracle Management Pack 5-13
Oracle Change Management Pack DB Quick Change DB Quick Change 1 1 1 DB Alter DB Alter 1 1 1 1 DB Propagate DB Propagate 1 1 DB Propagate 1 TEST TEST 5-14 Oracle Enterprise Manager
Oracle Management Pack for Oracle Applications Plan Manager Plan Manager Oracle Change Management Pack Oracle Change Management Pack Oracle Standard Management Pack Oracle Standard Management Pack Oracle Workgroup Server Oracle8i Management Pack Oracle Standard Management Pack Oracle Diagnostics Pack Oracle Tuning Pack Oracle Change Management Pack 1 Oracle Standard Management Pack Oracle Oracle Standard Management Pack Oracle Oracle Performance Manager: Oracle Oracle TopSessions: Oracle Index Tuning Wizard: Oralce Create Baseline: Oracle Compare Database Objects: Oracle Advanced Events: Oracle Enterprise Manager Oracle Management Pack for Oracle Applications Oracle Management Pack for Oracle Applications Oracle Applications Oracle Enterprise Manager Oracle Applications Oracle Enterprise Manager Oracle Applications Oracle Management Pack 5-15
Management Pack for Oracle Applications Oracle Applications Oracle Performance Manager: Oracle Applications Forms Oracle Capacity Planner: Forms Concurrent Processing Tuning Assistant: Oracle Applications Advanced Events: Oracle Enterprise Manager Management Pack for Oracle Applications Oracle Enterprise Manager Oracle Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Applications Manager Oracle Applications Manager Oracle Applications Oracle Applications Manager Oracle Applications Oracle Applications 5-16 Oracle Enterprise Manager
Oracle Enterprise Security Manager Oracle Enterprise Security Manager Oracle Advanced Security Oracle8i Enterprise User Security LDAP SSL Oracle8i Oracle8i Enterprise Security Manager Oracle Internet Directory Oracle8i intermedia Text Oracle8i intermedia Text Oracle8i intermedia Oracle Oracle8i intermedia Text Oracle Server Oracle8i intermedia Text SQL Oracle8i intermedia Text Oracle Oracle8i intermedia Text Oracle Oracle8i intermedia Text intermedia Text Oracle Management Server Oracle Management Pack 5-17
Oracle Parallel Server Manger Oracle Parallel Server Manager Oracle Parallel Server Parallel Server Parallel Server Schema Management Security Management Storage Management Parallel Server Parallel Server Parallel Server Parallel Server Parallel Server Parallel Server DBA Parallel Server Parallel Server Oracle Spatial Index Advisor Oracle Spatial Index Advisor Advisor Oracle Spatial Index Advisor Advisor Oracle Directory Manager Oracle Directory Manager Oracle Internet Directory Java Oracle Directory Manager Oracle Distributed Access Manager Oracle Distributed Access Manager Oralce Oracle Sybase Informix DB2 SQL Server Oracle Oracle 5-18 Oracle Enterprise Manager
Distributed Access Manager Oracle Distributed Access Manager Oralce Oracle Developer Server Forms Manager Oracle Developer Server Forms Manager Forms Forms Load Balancer Load Balancer Forms Metrics Metrics Forms Server Forms Forms Server Load Balancer CPU Forms Oracle Management Pack 5-19
5-20 Oracle Enterprise Manager
A Windows Windows A-1 Windows [F1] Windows [Ctrl]+[Esc] [Ctrl]+[Alt]+[Del] [Del] [Shift]+[Del] [Ctrl]+[N] [Ctrl]+[O] [Ctrl]+[P] [Ctrl]+[S] Microsoft Windows Microsoft Windows NT Windows NT A-1
[Ctrl]+[X] [Ctrl]+[Insert] [Ctrl]+[C] [Shift]+[Insert] [Ctrl]+[V] [Alt]+[Back Space] [Ctrl]+[Z] [Alt]+[Shift]+[Back Space] Windows +[M] [Shift] A-2 Oracle Enterprise Manager
Advanced Events Oracle Diagnostics Pack Oracle Management Pack for Oracle Applications Applications Manager Oracle Enterprise Manager Oracle Applications Oracle Applications Capacity Planner Oracle Diagnostics Pack Change Management Pack Oracle Enterprise Manager Management Pack Oracle Server DB Alter Oracle Change Management Pack 1 1 DB Propagate Change Management Pack 1-1
DB Quick Change Change Management Pack 1 1 DBA Management Pack Oracle Enterprise Manager DBA Studio DBA Studio DBA Management Pack SQL*Plus Worksheet Oracle Management Server Developer Server Forms Manager Oracle Enterprise Manager Forms Forms Load Balancer Load Balancer Diagnostics Pack Oracle Enterprise Manager Management Pack Directory Manager Oracle Enterprise Manager Oracle Internet Directory Distributed Access Manager Oracle Enterprise Manager Oralce Enterprise Security Manager Oracle Enterprise Manager LDAP Oracle Expert Oracle Expert -2
Index Tuning Wizard Oracle Tuning Pack Instance Management DBA Management Pack Intelligent Agent 3 Oracle Management Server Oracle Management Server Oracle Management Server Management Pack for Oracle Applications Oracle Enterprise Manager Management Pack Oracle Applications Oracle Expert Oracle Tuning Pack Oracle Management Server Oracle Enterprise Manager Management Server Management Server Oracle Management Server Management Server 1 Management Server Management Server 1 Oracle Trace Oracle Diagnostics Pack Oracle -3
Oracle8i intermedia Text Oracle Enterprise Manager Oracle Parallel Server Manager Oracle Enterprise Manager Oracle Parallel Server Performance Manager Oracle Diagnostics Pack Oracle Plan Manager Oracle Change Management Pack Change Management Pack Change Management Pack Replication Manager Oracle Enterprise Manager Oracle Replication Schema Management DBA Management Pack Security Management DBA Management Pack Spatial Index Advisor Oracle Enterprise Manager SQL Analyze Oracle Tuning Pack SQL -4
SQL*Plus Worksheet DBA Management Pack SQL PL/SQL Standard Management Pack Oracle Enterprise Manager Management Pack Oracle Workgroup Server Oracle8i Oracle Enterprise Manager Diagnostics Pack Tuning Pack Change Management Pack 1 Storage Management DBA Management Pack REDO Tablespace Manager Oracle Tuning Pack TopSessions Oracle Diagnostics Pack Trace Data Viewer Oracle Trace Oracle Trace Trace Manager Oracle Trace Oracle Trace API Oracle Trace Tuning Pack Oracle Enterprise Manager Management Pack SQL -5
Event 1 Event Management System Oracle Enterprise Manager Import Wizard DBAManagement Pack Oracle Export Wizard DBAManagement Pack Oracle Oracle Pane Oracle Enterprise Manager 4 1 / Managed Service/Managed Target 1 Managed Node Intelligent Agent Administrative User Oracle Enterprise Manager 1 Oracle Enterprise Manager UNIX root Windows NT Administrator -6
Oracle Enterprise Manager Oracle Group Oracle Enterprise Manager Privilege Oracle Enterprise Manager SQL Console Oracle Enterprise Manager 3 1 4 Service Discovery 2 Intelligent Agent Intelligent Agent Intelligent Agent Management Server Intelligent Agent Oracle Intelligent Agent Oracle Intelligent Agent Intelligent Agent Management Server Management Server -7
Fixit Job Job Oracle Enterprise Manager 1 Job Scheduling System Oracle Enterprise Manager Super Administrator 1 Oracle Management Server Task Notification Enterprise Manager Notification Filtering Tree List Oracle Management Server Oracle Enterprise Manager DBA Management Pack Management Pack Find Database Objects Change Management Pack -8
Compare Database Objects Change Management Pack 2 Database Administrator Oracle Enterprise Manager Database User Oracle Enterprise Manager Oracle Enterprise Manager Test Trace Oracle Trace Navigator Oracle Enterprise Manager Oracle Management Server Node Oracle Enterprise Manager 3 Intelligent Agent Filtering Notification Filtering Blackout / Property Sheet -9
Profile Create Baseline Change Management Pack Change Management Pack Repository Oracle Management Server Oracle Repository User Enterprise Manager Management Server Load Wizard DBAManagement Pack Oracle Role -10
8i intermedia Text 5-17 A Advanced Events 5-2 -1 Agent Oracle Intelligent Agent 1-4 Applications Manager 5-16 -1 C Capacity Planner 5-5 -1 CASE 5-13 Change Management Pack 5-12 Change Manager 5-13 CORBA 1-3 1-8 D DB Alter 5-14 DB Propagate 5-14 DBA Management Pack 4-1 DBA Studio 4-2 Diagnostics Pack 5-2 E EMS 3-1 Enterprise Security Manager 5-17 Expert Oracle Expert5-8 I IIOP 1-3 1-8 Index Tuning Wizard 5-9 Intelligent Agent 1-4 1-5 1-8 3-5 intermedia Text 5-17 M Management Pack 5-1 Management Pack for Oracle Applications 5-15 Management Server 1-4 1-11 O Oracle Advanced Events 5-2 Oracle Applications Manager 5-16 Oracle Auto-Analyze 5-10 Oracle Capacity Planner 5-5 Oracle Change Management Pack 5-12 Oracle Diagnostics Pack 5-2 Oracle Enterprise Manager 1-11 Oracle Enterprise Manager 1-3 Oracle Enterprise Manager 2 1-4 Oracle Enterprise Manager 3 1-5 Oracle Enterprise Security Manager 5-17 Oracle Expert 5-8 Oracle Index Tuning Wizard 5-9 Oracle Intelligent Agent 1-4 Oracle Management Pack 5-1 Oracle Management Pack for Oracle Applications 5-15 Oracle Management Server 1-4 1-11 Oracle Parallel Server Manager 5-18 Oracle Performance Manager 5-4 -1
Oracle Security Management 4-11 Oracle SQL Analyze 5-10 Oracle SQL*Plus Worksheet 4-18 Oracle Standard Management Pack 5-15 Oracle Tablespace Map 5-11 Oracle TopSessions 5-5 Oracle Trace 5-5 Oracle Tuning Pack 5-8 Oracle8i intermedia Text 5-17 Oracle8i 4-9 P Parallel Server Manager 5-18 Performance Manager 5-4 Plan Manager 5-15 PL/SQL Oracle SQL*Plus Worksheet 4-18 -5 Q Quick Change Oracle DB Quick Change5-14 R Reorg Wizard 5-11 S Schema Management 4-9 Security Management 4-11 Simple Network Management Protocol SNMP1-5 SQL Oracle SQL*Plus Worksheet 4-18 -5 SQL Analyze 5-10 SQL DDL 5-13 SQL*Plus Worksheet 4-18 SQL 5-10 SQL 5-9 Standard Management Pack 5-15 Storage Management 4-14 Storage Management 4-16 Storage Management 4-15 Storage Management 4-16 Storage Management 4-16 Storage Management 4-16 Storage Management REDO 4-16 T Tablespace Map 5-11 Tcl 3-5 TopSessions 5-5 Tuning Pack 5-8 2-7 Oracle Change Management Pack 5-12 Oracle Diagnostics Pack 5-2 Oracle Enterprise Manager Oracle Applications Manager 5-16 Oracle Applications Server Manager 5-19 Oracle Developer Server Forms Manager 5-19 Oracle Directory Manager 5-18 Oracle Distributed Access Manager 5-18 Oracle Enterprise Security Manager 5-17 Oracle Parallel Server Manager 5-18 Oracle Spatial Index Advisor 5-18 Oracle8i intermedia Text 5-17 Oracle Standard Management Pack 5-15 Oracle Tuning Pack 5-8 5-9 1-15 2-10 1-13 Advanced Events 5-2 2-9 2-8 3-1 3-1 1-8 1-13 3-1 3-8 -2
3-8 3-4 3-6 3-7 3-7 3-10 5-9 Oracle Index Tuning Wizard 5-9 Reorg Wizard 5-11 5-13 5-9 1-16 1-8 4-11 4-11 Windows A-1 GUI 2-1 2-6 4-11 3-9 2-9 5-9 SQL Analyze5-10 1-9 -7 2-8 2-5 1-1 2-7 2-3 2-1 1-5 3-10 Oracle Management Server 1-4 1-11 Oracle Enterprise Manager 1-11 5-10 3-8 1-8 3-1 3-4 3-8 3-1 SQL*Plus Worksheet 4-18 3-5 2-7 3-4 3-4 1-8 2-7 3-2 3-5 3-4 3-4 3-5 3-4 3-6 3-4 3-4 2-7 Oracle Expert5-9 3-5 -3
1-15 3-4 1-14 1-15 2-10 DBA Studio 4-2 Oracle Change Management Pack 5-12 Oracle Diagnostics Pack 5-2 Oracle Enterprise Manager Oracle Applications Manager 5-16 Oracle Applications Server Manager 5-19 Oracle Developer Server Forms Manager 5-19 Oracle Directory Manager 5-18 Oracle Distributed Access Manager 5-18 Oracle Enterprise Security Manager 5-17 Oracle Parallel Server Manager 5-18 Oracle Spatial Index Advisor 5-18 Oracle8i intermedia Text 5-17 Oracle Management Pack for Oracle Applications 5-15 Oracle Standard Management Pack 5-15 Oracle Tuning Pack 5-8 Tcl3-5 5-14 5-13 4-6 5-8 3-6 1-16 / 1-14 5-13 5-16 2-9 5-5 2-3 2-4 SQL*Plus Worksheet 4-18 1-5 4-13 DBA Management Pack 1-16 Oracle Change Management Pack 5-12 Oracle Diagnostics Pack 5-2 Oracle Management Pack for Oracle Applications 5-15 Oracle Standard Management Pack 5-15 Oracle Tuning Pack 5-8 4-14 -5 1-14 1-16 1-16 / 1-14 -9 Security Management 4-13 SQL Analyze 5-10 2-4 -4
5-13 5-13 / 1-14 Security Management 4-12 Oracle SQL Analyze5-10 SQL*Plus Worksheet 4-18 2-9 Oracle Expert5-9 Oracle SQL Analyze 5-10 Security Management 4-13 4-14 -5 3-10 2-10 Oracle SQL*Plus Worksheet 4-18 -5
-6