Oracle Diagnostics, Tuning, Change Management Pack日本語リリース・ノート, リリース2.2

Size: px

Start display at page:

Download "Oracle Diagnostics, Tuning, Change Management Pack日本語リリース・ノート, リリース2.2"

こおがしげまつ
4 years ago
Views:

1 Oracle Diagnostics, Tuning, Change Management Pack J : Readme for Oracle Change Management, Diagnostics and Tuning Packs Release A Quick Tour CD-ROM Intelligent Agent Oracle Server Enterprise Manager Intelligent Agent Enterprise Manager Management Server / Intelligent Agent Management Pack Oracle Management Pack Oracle Enterprise Manager Oracle Oracle Oracle Corporation Oracle Enterprise Manager Oracle Corporation Copyright 2000, Oracle Corporation All Right Reserved

2 4.6 DBA Management Pack Oracle Management Server OMS Enterprise Manager Configuration Assistant Enterprise Manager Migration Assistant Enterprise Manager Oracle Change Management Pack Oracle Diagnostics Pack Oracle Tuning Pack Oracle Diagnostics, Tuning, Change Management Pack

3 Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Pack Oracle Management Pack 2.2 Oracle Management Pack Oracle Management Server Oracle Enterprise Manager Migration Assistant Oracle Change Management Pack Oracle Diagnostics Pack SQL Server Monitoring Option * Diagnostics Pack Documentations Oracle Tuning Pack Oracle Enterprise Manager Events Oracle Diagnostics Pack Advanced Events Oracle Management Pack for SAP R/3 Advanced Events * Oracle Management Pack for Oracle Applications Advanced Events Oracle Enterprise Manager Pack Client Oracle DBA Management Pack Oracle Schema Manager Oracle Storage Manager Oracle Security Manager Oracle Instance Manager SQL*Plus Worksheet Oracle DBA Studio

4 Oracle Enterprise Manager Integrated Applications Oracle intermedia Text Manager Oracle Spatial Index Advisor * Oracle Directory Manager Oracle Forms Server Manager Oracle Enterprise Security Manager Net8 Integration Oracle Enterprise Manager Migration Assistant Oracle Enterprise Manager Web Site Oracle HTTP Server a Oracle HTTP Server Extentions Apache Module for Oracle Servlet Engine Oracle Mod PL/SQL Gateway BC4J Runtime Apache Configuration for Oracle XML Developer s Kit Oracle Enterprise Manager Quick Tours Enterprise Manager Documentations Oracle Enterprise Manager Paging Server : 2: * 1.3 Quick Tour CD-ROM Oracle Management Pack 2.2 Quick Tour Quick Tour Quick Tour CD-ROM Enterprise Manager Web MB Installer Windows NT TEMP Solaris /tmp Bug# Oracle Diagnostics, Tuning, Change Management Pack

5 2. / Enterprise Manager Configurations Assistant EMCA EMCA Bug# Oracle Management Pack x Oracle 2.2 Intelligent Agent Oracle Server Oracle Intelligent Agent Intelligent Agent Oracle Intelligent Agent Intelligent Agent Oracle Intelligent Agent Oracle Intelligent Agent Oracle Server Intelligent Agent Agent Oracle Server Intelligent Agent Intelligent Agent v7.3.4 Intelligent Agent v Intelligent Agent v Intelligent Agent v Intelligent Agent v : Management Pack Management Pack 2: Intelligent Agent x Data Gatherer 2. 5

6 2.3 Enterprise Manager Intelligent Agent Oracle Management Pack 2.2 Intelligent Agent Windows NT Intelligent Agent Enterprise Manager 2.x Intelligent Agent 7.3.x 8.0.x Intelligent Agent Intelligent Agent Intelligent Agent Enterprise Manager Management Server / Enterprise Manager DBA Management Pack Management Pack Management Server 2.1 Management Server Management Server 2.2 Management Pack Enterprise Manager Management Server Oracle Enterprise Manager Oracle DBA Management Pack Oracle Tuning Pack Oracle Diagnostics Pack Oracle Change Management Pack Oracle Management Pack for Oracle Applications Oracle Standard Management Pack Management Server Management Server 2.2 Enterprise Manager 2.2 Diagnostics Pack 2.1 Change Management Pack 2.1 Management Server Management Pack Management Server 2.2 Management Pack Oracle Enterprise Manager 6 Oracle Diagnostics, Tuning, Change Management Pack

