Oracle Enterprise Manager Oracle Enterprise Manager : A

Transcription

1 : A

2 1.6.0 : A : : Configuration Guide, Release : A : Eric Belden, Muralidharan Bhoopathy, Maureen Byrne, Erik DeMember, Jorge Fox, Jacqueline Gosselin, Todd Guay, Daniela Hansell, Marilyn Hollinger, John Kennedy, Dennis Lee, Priscilla Lee, Nahed Majzoub, Dimitris Nakos, Mark Osborn, Linda Pratt, Hanne Rasmussen, Geoffrey Rego, Bert Rich, Jonathan Riel, Marilyn Roncati, Gaylen Royal, Vipul Shah, and Jon Soule. Copyright Oracle Corporation 1996, 1998 All rights reserved. Printed in Japan. Oracle Corporation ORACLE Oracle Corporation

3 ... vii 1 Windows NT Windows NT SNMP Windows NT Windows NT NT NT NT Windows NT Windows NT DOS NT UNIX Oracle Intelligent Agent root.sh root.sh root.sh UNIX SNMP UNIX $ORATAB/ORATAB UNIX iii

4 UNIX Data Gatherer NT UNIX Windows NT Oracle Intelligent Agent Oracle Names Oracle NT DB Oracle Names DBA SYSDBA UNIX : Windows NT : Oracle catrman Oracle8 Recovery Manager (GUI) iv

5 3 Oracle Diagnostics Pack Oracle TopSessions Oracle Trace Oracle 8 Oracle Trace Oracle 7.3 Oracle Trace Oracle Trace Oracle Trace Oracle Performance Manager Oracle Performance Manager Oracle Performance Manager Oracle Tuning Pack Oracle Tablespace Manager Oracle Expert Oracle SQL Analyze A... A-2... A-2 sqlnet.ora... A-2 tnsnames.ora... A-3... A-4 sqlnet.ora... A-4 tnsnames.ora... A-4 listener.ora... A snmp.ora... A-6 snmp_ro.ora... A-6 snmp_rw.ora... A-7 services.ora... A-7 snmp*.ora... A-7 B... B-2... B-2 v

6 ... B-4... B-4 C... C-2... C-2... C-2... C-2 NT... C-3 SID... C-4... C-5... C-5... C-6 vi

7 viii viii viii ix xi xii vii

8 Enterprise Manager Oracle Oracle Readme Manager Oracle Enterprise 1 Oracle Intelligent Agent 2 3 Oracle Software Manager A B C viii

9 Readme Oracle Enterprise Manager Oracle Oracle Enterprise Manager Oracle Enterprise Manager Change Management Pack Change Management Pack Readme Change Management Pack Oracle Change Management Pack Oracle Management Pack Diagnostics Pack Diagnostics Pack Readme Diagnostics Pack Oracle Performance Manager Oracle Capacity Plannner Oracle Performance Manager Oracle Capacity Planner Oracle Trace Oracle Oracle Trace Oracle Trace Oracle Trace ix

10 Oracle TopSessions Oracle Lock Manager Oracle TopSessions Oracle Lock Manager Tuning Pack Tuning Pack Readme Tuning Pack Oracle Expert Oracle Expert Oracle SQL*Analyze Oracle SQL*Analyze Oracle Tablespace Manager Oracle Tablespace Manager x

11 Oracle Server Oracle Server Oracle Server Oracle Server Oracle Oracle Server Oracle SQL Oracle Server SQL Oracle Server Oracle Server SQL Oracle Oracle Server Oracle Windows NT Oracle Server Oracle Server for Windows NT Oracle Parallel Server Oracle Parallel Server Management Oracle8 Server Oracle Parallel Server Oracle Enterprise Manager Oracle Parallel Server Management : UNIX OPS Oracle Parallel Server Management Oracle Enterprise Manager Oracle Parallel Server xi

12 D: WINDOWS.PRD xii

13 1 Oracle Intelligent Agent 1-2 Windows NT 1-2 Windows NT SNMP 1-2 Windows NT 1-8 UNIX Oracle Intelligent Agent 1-8 root.sh 1-11 UNIX SNMP 1-11 UNIX Oracle Intelligent Agent Oracle Names Oracle NT DB Readme $ORACLE_HOME SYSMAN ADMIN readme 1-1

14 Windows NT Windows NT ORACLE_HOME OracleAgent Data Gatherer Capacity Planner Java Oracle Performance Manager Oracle 1-14 Windows NT Master Agent SNMP SNMP Master Agent SNMP Master Agent Oracle Intelligent Agent SNMP Oracle SNMP Oracle SNMP SNMP Windows NT Windows NT Windows NT listener.ora tnsnames.ora snmp_ro.ora snmp_rw.ora services.ora 1-2

15 Windows NT 1. Windows NT 2. listener.ora SID ORACLE_HOME 3. listener.ora GLOBAL_DBNAME 4. GLOBAL_DBNAME listener.ora TNS_ADMIN tnsnames.ora 5. ORACLE_HOME TNS_ADMIN $ORACLE_HOME net80 ADMIN tnsnames.ora 6. tnsnames.ora <SID>_<hostnames> TNSNAMES.ORA TNSNAMES.ORA : Windows NT NT NT 2-11 ORACLE_HOME NET80 TEMP ORACLE_HOME 1-3

16 Windows NT : Failed to authenticate user NT NT Windows NT 1. Windows NT 2. SYSTEM system NT 1. SYSTEM system

17 Windows NT 5. : a. b. c. d. e. OK 5. OK : NT Windows NT DOS 1-5

18 Windows NT : Net8 SID Net8 Windows NT Windows NT OracleAgent a. 3. b. c. OK Windows NT Windows NT OracleAgent 3. netstart OracleAgent NT dbsnmp 1-6

19 Windows NT DOS DOS DOS DOS DOS DOS net start oracleagent net stop oracleagent net start NT OracleAgent 1. NT NT 2. snmp_ro.ora snmp_rw.ora services.ora snmp_ro.ora snmp_rw.ora ORACLE_HOME NET80 admin services.ora ORACLE_HOME NET80 agent A 3. listener.ora tnsnames.ora ORACLE_HOME/BIN SYSTEM SYSTEM DLL a. SYSTEM b. 4. TCP/IP TCP/IP 1-7