7 2.5 Intelligent Agent Management Pack Intelligent Agent Intelligent Agent Intelligent Agent Intelligent Agent Oracle Oracle Intelligent Agent 3. Oracle Management Pack Enterprise Manager Oracle Management Pack Performance Manager Capacity Planner Change Manager TopSessions SQL Analyze Index Tuning Wizard Oracle Trace Manager Oracle Trace Data Viewer Oracle Expert Performance Manager Capacity Planner Change Manager Windows TopSessions SQL Analyze Index Tuning Wizard Oracle Trace Manager Oracle Trace Data Viewer Oracle Expert Bug# Oracle Management Pack 7

8 4. Oracle Enterprise Manager 4.1 Oracle Enterprise Manager Enterprise Manager Intelligent Agent DBA Studio DBA Studio Web jar Apache Web Apache for ias Web Apache ias Apache Web Diagnostics Pack Oracle Enterprise Manager 2 Oracle Enterprise Manager Oracle Diagnostics Pack 5 Oracle E-Business Management Tools 7 Oracle Advanced Event Tests 8 Oracle Diagnostics, Tuning, Change Management Pack

9 Intelligent Agent Oracle Enterprise Manager Intelligent Agent Oracle Enterprise Manager Management Server HTML Oracle Enterprise Manager 1 HTML Enterprise Manager 4. Oracle Enterprise Manager 9

10 4.1.7 DBA Studio : DDL DML Replication Manager : DBA Studio JServer DDL 8i DBMS_STATS : / OMS OMS OMS - oms.vdp.ping_interval - oms.vdg.max_out_conns - oms.vdg.max_in_conns - oms.repository.connect_timeout 10 Oracle Diagnostics, Tuning, Change Management Pack

11 - oms.repository.connect_numtries Oracle Enterprise Manager Intelligent Agent NIC : Intelligent Agent NIC / Agent NIC NIC : : nmumigrate Intelligent Agent Data Gatherer Intelligent Agent Data Gatherer Intelligent Agent Enterprise Manager : MS Windows NT : Intelligent Agent Data Gatherer Oracle Intelligent Agent [Alt]+[Tab] Bug# Management Server foo.us.oracle.com Management Server DNS Management Pack 'hosts' Management Server IP Oracle Enterprise Manager 11

12 Bug# OEM. TRACING.ENABLED TRACING.LEVEL $ORACLE_HOME sysman config clientconfig.properties Oracle Enterprise Manager 5. DBA Studio 6. Bug# (&P) (&P) Data Gatherer 12 Oracle Diagnostics, Tuning, Change Management Pack

13 a) EM b) 2. Enterprise Manager 2.2 Intelligent Agent % 60% USERS Intellgent Agent Intelligent Agent EM Intelligent Agent Enterprise Manager Intelligent Agent Enterprise Manager Enterprise Manager 2.2 Intelligent Agent 4. Enterprise Manager Enterprise Manager Enterprise Manager 2.2 Enterprise Manager Oracle Enterprise Manager 13

14 Bug# Windows 2000 Windows 2000 C: winnt temp Windows 2000 TEMP TEMP TEMP TEMP TEMP 7. Oracle Management Server DBA Studio (Bug ) 8. SQL SQL EXTENTMANAGEMENT LOCAL Bug# Bug# Intelligent Agent Windows NT Bug# TCL / convertin convertout Bug# Oracle Diagnostics, Tuning, Change Management Pack

15 2. OEM Bug# Bug# : 07/30/00 : < > Bug# DBA Management Pack 1. "." Bug# listener.ora tnsnames.ora Oracle8i Net8 3. OS / Management Server OS 4. SQL*Plus Worksheet SP Restricted command SQL*Plus OMS OMS SQL*Plus... SQL*Plus Worksheet 5. DBA Studio Replication Management 4. Oracle Enterprise Manager 15

16 6. LONG LONG RAW IOT LONG LONG RAW IOT LONG LONG RAW LONG/LONG RAW 7. SYSDBA NORMAL SYSDBA NORMAL SYSDBA Bug# DBA Studio Enterprise Manager DBA Studio Bug# DBA Studio OK Bug# SQL*Plus Worksheet $ORACLE_HOME sysman config dbappscfg.properties SQLPLUS_NLS_LANG= NLS_LANG SQLPLUS_SYSTEMROOT= %SystemRoot% dbappfcfg.properties < > SQLPLUS_NLS_LANG=Japanese_Japan.JA16SJIS SQLPLUS_SYSTEMROOT=C: WINNT 11. DBA Studio xx.xx% xx.xx % 4.7 Oracle Management Server OMS 1. Windows OMS Windows NT Windows 2000 OMS Enterprise Manager Configuration Assistant EMCA 16 Oracle Diagnostics, Tuning, Change Management Pack

17 OMS EMCA OMS OMS OMS OMS 1) 2) OMS Oracle<Oracle >ManagementServer 3) 2. OMS oemctrl OMS OMS OMS OMS OMS oemctrl Windows NT 2000 OMS Windows NT 2000 OMS OMS $ORACLE_HOME/sysman/log oms.nohup 3. OMS Windows NT 2000 OMS Oracle Enterprise Manager 4. OMS OMS oemctrl oemctrl ping oms OMS 5. Solaris HP OMS Solaris EM HP SQLNET.ORA OMS DISABLE_OOB=ON 4. Oracle Enterprise Manager 17

18 SQLNET.ORA $ORACLE_HOME/network/admin $ORACLE_HOME OMS Sun HP TCP sqlnet OMS 6. Oracle Management Server oemctrl status oms < >/< > VXA Enterprise Manager Configuration Assistant Oracle Enterprise Manager 2.2 Enterprise Manager DBA Studio Management Pack 2.2 EMCA 2. EMCA Configuration Assistant EMCA DBA EMCA EMCA Windows NT 2000 EMCA EMCA OMS 4.9 Enterprise Manager Migration Assistant 1. 1.x Bug# Enterprise Manager 1. Enterprise Manager 1 Web 18 Oracle Diagnostics, Tuning, Change Management Pack

19 2 MSVCRT.DLL MSVCRT.DLL dll dll dll c: winnt40 system32 dll dll Windows NT dll dll dll DOS : 1) dll 2) msvcrt.dll _msvcrt.dll 3) msvcrt.dll 4) 2 Web jar EM 3. Enterprise Manager EM DBA Studio SQL Worksheet 4. Web Enterprise Manager URL >:3339/EmWebSite_xx.html (xx ja ) EmWebSite_xx.html EmWebSite.html >:3339/ URL Oracle intermedia Text Manager 1. Oracle intermedia Text Manager intermedia Text Manager 2. intermedia Text Manager 4. Oracle Enterprise Manager 19

20 3. intermedia Text Manager INDEX_SET Bug# intermedia Text Manager MULTI_STOPLIST MULTI_STOPLIST Bug# intermedia Text Manager ConText Server Job failed: Error Output from job xxx lost. OEM Console ConText Server Bug# Oracle Forms Server Manager 1. Forms Bug# Forms Bug# Oracle Enterprise Security Manager 1. Enterprise Security Manager Enterprise Security Manager Bug# Oracle Parallel Server Manager 1. Parallel Server Bug# Parallel Server Oracle Enterprise Manager Parallel Server Parallel Server Parallel Server Bug# Oracle Enterprise Manager Oracle Parallel Server Bug# Enterprise Manager Enterprise Manager Windows 95 Windows 98 DOS DOS DOS 20 Oracle Diagnostics, Tuning, Change Management Pack