20 UNIX Oracle Intelligent Agent 5. a. snmp_rw.ora b. nmi.trace_level=admin 16 nmi.trace_directory=<oracle > c. ORACLE_HOME/NET80/LOG NMI.LOG NMICONFIG.LOG 6. DNS listener.ora tnsnames.ora a. b. DNS TCP/IP 7. a. net80/admin/sqlnet.ora daemon.trace_level=13 daemon.trace_directory=e: orant net80 trace b. c. d. daemon.trc UNIX Oracle Intelligent Agent Oracle Intelligent Agent Oracle CD-ROM root.sh Oracle Installer root.sh root.sh oratab oratab Oracle Enterprise 1-8

21 root.sh Manager <SID>:<$ORACLE_HOME>:[Y/N] root.sh setuid setuid chown root dbsnmp chmod 755 dbsnmp setuid setuid root.sh Enterprise Manager : setuid root root setuid UNIX UNIX root.sh setuid set root.sh ORACLE_HOME : 1 UNIX Oracle Home 1 : x 1-9

22 root.sh root.sh root.sh 1. cd $ORACLE_HOME/bin dbsnmp $ORACLE_HOME/bin 2. ls -al dbsnmp dbsnmp dbsnmp ls -al -rwsr-xr-x 1 root g Jun 12 21:04 dbsnmp root dbsnmp g651 root -rwsr-xr-x root.sh root.sh SID Oracle oratab oratab 1-11 Oracle SID root.sh oratab 1. root su root 2. $ORACLE_HOME/orainst cd $ORACLE_HOME/orainst 3. root.sh./root.sh 4. <SID>:<$ORACLE_HOME>:[Y/N] root.sh 1-10

23 UNIX UNIX SNMP Master Agent SNMP Master Agent SNMP Master Agent Oracle Intelligent Agent SNMP Oracle SNMP Oracle SNMP SNMP UNIX $ORATAB/ORATAB snmp_ro.ora snmp_rw.ora services.ora : tnsnames Net8 SID tnsnames.ora listerner.ora C-4 SID 1. Oracle SID oratab oratab /etc /var/opt/oracle 2. oratab Oracle listener.ora 1-11

24 UNIX 3. listener.ora GLOBAL_DBNAME 4. GLOBAL_DBNAME listener.ora TNS_ADMIN tnsnames.ora tnsnames.ora $ORACLE_HOME/network/admin Solaris tnsnames.ora /var/opt/oracle UNIX tnsnames.ora /etc $TNS_ADMIN 5. TNS_ADMIN tnsnames.ora $ORACLE_HOME/NETWORK/admin 6. tnsnames.ora <SID>_<HOSTNAME> TNSNAMES.ORA TNSNAMES.ORA : $ORATAB/ORATAB $ORATAB/ORATAB UNIX 733 ORATAB v732:/u01/oracle/product/7.3.2:n v733:/u02/oracle/product/7.3.3:y v732 v733 SID ORACLE_HOME y n oratab $ORATAB setenv ORATAB /etc/oratab ORATAB /etc/oratab 1-12

25 UNIX UNIX UNIX lsnrctl UNIX lsnrctl UNIX UNIX lsnrctl dbsnmp_start lsnrctl dbsnmp_stop lsnrctl dbsnmp_status ORACLE_HOME/net80/agent/doc/readme.wri ORACLE_HOME/network/agent/doc/readme.wri readme UNIX lsnrctl dbsnmp_status 1. UNIX ORACLE_HOME/NETWORK/log/dbsnmp*.log 2. Oracle ORACLE_HOME/AGENT/LOG ORACLE_HOME/NETWORK/AGENT 3. snmp_ro.ora,snmp_rw.ora services.ora snmp_ro.ora snmp_rw.ora ORACLE_HOME/NETWORK/ADMIN services.ora ORACLE_HOME/NETWORK/AGENT A listener.ora tnsnames.ora oratab 1-13

26 4. snmp_rw.ora nmi.trace_level=admin 16 nmi.trace_directory=<oracle > nmi.trace_file=agent 5. snmp_ro.ora snmp_rw.ora services.ora a. dbsnmp INTERNAL SYS catsnmp.sql catsnmp.sql catalog.sql dbsnmp b. SID SID oratab SID catsnmp.sql c. snmp_ro.ora snmp_rw.ora dbsnmp/dbsnmp backupts.sql : tcl TCL Oracle Oracle Data Gatherer Oracle Capacity Planner Java Oracle Performance Manager

27 Oracle Data Gatherer Gatherer Manager Oracle Data Oracle Data Gatherer Oracle Data Gatherer Oracle Capacity Planner Oracle Performance OracleData Gatherer Oracle Data Gatherer Oracle Data Gatherer Oracle Data Gatherer Data Gatherer Oracle Data Gatherer Data Gatherer OracleHome Oracle Data Gatherer Capacity Planning Oracle Data Gatherer OracleHome Oracle Data Gatherer odg/reco $ORACLE_HOME/odg/reco Oracle Data Gatherer Capacity Planner Oracle Data Gatherer OracleHome Oracle Capacity Planner 1-15

28 Oracle Data Gatherer Oracle Capacity Planner OracleHome NT UNIX UNIX NT vppcntl vppcntl ORACLE_HOME/bin Oracle Data Gatherer Oracle Data Gatherer Oracle Data Gatherer Oracle Data Gatherer Oracle Data Gatherer vppcntl -start vppcntl -stop vppcntl -ping vppcntl -version Windows NT Windows NT DOS Oracle Data Gatherer Windows NT Oracle Data Gatherer OracleDataGatherer Oracle Data Gatherer a. b. c. OK 3. DOS Oracle Data Gatherer net start oracledatagatherer Windows NT Oracle Data Gatherer 1-16

29 Oracle Intelligent Agent Oracle Names OracleDataGatherer 3. DOS Oracle Data Gatherer net stop oracledatagatherer Windows NT vppcntl -ping Oracle Data Gatherer NT Task Manager vppdc ORACLE_HOME odg bin alert_dg.log Oracle Intelligent Agent UNIX vppcntl -ping Oracle Data Gatherer $ORACLE_HOME/odg/bin/alert_dg.log vppcntl -ping OracleDataGatherer Oracle Data Gatherer Oracle Data Gatherer vppcntl -ping Oracle Names Oracle Names listener.ora GLOBAL_DBNAME Oracle Enterprise Manager GLOBAL_DBNAME Oracle Enterprise Manager GLOBAL_DBNAME Names Server GLOBAL_DBNAME Oracle Intelligent Agent listener.ora Oracle Names Server GLOBAL_DBNAME Oracle Names Server 1-17

30 : Net8 DBNAME SID Net8 Oracle Names 2 Oracle Names : Oracle listener.ora GLOBAL_DBNAME catsnmp.sql Oracle catsnmp.sql catalog.sql dbsnmp dbsnmp dbsnmp SNMPAGENT dbsnmp dbsnmp/dbsnmp dbsnmp catsnmp.sql snmp_rw.ora ORACLE_HOME/NET80/ADMIN catsnmp.sql snmp_rw.ora SNMP.CONNECT.<svcname>.NAME = <USERNAME> SNMP.CONNECT.<svcname>.PASSWORD = <password> SNMPAGENT SQL SELECT * FROM dba_roles; 1-18

31 Oracle NT DB SNMPAGENT catsnmp.sql catsnmp.sql SYS INTERNAL : : catsnmp.sql Oracle NT ORACLE_HOME rdbms80 admin catsnmp.sql Oracle NT DB Password Utility ORAPWD80 ORAPWD80 Oracle8 Utility ORACLE_HOME DATABASE PWDSID.ORA SID Oracle8 Oracle8 ORAPWD80 C: > ORAPWD80 FILE=ORACLE_HOME DATABASE PWDSID.ORA PASSWORD=PASSWORD 1-19

32 Oracle NT DB 1-20

33 2 Microsoft Windows NT Windows Oracle Names 2-10 DBA SYSDBA 2-14 Oracle : Readme readme ORACLE_HOME/SYSMAN/ADMIN 2-1

34 Manager Oracle Oracle Enterprise DBA DBA Oracle Oracle readme Readme $ORACLE_HOME SYSMAN ADMIN 1. Oracle Storage Manager 2. DBA OEMREP c: orant database oemrep01.dbf 7. 20M + DB_BLOCK_SIZE 2K 20482K KB (( ) + (2048)) / 1024 = MB 8. OK 2-2

35 9. : 32K : 128K : 0 : Oracle 7.3 Oracle 7.3 DB_BLOCK_SIZE 75% DB_BLOCK_SIZE 2K K K K K DBA 1. Oracle Security Manager 2. DBA

36 OEMREP TEMPORARY temporary_data 5. / Oracle 7.3 DBA 6. : Repository Manager Repository Manager : Oracle Repository Manager DBA Oracle Repository Manager / Manager / Repository 2-4

37 discnode.txt ORACLE_HOME BIN Oracle Diagnostics Pack Oracle Tuning Pack Oracle Change Management Pack Oracle Enterprise Manager Tuning Pack Oracle Diagnostics Pack Oracle Tuning Pack Oracle Change Management Pack Oracle Enterprise Manager Oracle Expert Trace 2-5

38 Enterprise Manager Oracle : 1 1 DBA 1. Enterprise Manager Oracle

39 : Oracle TCP/IP TCP/IP Oracle Intelligent Agent topo_ops.ora Server Oracle Parallel Oracle Intelligent Agent : 2-7

40 : Oracle Intelligent Agent Manager 2 1 Oracle Enterprise *.txt Manager services.ora Oracle Enterprise UNIX NT 1-7 NT UNIX 1-13 : topology.ora topology.ora topology.ora

41 Oracle Names Oracle Intelligent Agent TNSNAMES.ORA Oracle Oracle Names Oracle Names 1. Server 24 Oracle Names Server Oracle Names 2. SQLNET.ORA NAMES.PREFERRED_SERVER 1 Oracle Names Server 3. Oracle Names Server TCP/IP Oracle Names Server 1575 oranamesrvr() oranamesrvr1...oranamesrvr4 Oracle Names Oracle Names : Net8 C-4 SID 2-9

42 DBA DBA Administrator Toolbar : Data Manager Backup Manager Oracle Oracle 2-10

43 SYSDBA : 1. / 2. NT NT UNIX db UNIX sqlplus UNIX / SYSDBA UNIX Windows NT : Oracle 2-11

44 SYSDBA 1. ORACLE UNIX : setenv ORACLE_HOME your_oracle_home setenv ORACLE_SID your_oracle_sid : ORACLE 2. Oracle dbs cd $ORACLE_HOME/dbs 3. ORAPWD $ORACLE_HOME/bin/orapwd file=orapw<sid> password=your_password entries=10 orapw<sid> entries = 10 DBA OPER $ORACLE_HOME/dbs orapw<sid> 1 4. init<sid>.ora init<sid>.ora remote_login_passwordfile=exclusive Server Manager 7. sys/sys_password 8. SYSDBA remote SYSDBA create user remote identified by remote; 9. SYSDBA grant connect, resource to remote; grant sysdba to remote; 10. Server Manager Windows NT : 2-12

45 SYSDBA Oracle Instance Manager 3. SYSDBA OK 9. SYSDBA Oracle Instance Manager SYSDBA ARCHIVELOG NOARCHIVELOG ARCHIVELOG 1. init.ora # Uncommenting the line below will cause automatic archiving if archiving has # been enabled using ALTER DATABASE ARCHIVELOG. # log_archive_start = true # log_archive_dest = %ORACLE_HOME% database archive # log_archive_format = "%%ORACLE_SID%%T%TS%S.ARC" 2. ARCHIVELOG Oracle8 Server 2-13

46 Oracle8 Oracle8 Recovery Manager Recovery Manager Oracle8 Recovery Manager Oracle8 Server Recovery Manager : catrman 1. Oracle Storage Manager 2. DBA 3. : 4. rcvcat