21 Enterprise Manager Bug# JRE Oracle JRE 1 1 Enterprise Manager 2.2 Enterprise Manager JRE Java Runtime Environment JRE o JRE o o Enterprise Manager 2.2 Enterprise Manager 2.2 Enterprise Manager Oracle JRE Enterprise Manager 2.2 CD-ROM CD-ROM JRE o Oracle Universal Installer JRE Installer JRE 3. Enterprise Manager 4. Oracle Enterprise Manager 21

22 5. Oracle Change Management Pack 5.1 Oracle Change Management Pack DB Diff l GUI DOS DOS Oracle Change Management Pack 1. Change Manager Bug# Oracle Diagnostics, Tuning, Change Management Pack

23 2. Oracle 8i Oracle Change Manager Bug# Bug# VBZ$HISTORY object_type object_owner object_name Bug# Oracle7 Server Oracle8 Server ROWID V7 V8 Bug# Bug# Bug# RECOVERABLE ARCHIVELOG ARCHIVELOG ARCHIVELOG RECOVERABLE Bug# Oracle Change Management Pack 23

24 5. Change Manager "set SCRIPTID nnnnnnnn" ID VBZ$JOB_TABLE_SID script_id ID last_step 1 UNDO last_step 1 UNDO Bug# ORA-955 Bug# TCL NLS ASCII Bug# ALTER NEXT_EXTENT Bug# Plan Editor 1. Plan Editor Bug# KB PL/SQL Bug# Oracle Diagnostics, Tuning, Change Management Pack

25 3. Bug# Create Baseline SQL SQL SQL Baseline Viewer Bug# Oracle ASCII ORA Bug# CLI 1. Windows95/98 CLI DOS DOS Bug# Windows95/98 Oracle OMS Bug# Oracle Enterprise Manager Oracle Change Management Pack Oracle Change Management Pack Oracle Change Management Pack Oracle Oracle Change Management Pack 25

26 LOB FLOAT NUMBER(n,n) / : Compare Database Objects 26 Oracle Diagnostics, Tuning, Change Management Pack

27 1 SELECT : [NOT] DEFERRABLE EXCEPTIONS INTO < > Oracle Change Management Pack : SHARED AUTHENTICATED BY STORAGE BUFFER_POOL CREATE SNAPSHOT CLUSTER CREATE SNAPSHOT LOG NOLOGGING : 5. Oracle Change Management Pack 27

28 6. Oracle Diagnostics Pack 6.1 Oracle Diagnostics Pack 2.2 Tuning Pack SQL Analyze SQL Web Apache Web Solaris HP-UX NT Performance Manager Windows NT Performance Manager Capacity Planner Windows NT diskperf -Y Bug# select * ArrayIndexOutOfBoundsException Bug# Bug# Oracle Diagnostics, Tuning, Change Management Pack

29 7. 8. Performance Manager 9. Performance Manager Performance Manager Performance Manager Capacity Planner 1. Intelligent Agent Capacity Planner / 3. Capacity Planner Performance Manager Capacity Planner Agent Data Gatherer 4. 1 Capacity Planner Bug# Capacity Planner Capacity Planner Oracle Diagnostics Pack 29

30 Oracle Enterprise Manager 7. Capacity Planner 8. 1 Capacity Planner Bug# Capacity Planner 2 Capacity Planner Agent Data Gatherer Agent Data Gatherer 12. Capacity Planning Data Gatherer Data Gatherer Data Gatherer Data Gatherer 13. Capacity Planner CapacityPlanner Capacity Planner 14. Capacity Planner Oracle Management Server Oracle Trace Manager 1. Oracle Oracle Trace Manager Oracle Oracle Tcl Oracle Trace Manager $ORACLE_HOME/network/agent/jobs/oracle/otrace/general Oracle Trace Tcl 2. Oracle Trace Manager Oracle8 Oracle 8i Oracle Oracle8 Server SQL*Net 30 Oracle Diagnostics, Tuning, Change Management Pack