47 Oracle c: orant database rcvcat01.dbf 10M 8. OK Oracle Security Manager 2. DBA 3. : 4. rman rman RCVCAT TEMPORARY_DATA 5. / RECOVERY_CATALOG_OWNER 6. RCVCAT 7. catrman 1. SQL Worksheet 2. user=rman, password=rman 2-15

48 3. create_rman.log 4. Oracle_Home/rdbms/admin catrman Oracle8 Recovery Manager (GUI) SYSDBA Oracle Backup Manager 6. Oracle8 Recovery Manager OK Oracle8 Recovery Manager Oracle Backup Manager user=rman password=rman 9. Manager 10. Oracle Backup Manager Oracle Enterprise 11. Oracle8 Server Recovery Manager 2-16

49 1. regedit 2. SOFTWARE ORACLE OracleSMPConsole szdestcharset 3. szdestcharset A: UNIX $ORACLE_HOME/bin/dbsnmp dbsnmp 1-10 root.sh B: NT 2-11 C: NT system NT NT CreateProcessAsUser() Win32 API 2-17

50 NT Windows NT 1-4 NT NT Windows NT OracleAgent a. b. 3. output from job # lost UNIX $ORACLE_HOME/network/agent catsnmp.sql NT catsnmp.sql 1-18 NT 3.51 SP5 Service Pack 5 readme Microsoft Web A: NT Oracle NT NTFS 2-18

51 1. Windows NT 2. Oracle OK OK B: ping IP TCP/IP ping Oracle Daemon Manager TCP/IP C: DNS listener.ora tnsnames.ora DNS TCP/IP *.log $ORACLE_HOME net80 agent $TEMP $ORACLE_HOME net80 $ORACLE_HOME 2-19

52 2-20

53 2 Microsoft Windows NT Windows Oracle Names 2-10 DBA SYSDBA 2-14 Oracle : Readme readme ORACLE_HOME/SYSMAN/ADMIN 2-1

54 Manager Oracle Oracle Enterprise DBA DBA Oracle Oracle readme Readme $ORACLE_HOME SYSMAN ADMIN 1. Oracle Storage Manager 2. DBA OEMREP c: orant database oemrep01.dbf 7. 20M + DB_BLOCK_SIZE 2K 20482K KB (( ) + (2048)) / 1024 = MB 8. OK 2-2

55 9. : 32K : 128K : 0 : Oracle 7.3 Oracle 7.3 DB_BLOCK_SIZE 75% DB_BLOCK_SIZE 2K K K K K DBA 1. Oracle Security Manager 2. DBA

56 OEMREP TEMPORARY temporary_data 5. / Oracle 7.3 DBA 6. : Repository Manager Repository Manager : Oracle Repository Manager DBA Oracle Repository Manager / Manager / Repository 2-4

57 discnode.txt ORACLE_HOME BIN Oracle Diagnostics Pack Oracle Tuning Pack Oracle Change Management Pack Oracle Enterprise Manager Tuning Pack Oracle Diagnostics Pack Oracle Tuning Pack Oracle Change Management Pack Oracle Enterprise Manager Oracle Expert Trace 2-5

58 Enterprise Manager Oracle : 1 1 DBA 1. Enterprise Manager Oracle

59 : Oracle TCP/IP TCP/IP Oracle Intelligent Agent topo_ops.ora Server Oracle Parallel Oracle Intelligent Agent : 2-7

60 : Oracle Intelligent Agent Manager 2 1 Oracle Enterprise *.txt Manager services.ora Oracle Enterprise UNIX NT 1-7 NT UNIX 1-13 : topology.ora topology.ora topology.ora

61 Oracle Names Oracle Intelligent Agent TNSNAMES.ORA Oracle Oracle Names Oracle Names 1. Server 24 Oracle Names Server Oracle Names 2. SQLNET.ORA NAMES.PREFERRED_SERVER 1 Oracle Names Server 3. Oracle Names Server TCP/IP Oracle Names Server 1575 oranamesrvr() oranamesrvr1...oranamesrvr4 Oracle Names Oracle Names : Net8 C-4 SID 2-9

62 DBA DBA Administrator Toolbar : Data Manager Backup Manager Oracle Oracle 2-10

63 SYSDBA : 1. / 2. NT NT UNIX db UNIX sqlplus UNIX / SYSDBA UNIX Windows NT : Oracle 2-11

64 SYSDBA 1. ORACLE UNIX : setenv ORACLE_HOME your_oracle_home setenv ORACLE_SID your_oracle_sid : ORACLE 2. Oracle dbs cd $ORACLE_HOME/dbs 3. ORAPWD $ORACLE_HOME/bin/orapwd file=orapw<sid> password=your_password entries=10 orapw<sid> entries = 10 DBA OPER $ORACLE_HOME/dbs orapw<sid> 1 4. init<sid>.ora init<sid>.ora remote_login_passwordfile=exclusive Server Manager 7. sys/sys_password 8. SYSDBA remote SYSDBA create user remote identified by remote; 9. SYSDBA grant connect, resource to remote; grant sysdba to remote; 10. Server Manager Windows NT : 2-12

65 SYSDBA Oracle Instance Manager 3. SYSDBA OK 9. SYSDBA Oracle Instance Manager SYSDBA ARCHIVELOG NOARCHIVELOG ARCHIVELOG 1. init.ora # Uncommenting the line below will cause automatic archiving if archiving has # been enabled using ALTER DATABASE ARCHIVELOG. # log_archive_start = true # log_archive_dest = %ORACLE_HOME% database archive # log_archive_format = "%%ORACLE_SID%%T%TS%S.ARC" 2. ARCHIVELOG Oracle8 Server 2-13

66 Oracle8 Oracle8 Recovery Manager Recovery Manager Oracle8 Recovery Manager Oracle8 Server Recovery Manager : catrman 1. Oracle Storage Manager 2. DBA 3. : 4. rcvcat

67 Oracle c: orant database rcvcat01.dbf 10M 8. OK Oracle Security Manager 2. DBA 3. : 4. rman rman RCVCAT TEMPORARY_DATA 5. / RECOVERY_CATALOG_OWNER 6. RCVCAT 7. catrman 1. SQL Worksheet 2. user=rman, password=rman 2-15

68 3. create_rman.log 4. Oracle_Home/rdbms/admin catrman Oracle8 Recovery Manager (GUI) SYSDBA Oracle Backup Manager 6. Oracle8 Recovery Manager OK Oracle8 Recovery Manager Oracle Backup Manager user=rman password=rman 9. Manager 10. Oracle Backup Manager Oracle Enterprise 11. Oracle8 Server Recovery Manager 2-16

69 1. regedit 2. SOFTWARE ORACLE OracleSMPConsole szdestcharset 3. szdestcharset A: UNIX $ORACLE_HOME/bin/dbsnmp dbsnmp 1-10 root.sh B: NT 2-11 C: NT system NT NT CreateProcessAsUser() Win32 API 2-17

70 NT Windows NT 1-4 NT NT Windows NT OracleAgent a. b. 3. output from job # lost UNIX $ORACLE_HOME/network/agent catsnmp.sql NT catsnmp.sql 1-18 NT 3.51 SP5 Service Pack 5 readme Microsoft Web A: NT Oracle NT NTFS 2-18

71 1. Windows NT 2. Oracle OK OK B: ping IP TCP/IP ping Oracle Daemon Manager TCP/IP C: DNS listener.ora tnsnames.ora DNS TCP/IP *.log $ORACLE_HOME net80 agent $TEMP $ORACLE_HOME net80 $ORACLE_HOME 2-19

72 2-20

73 3 Oracle Diagnostics Pack Oracle Tuning Pack 3-2 Oracle TopSessions 3-3 Oracle Trace 3-5 Oracle Performance Manager 3-7 Oracle Tablespace Manager 3-7 Oracle Expert 3-8 Oracle SQL Analyze Oracle Diagnostics Pack Oracle Change Management Pack Oracle Tuning Pack : Oracle Diagnostics Pack Oracle Tuning Pack Oracle Change Management Pack 3-1

74 Oracle Diagnostics Pack Oracle Diagnostics Pack Oracle Diagnostics Pack Oracle TopSessions 3-2 Oracle TopSessions 3-3 Oracle Trace 3-5 Oracle Performance Manager Oracle TopSessions TopSessions SELECT smptsixx.sql xx $ORACLE_HOME SYSMAN ADMIN Oracle 7.3 Oracle 8.0 smptsi73.sql smptsi80.sql smptsixx.sql 2 catbloxx.sql utlxplxx.sql 2 Oracle Oracle TopSessions 1. SQL Worksheet 2-10 Oracle Enterprise Manager DBA 2. SYS 3-2

75 Oracle Diagnostics Pack 3. SELECT ANY TABLE SYSTEM SYS smptsixx.sql smptsixx.sql smptsixx.sql Oracle TopSessions 5. SQL Worksheet Oracle Trace Oracle Trace / Oracle Trace Oracle Intelligent Agent Oracle Trace Oracle Trace Oracle Trace Oracle Enterprise Manager 3-3 Oracle 8 Oracle Trace 3-4 Oracle 7.3 Oracle Trace 3-4 Oracle Trace 3-4 Oracle Trace 3-5 Oracle 8 Oracle Trace Oracle8 Oracle Trace INITsid.ORA ORACLE_TRACE_ENABLE TRUE 3-3

76 Oracle Diagnostics Pack Oracle 7.3 Oracle Trace Oracle 7.3 Oracle Trace Oracle Trace TRACESVR Oracle Trace DBMS_ORACLE_TRACE_AGENT DBMS_ORACLE_TRACE_USER otrcsvr.sql SYS otrcsvr.sql UNIX $ORACLE_HOME/otrace/admin NT $ORACLE_HOME otracexx admin otrcsvr.sql NT Oracle Trace Oracle Diagnostics Pack Oracle Tuning Pack Oracle Change Management Pack Oracle Trace Oracle Trace Oracle Trace Collection Services Oracle Trace Oracle Trace Oracle Trace Oracle Trace collection_name.dat Oracle Oracle Oracle Trace Oracle Trace Repository Manager DOS vobsh Repository Manager vobsh vobsh vobsh vobsh vobsh -c -o CREATE -p "EPCFMT" 3-4

77 Oracle Diagnostics Pack vobsh vobsh -c -o DROP -p "EPCFMT" vobsh vobsh vobsh -c -o VALIDATE -p "EPCFMT" Oracle Trace Oracle Trace Oracle Trace Oracle Performance Manager 3-5 Oracle Performance Manager 3-6 Oracle Performance Manager Oracle Performance Manager Oracle Performance Manager Oracle Performance Manager Windows Oracle Performance Manager vmmmig.exe $ORACLE_HOME SYSMAN ADMIN vtmusr.txt Oracle Performance Manager vmmmig.exe 3-5

78 Oracle Diagnostics Pack vmmmig my_rep 2. vmm2vtm vtmusr.txt Oracle Performance Manager vmm2vtm Oracle Enterprise Manager Oracle Performance Manager vmm2vtm my_db my_rep my_db Oracle Performance Manager my_db vmm2vtm vmm2vtm vtmusr.txt Manager Oracle Performance Manager Oracle Performance Manager 2 Oracle Performance Oracle Parallel Server Oracle Performance Manager Oracle Performance Manager Oracle7 Parallel Server ops_ctab.sql ops_dbl.sql ops_gdl.sql ops_mon.sql ops_pack.sql 3-6

79 Oracle Tuning Pack $ORACLE_HOME SYSMAN ADMIN Oracle Performance Manager Oracle7 2. Oracle Performance Manager Oracle8 Parallel Server ops_8mon.sql $ORACLE_HOME SYSMAN ADMIN Oracle Performance Manager Oracle8 Parallel Server 3. Oracle Performance Manager Oracle8 Parallel Server Oracle Tuning Pack Oracle Parallel Server Oracle Tuning Pack Oracle Tablespace Manager 3-7 Oracle Tablespace Manager 3-7 Oracle Expert 3-8 Oracle SQL Analyze Tablespace Manager CHAINED_ROWS CHAINED_ROWS 1. SYS 2. $ORACLE_HOME/RDBMS80/ADMIN utlchain.sql Oracle Expert CHAINED_ROWS Oracle Expert Oracle Oracle Expert 3-7