31 Oracle Trace Manager Oracle8 SQL*Net 3. < >:< >:<SID> Enterprise Manager 4. Oracle8i Server Connect_Disconnect CACHEIO SQL_Text_Only SUMMARY Wait_Events SQL_Txns_and_Stats ALL DEFAULT EXPERT SQL_and_Wait_Stats SQL_Stats_and_Plan Trace Manager Trace Data Viewer Trace Data Viewer 5. Oracle Trace Trace 6. Oracle Trace Oracle Trace Oracle Bug# Oracle8i Server Oracle Trace Data Viewer 2.x Oracle Trace Manager SQL delete from epc_collection where collection_id = <coll_id> Bug# Intelligent Agent UNIX Oracle Trace Manager Agent Oracle Oracle Trace TCL Bug# Oracle Trace 10. Trace Manager Trace Manager 6. Oracle Diagnostics Pack 31

32 11. Trace Manager Trace Manager Oracle Trace Data Viewer 1. Oracle8 Oracle 8i Oracle Trace init<sid>.ora ORACLE_TRACE_ENABLE TRUE 2. WAIT Oracle Trace Data Viewer timed_statistics DBA Studio 3. Oracle Trace Data Viewer 4. SUN OS Oracle Server CPU Trace Data Viewer Oracle Enterprise Manager Oracle Trace C SELECT_ANY_TABLE SYSTEM 6. Trace Data Viewer 1.x 2.x 1.x 2.x 2.x 1.x Oracle Trace Oracle8 Server CPU Trace CPU Oracle Trace Oracle Enterprise Manager Oracle Trace A $ORACLE_HOME bin otrcfmt.exe 9. CPU CPU Input_IO Output_IO Pagefaults Pagefault_IO Max_resident_set_size NT Oracle8 Server CPU 32 Oracle Diagnostics, Tuning, Change Management Pack

33 Data Viewer / 10. EPC_FACILITY_REGISTRATION Oracle Server XP-21016: : SELECT DISTINCT FACILITY_NUMBER, FACILITY_VERSION, VENDOR FROM EPC_FACILITY_REGISTRATION WHERE COLLECTION_ID - :1 ORA-00942: 11. EPC_FACILITY_REGISTRATION Oracle Enterprise Manager Oracle Trace C Trace Data Viewer 12. Trace Manager XP-21162: ORA-12154: TNS Enterprise Manager tnsnames.ora Enterprise Manager tnsnames.ora 13. SQL Trace Data Viewer SYS SQL Oracle Server Data Viewer Oracle Forms 15. Oracle Trace Manager SQL_text_only SQL SQL SQL_and_Stats Default Oracle Advanced Events 1. Intelligent Agent SUN Solaris IBM AIX HP-UX Tru64 Microsoft NT Enterprise Manager 2.2 OS OS 6. Oracle Diagnostics Pack 33

34 Intelligent Agent Intelligent Agent Data Gatherer 5 Enterprise Manager 3. SysStat SysStat Delta SQL Bug# Bug# % >1 % * Bug# Solaris AIX Compaq Tru64 HP UNIX Intelligent Agent * 7. Windows NT % Bug# Oracle Diagnostics, Tuning, Change Management Pack

35 8. * Intelligent Agent Intelligent Agent Bug# Windows NT Bug# Solaris AIX Compaq Tru64 2 Enterprise Manager Bug# Windows NT NT 13. NT "DISKPERF -Y" 14. Windows 2000 Windows 2000 Agent 6. Oracle Diagnostics Pack 35

36 Bug# Windows NT Windows 2000 O/S Windows 2000 Bug# % % % / DPC % % DPC / DPC DPC / APC / Windows 2000 Windows Windows 2000 Agent Windows Agent Patch # Windows Agent Oracle TopSessions 1. TopSessions TopSessions 2. TopSessions Oracle Diagnostics, Tuning, Change Management Pack