80 Oracle Tuning Pack Oracle Diagnostics Pack Oracle Tuning Pack Oracle Change Management Pack Oracle SQL Analyze Oracle SQL Analyze DBA SQLADMIN SQLADMIN VMQROLE.SQL $ORACLE_HOME SYSMAN ADMIN 1. SQL Worksheet 2. SQL Analyze SYS 3. VMQROLE.SQL SQLADMIN 4. SQL Worksheet SQLADMIN Grant SQLADMIN to < >; 5. SQL Worksheet 3-8

81 A A-1

82 Oracle Intelligent Agent Oracle SQL*Net 1.4 Oracle8 Net8 Oracle Data Manager Oracle Backup Manager Oracle Tablespace Manager SQL* Net V2.3 Net 8 sqlnet.ora ################ # Filename...: sqlnet.ora # Name...: tcpcom.world # Date...: 13-AUG-97 10:09:52 ################ AUTOMATIC_IPC = OFF TRACE_LEVEL_CLIENT = OFF SQLNET.EXPIRE_TIME = 0 NAMES.DEFAULT_DOMAIN = world NAME.DEFAULT_ZONE = world SQLNET.CRYPTO_SEED = " " SQLNET.AUTHENTICATION_SERVICES = (NONE) DAEMON.TRACE_LEVEL = 16 DAEMON.TRACE_DIRECTORY = c: orant network trace sqlnet.ora tnsnames.ora world world : world world DAEMON 3 DAEMON.TRACE_LEVEL OFF A-2

83 HOME NET80 TRACE ORACLE_HOME C: ORANT DAEMON.TRACE_DIRECTORY ORACLE_ daemon.trc tnsnames.ora ################ # Filename...: tnsnames.ora # Name...: LOCAL_REGION.world # Date...: 13-AUG-97 10:09:52 ################ mydb.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcpcom.world) (PROTOCOL = TCP) (Host = myhost) (Port = 1526) ) ) (CONNECT_DATA = (SID = mysid) (GLOBAL_NAME = mydb.world) ) ) : mysid SID mydb global_name world world Net8 tnsnames.ora $ORACLE_HOME/network/admin $ORACLE_HOME/net80/admin Solaris tnsnames.ora /var/opt/oracle UNIX tnsnames.ora /etc $TNS_ADMIN A-3

84 Oracle Oracle Intelligent Agent sqlnet.ora ################ # Filename...: sqlnet.ora # Name...: myhost.world # Date...: 13-AUG-97 10:09:52 ################ AUTOMATIC_IPC = ON TRACE_LEVEL_CLIENT = OFF SQLNET.EXPIRE_TIME = 0 NAMES.DEFAULT_DOMAIN = world NAME.DEFAULT_ZONE = world SQLNET.CRYPTO_SEED = " " SQLNET.AUTHENTICATION_SERVICES = (ALL) sqlnet.ora tnsnames.ora world world : world world tnsnames.ora ################ # Filename...: tnsnames.ora # Name...: LOCAL_REGION.world # Date...: 13-AUG-97 10:09:52 ################ mydb.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcpcom.world) (PROTOCOL = TCP) (Host = myhost) (Port = 1526) ) ) A-4

85 ) (CONNECT_DATA = (SID = mysid) (GLOBAL_NAME = mydb.world) ) listener.ora ################ # Filename...: listener.ora # Name...: myhost.world # Date...: 13-AUG-97 10:09:52 ################ mylsnr = (ADDRESS_LIST = (ADDRESS = (PROTOCOL=IPC) (KEY= mydb.world) ) (ADDRESS = (PROTOCOL=IPC) (KEY= mysid) ) (ADDRESS = (COMMUNITY = tcpcom.world) (PROTOCOL = TCP) (Host = myhost) (Port = 1526) ) ) STARTUP_WAIT_TIME_mylsnr = 0 CONNECT_TIMEOUT_mylsnr = 10 TRACE_LEVEL_mylsnr = OFF SID_LIST_mylsnr = (SID_LIST = (SID_DESC = (SID_NAME = mysid) (ORACLE_HOME = /myoraclehome) ) ) listener.ora SQL*Net mylsnr Oracle mysid UNIX $ lsnrctl start mylsnr A-5

86 SQL*Net listener ) mylsnr snmp.ora ################ # Filename...: snmp.ora.sample ################# snmp.visibleservices = (mydb_name.world, myhost_name_mylsnr.world) snmp.index.mydb_name.world = 1 snmp.index.myhost_name_mylsnr.world = 2 snmp.contact.mydb_name.world = contact_info snmp.contact.myhost_name_mylsnr.world = contact_info snmp.sid.mydb_name.world = server_id snmp.oraclehome.mydb_name.world=$oracle_home nmi.register_with_names=false nmi.trace_level = 0 nmi.trace_directory = $ORACLE_HOME net80 trace dbsnmp.address = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost_ name)(port=1748))) dbsnmp.spawnaddress =(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost_ name)(port=1754))) snmp.ora tnsnames.ora snmp.ora Oracle Network Manager Network Topology Generator snmp_ro.ora snmp_rw.ora snmp_ro.ora snmp_ro.ora Windows NT $ORACLE_ HOME net80 admin UNIX $ORACLE_ HOME/network/admin SNMP.VISIBLESERVICES = (LISTENER, service_name1, service_name2,...) SNMP.SID.service_name = server_id SNMP.ORACLEHOME.service_name = ORACLE_HOME_DIR A-6

87 snmp_rw.ora snmp_rw.ora Windows NT $ORACLE_HOME net80 admin SNMP.INDEX.service_name = unique_index_number SNMP.CONTACT.service_name.world = "contact_info" NMI.REGISTER_WITH_NAMES = FALSE NMI.TRACE_LEVEL = OFF USER ADMIN nn TCP/IP SNMP.CONNECT.service_name.USER = user_name SNMP.CONNECT.service_name.PASSWORD = password SNMP.DBPOLLTIME = nn DBSNMP.IPCTIME = nn NMI.TRACE_DIRECTORY = directory NMI.TRACE_FILE = filename NMI.LOG_DIRECTORY = directory NMI.LOG_FILE = filename services.ora services.ora Windows NT $ORACLE_HOME net80 agent UNIX $ORACLE_ HOME/network/agent Oracle : services.ora snmp*.ora snmp_ro.ora snmp_rw.ora snmp.ora A-7

88 service_name tnsnames.ora host_name world : sqlnet.ora.world snmp.ora tnsnames.ora.world service_name.world host_name_lsnr.world SNMP.VISIBLESERVICES = (service_name1.world, service_name2.world,...) Names Server SNMP.INDEX.service_name.world = index_number SNMP tnsnames.ora snmp.index.<service_name1>=10 snmp.index.<service_name2>=20 SNMP.SID.service_name.world = server_id ID SID SNMP.CONNECT.service_name.world.USER = user_name dbsnmp catsnmp.sql SNMP SNMP SNMP NetWare dbsnmp/dbsnmp A-8

89 SNMP.CONNECT.service_name.world.PASSWORD = password dbsnmp catsnmp.sql SNMP SNMP SNMP NetWare dbsnmp/dbsnmp SNMP.ORACLEHOME.service_name.world = ORACLE_HOME_DIR Oracle ORACLE_HOME_DIR SNMP.CONTACT.service_name.world ="contact_info" DBSNMP.POLLTIME = nn 30 DBSNMP.IPCTIME = nn Work Comm ping Work ping Comm Work Comm 30 NT A-9

90 NMI.TRACE_LEVEL = OFF USER ADMIN nn TCP/IP 13 NMI.TRACE_DIRECTORY = directory HOME network trace nmi.trace_level $ORACLE_ NMI.TRACE_FILE = filename NMI.LOG_DIRECTORY = directory NMI.LOG_FILE = filename dbsnmp Windows NT : dbsnmp.address =(ADDRESS=(PROTOCOL=protocol) (HOST=host_name)(PORT=port_ no))) TNS TCP/IP PORT= IANA Oracle TCP A-10

91 7.3.3 tnsnames.ora dbsnmp.spawnaddress =(ADDRESS= (PROTOCOL=protocol) (HOST=host_ name)(port=spnport_no))) RPC TNS spnport_no port_no PORT= IANA Oracle TCP DBSNMP.ADDRESS A-11

92 A-12

93 B B-1

94 PC ORACLE_HOME Windows NT Windows NT ORACLE_HOME orant orant bin DLL orant dbs orant otrace... Oracle Trace orant sysman... orant sysman admin SQL orant sysman admin rdbms70, rdbms71, rdbms72, rdbms73, rdbms80 TopSessions SQL Oracle orant sysman admin tcl tcl orant sysman bmp orant sysman doc HTML.htm toc.htm B-2

95 orant sysman expert Oracle Expert orant sysman ifiles Oracle Instance Manager orant sysman ocm160 Change manager orant sysman ole2 NT orant sysman osm10 Oracle Software Manager orant sysman output orant sysman qtour Expert orant sysman scripts Quick Tour DBA SQL Tcl orant sysman sdk Software Developer s Kit (SDK) orant sysman temp orant sysman vtm160 Oracle Performance Manager orant sysman vtp160 Oracle Capacity planner : temp B-3

96 orant net80... orant net80 admin SQL*Net orant net80 log orant net80 trace ORACLE_HOME Windows NT Windows NT ORACLE_HOME orant orant agentbin orant net80 admin snmp_ro.ora dbsnmp snmp_rw.ora orant net80 log nmiconf.log orant net80 mesg orant net80 agent *.q services.ora orant rdbms80 admin SQL catsnmp.sql dbsnmp B-4

97 SNMPAGENT catsnmp.sql catalog.sql catnsnmp.sql catsnmp orant net80 agent config Tcl orant net80 agent doc readme orant net80 agent events oracle oracle orant net80 agent jobs oracle oracle orant net80 agent mibs MIB orainit.mib orant net80 agent packages Oracle Software Manager orant net80 agent tcl Tcl B-5

98 B-6

99 C Oracle EnterpriseManager Readme $ORACLE_HOME SYSMAN ADMIN 1.x.x. 8.x.x 1.x.x ORACLE_HOME 1.x.x ORACLE_HOME NT 8.x.x readme C-2 C-5 C-5 C-6 C-1

100 Oracle Installer Oracle Installer Windows ORACLE_HOME SYSMAN OLE2.REG.OCX.OCX 1. DOS ORACLE_HOME BIN 2. DIR *.OCX.OCX 3..OCX REGSVR32 name.ocx name.ocx : regsvr32 vojt.ocx Windows NT UNIX ORACLE_HOME/network/log/dbsnmp*.log Windows NT 1 C-2

101 NT OS Windows NT snmimsg.mc OS 01 OracleAgent Service Control Handler 02 OracleAgent Service Control Manager 03 OracleAgent 04 OracleAgent 05 OracleAgent 06 OracleAgent 07 OracleAgent nmiconf.tcl nmiconf.log 08 OracleAgent Oracle CORE 09 OracleAgent Oracle NLS 10 OracleAgent Oracle SQL*Net %1 11 OracleAgent DES 12 OracleAgent Oracle Remote Operations 13 OracleAgent Oracle Software Manager 14 OracleAgent dbsnmp.ver 15 OracleAgent / 16 OracleAgent 17 OracleAgent 18 OracleAgent SNMP 19 OracleAgent SNMP 20 OracleAgent 21 OracleAgent SNMP 22 OracleAgent MIB 23 OracleAgent MIB C-3