37 3. TopSessions F E-Business Management Tools 1. Windows NT Server Utilization NT Bug# E-Business Management Tools PERL 5 3. Solaris Web Performance Manager Server Utilization/Idle Servers Data Gather ArrayOutofBound Exception Web Bug# : C: C: C: temp C: temp C: temp Bug# Oracle Diagnostics Pack 37

38 7. Oracle Tuning Pack 7.1 SQL Analyze 2.2 : 1 EXPLAIN PLAN SQL Analyze SQL Analyze SQL Analyze EXPLAIN PLAN SQL PL/SQL Tablespace Map Reorg Wizard 2.2 Tablespace Map Tablespace Map Tablespace Map Reorg Wizard HTML Tablespace Map Reorg Wizard SQL Analyze 1. SQL Analyze Oracle Tuning Pack Tuning Pack Tuning Pack Bug# Oracle Diagnostics, Tuning, Change Management Pack

39 1) SQL SQL Analyze 2) SQL Oracle Expert 3) SQL Analyze SQL 2. SQL Analyze SQL SQL Analyze SQLADMIN oracle_home sysman admin VMQROLE.SQL 3. PLAN_TABLE SQL Analyze PLAN_TABLE SQL Analyze PLAN_TABLE SQL Analyze 4. SQL Analyze 3 SQL Analyze SQL SQL SQL SQL SQL Analyze Oracle Expert Oracle Expert SQL SQL SQL Analyze SQL Analyze SQL SQL SQL Analyze SQL SQL SQL Oracle SQL SQL SQL SQL SQL 6. SQL Analyze Schema Manager SQL Analyze SQL Analyze 7. SQL Analyze SQL Analyze SQL Analyze 7. Oracle Tuning Pack 39

40 8. SQL Analyze SQL SQL SQL SQL SQL Analyze SQL REM SQL 9. SQL SQL SQL Analyze SQL 10. TopSQL SQL SYS TopSQL SQL SYS SQL 11. SQL Analyze SQL EXPLAIN PLAN EXPLAIN PLAN EXPLAIN PLAN 12. SQL 13. SQL MINUS UNION * 14. Oracle8 SQL 1/ TopSQL 2/ Diagnostics Pack Performance Manager SQL Analyze 3/ SQL SQL Analyze SQL SQL SQL Analyze SQL SQL 15. SQL Analyze SQL SQL Bug# SQL Analyze PL/SQL Tab Enter Bug# Oracle Diagnostics, Tuning, Change Management Pack

41 7.2.2 Oracle Expert 1. Oracle Expert dba_tab_column dba_constraints dba_users dba_data_files dba_objects dba_indexes dba_segments dba_ind_columns dba_tables dba_rollback_segs dba_sequences dba_views dba_tablespaces dba_synonyms dba_ts_quotas dba_clusters 2. Oracle Expert Oracle Expert PC 3. Oracle Expert Oracle Expert Oracle Expert Oracle Management Server Bug# SYS System Oracle Expert 5. Bug# SQL 8KB SQL 7. Oracle Expert Oracle8 8. DB SQL DB 9. SQL Oracle Expert.xdl Oracle Expert / SQL Bug# Oracle Expert Oracle8i Server BUFFER_POOL_KEEP BUFFER_POOL_RECYCLE 7. Oracle Tuning Pack 41

42 BUFFER_POOL_KEEP=(buffers:nnn, lru_latches:nnn) BUFFER_POOL_RECYCLE=(buffers:nnn, lru_latches:nnn) Bug# Oracle Expert Bug# Tablespace Map Reorg Wizard 1. Tuning Pack 2.1 Oracle Tablespace Manager Tablespace Map Reorg Wizard 2 2. Reorg Wizard LOB LOB Reorg 3. Reorg 4. NOVALIDATE 5. Reorg Wizard 32KB LONG LONG RAW Intelligent Agent Oracle Diagnostics, Tuning, Change Management Pack

Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Packインストレーション・ガイドリリース2.2

Oracle Enterprise Manager Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Pack 2.2 2000 11 : J02263-01 Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Pack 2.2