102 24 OracleAgent SID SID SID sqlnet tnsnames.ora SQL*Plus Net8 Net8 Assistant sqlnet 2.x Oracle Network Manager/SQL*NET easy config sqlnet TCP/IP scott-pc ORCL SID scott.world scott.world= (Description= (Address_list= (Address= (community=tcp.world) (protocol=tcp) (host=scott-pc) (port=1521) ( (Address= (community=tcp.world) (protocol=tcp) (host=scott-pc) (port=1526) ) ) (connect_data= (SID=ORCL) ) ) SQL*Plus sqlplus> connect username/password@scott SQL*Plus sqlplus> SQL*Plus SQL*NET C-4

103 Personal Oracle 7 Windows 95 Windows NT 1. orawin95 net80 admin tnsnames.ora local.world tnsnames.ora local.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = beq.world) (PROTOCOL = BEQ) (PROGRAM = oracle73) (ARGV0 = oracle73orcl) (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))') ) ) (CONNECT_DATA = (SID = ORCL) ) ) PC 4. : tnsnames.ora local.world 5. Databases Repository Manager C-5

104 Manager DOS DOS 1. DOS ORACLE_HOME BIN 2. DOS vobsh 3 1 vobsh 1 Repository vobsh -c "scott/tiger@mydb" -o VALIDATE -p "Enterprise Manager" 3 1 vobsh -b -c cn cn scott/tiger@mydb / -h -o option -p name CREATE DROP VALIDATE Oracle Enterprise Manager Oracle Software Manager Oracle Expert Oracle Trace ALL CONSOLE PERFORMANCE ALL PERFORMANCE CONSOLE Oracle Software Manager name C-6

105 1. 2. [F1] Windows C-7

106 C-8

107 agent Oracle Intelligent Agent agent discovery access (database) Oracle account ID ID application 1 authenticate authorization -1

108 back up batch cache (memory) Oracle Server click client 2 OEM Communication Daemon Oracle Intelligent Agent OEM connect Oracle 1. Console GUI 2. Windows NT Windows 95 OEM -2

109 create Oracle Daemon Manager database 1. Oracle Server REDO Oracle Server database administrator: DBA 2. DBA Oracle 2 TNSNAMES.ORA database name data definition language: CREATE ALTER DROP DDL SQL DLL Windows NT/95 datafile 1 Oracle Data Manager Oracle default -3

110 discovery discovery cache distribution host event Event Management System export Oracle extent file filename Oracle Enterprise fixit job grant -4

111 group Name Server index instance Oracle 2 Oracle integrity constraint Management Pack OEM Oracle Tools Oracle Oracle Enterprise Manager Navigator Name Server node Oracle Intelligent Agent OEM SQLNET RPC SNMP SNMP SNMP Management Information Blocks (MIB) Oracle Oracle Oracle Server Oracle Process OEM Oracle OEM Repository OEM -5

112 OraTcl Oracle Tcl Oracle package 1 package body package specification procedure property sheet SQL PL/SQL Q Q Files Q ereg.q user.q job.q jstat1.q evocc1.q REDO redo log Oracle repository -6

113 role rollback segment scalability schema schema object sequence session Oracle Server UNIX Windows NT Oracle Simple Network Management Protocol (SNMP) 1 snapshot log snapshot -7

114 SQL Worksheet SQL PL/SQL synonym System Global Area: SGA 1 tablespace 1 Tool Command Language: Tcl Tcl topology trigger INSERT UPDATE DELETE PL/SQL user process Oracle Tool 1 view -8

115 C catbloxx.sql Oracle 3-2 catnsnmp.sql B-4 catsnmp.sql 1-18 B-4 D DBA, 2-10 DBA 2-3 dbsnmp.address A-10 DBSNMP.POLLTIME A-9 dbsnmp.spawnaddress A-11 Diagnostics Pack 3-2 discnode.txt 2-5 G GLOBAL_DBNAME L listener.ora A-5 listener.ora 1-17 N NAMES.PREFERRED_SERVER 2-9 NMI.LOG_DIRECTORY A-10 NMI.LOG_FILE A-10 NMI.TRACE_DIRECTORY A-10 NMI.TRACE_FILE A-10 NMI.TRACE_LEVEL A-10 O sysman B B-2 B-4 Oracle Expert 3-7 Oracle Names Oracle Performance Manager 3-5 Oracle TopSessions 3-2 Oracle Trace ORACLE_HOME B-2 Oracle oratab 1-11 R Repository Manager 2-4 root.sh 1-8 root.sh 1-10 S services.ora A-7 setuid 1-9 setuid 1-9 SID, C-4-1

116 smptsixx.sql Oracle TopSessions 3-2 Oracle 3-2 smptsixx.sql 3-2 snmp*.ora A-7 snmp_ro.ora A-6 snmp_rw.ora A-7 SNMPAGENT B-4 SNMP.CONNECT.service_name.world.PASSWORD A-9 SNMP.CONNECT.service_name.world.USER A-8 SNMP.CONTACT.service_name.worl A-9 SNMP.INDEX.service_name.world A-8 snmp.ora A-6 A-6 A-7 SNMP.ORACLEHOME.service_name.world A-9 SNMP.SID.service_name.world A-8 SNMP.VISIBLESERVICES A-8 SQL*Net A-2 sqlnet.ora A-2 A-4 sysman B-2 T Tablespace Manager 3-7 TCP, A-10 TNS_ADMIN tnsnames.ora A-3 A-4 topology.ora 2-8 Tuning Pack 3-7 U utlchain.sql Oracle 3-7 Tablespace Manager 3-7 utlxplxx.sql Oracle 3-2 W Windows NT snmpagent B-4 TCP A-10 UNIX setuid Windows NT UNIX 1-8 Windows NT 1-2 UNIX 1-11 Windows NT B Windows NT Windows UNIX networkagent B-4 DBA

117 topo_ops.ora B Oracle Trace 3-3 SQL Analyze 3-8 Tablespace Manager 3-7 Tuning Pack 3-7, 2-10 listener.ora A-5 services.ora A-7 snmp_ro.ora A-6 snmp_rw.ora A-7 snmp.ora A-6 SQL*Net A-2 sqlnet.ora A-2 A-4 tnsnames.ora A-3 A-4 A-2 A-4 B C B Oracle Expert 3-7 Oracle Trace 3-4 Oracle Trace 3-4 Windows NT 1-3 snmp.ora A-9 A-9, B , B-4 Diagnostics Pack 3-2 Oracle Expert 3-7 Oracle Performance Manager 3-5 Oracle TopSessions

118 Oracle Trace 3-4 SYSDBA SYSDBA