1. Oracle Enterprise Manager 2.
3.
SYSDBA
2-14
4. 8.0
5. Oracle Backup Manager
6. Oracle8 Recovery Manager OK Oracle8
Recovery Manager Oracle Backup Manager
7.
8.
user=RMAN password=RMAN
9.
Oracle Enterprise Manager
10. Oracle Backup Manager
11.
Recovery Manager Oracle8 Server
1. regedit
2. SOFTWARE¥ORACLE¥OracleSMPConsole¥Email szDestCharSet
3. szDestCharSet
Oracle Enterprise Manager
A: UNIX
$ORACLE_HOME/bin/dbsnmp dbsnmp
1-10 root.sh
B: NT
2-11
C: NT system
NT
■
■
■
■
NT CreateProcessAsUser() Win32 API
NT Windows NT
1-4 NT
1-4 NT
Windows NT
1.
2. 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 NTFS
NT
1. Windows NT 2. Oracle
3.
4.
5.
6. OK OK
B:
ping IP
TCP/IP
ping Oracle Daemon Manager TCP/IP
C: DNS listener.ora tnsnames.ora
1.
TCP/IP
2. DNS
*.log
$ORACLE_HOME¥net80¥agent $ORACLE_HOME¥net80
$TEMP $ORACLE_HOME
2
Microsoft Windows NT Windows95 Oracle Enterprise Manager
■ 2-2
■ 2-4
■ 2-6 Oracle Enterprise Manager
■ 2-7
■ 2-9 Oracle Enterprise Manager Oracle Names
■ 2-10 Oracle Enterprise Manager DBA
■ 2-11
■ 2-11 SYSDBA
■ 2-14 Oracle8
■ 2-16
■ 2-17
: Oracle Enterprise Manager
Readme readme ORACLE_HOME/SYSMAN/ADMIN
Oracle Enterprise Manager
Oracle Oracle Enterprise
Manager
DBA Oracle
DBA Oracle
Oracle Enterprise Manager Readme readme $ORACLE_HOME¥SYSMAN¥ADMIN
Oracle Enterprise Manager 1. Oracle Storage Manager
2. DBA
3.
4. OEMREP
5.
6.
c:¥orant¥database¥oemrep01.dbf 7.
20M + DB_BLOCK_SIZE
2K 20482K
KB ((20 1048576) + (2048)) / 1024 = 20482
1048576 1MB
8. OK
9.
: 32K : 128K : 0 : Oracle 7.3 Oracle 7.3
DB_BLOCK_SIZE 75%
10.
DBA
1. Oracle Security Manager
2. DBA
3.
4.
DB_BLOCK_SIZE
2K 121 90
4K 249 186
8K 505 378
16K 1017 762
32K 2041 1530
OEMREP
Oracle 7.3 TEMPORARY
temporary_data
5. /
DBA 6.
Oracle Enterprise Manager
Repository Manager Oracle Enterprise Manager
Repository Manager
Repository Manager
: Oracle Enterprise Manager 1.3.5
1 1
: Oracle Repository Manager DBA
Oracle
Oracle Enterprise Manager /
/ Repository
Manager
Oracle Enterprise Manager
Oracle Diagnostics Pack Oracle Tuning Pack Oracle Change Management Pack Oracle Enterprise Manager
Tuning Pack Oracle Enterprise Manager
Oracle Enterprise Manager Oracle
Diagnostics Pack Oracle Tuning Pack Oracle Change 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 discnode.txt
ORACLE_HOME¥BIN
Oracle Enterprise Manager
Oracle Enterprise Manager
Oracle Enterprise Manager Oracle
Enterprise Manager Oracle Enterprise Manager
Oracle Enterprise Manager
■
■
1. Enterprise Manager 2.
3. Oracle Enterprise Manager
Oracle 4.
: Oracle Enterprise Manager 1
1 DBA
Oracle Enterprise Manager
Oracle Enterprise Manager
Oracle :
TCP/IP 7.3.3
TCP/IP 7.3.3
Oracle Intelligent Agent 7.3.3
topo_ops.ora
Oracle Parallel Server
7.3.3 Oracle Intelligent Agent
:
1. Oracle Enterprise Manager
2. 1
2
1 Oracle Enterprise
Manager *.txt
3.
4.
services.ora Oracle Enterprise
Manager
NT 1-7 NT
UNIX 1-13
UNIX
Oracle Enterprise Manager 1.4.0 7.3.3
topology.ora 7.3.3
: 8.0.4.1 Oracle Intelligent Agent 8.0.4.1
: Oracle Enterprise Manager topology.ora topology.ora
Oracle Enterprise Manager Oracle Names
1. Oracle Enterprise Manager 2.
3. 7.3.3 Oracle Intelligent Agent
4.
5. TNSNAMES.ORA
6.
7.
Oracle Enterprise Manager Oracle Names
Oracle Enterprise Manager
Oracle Oracle Names
1.
24 Oracle Names Server Oracle Names
Server
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
Oracle Enterprise Manager DBA
Oracle Enterprise Manager DBA
1 Oracle Enterprise Manager
Oracle Oracle
3
■
■
■
1. Oracle Enterprise Manager
2. Oracle Enterprise Manager 3.
Administrator Toolbar
:
Backup Manager Data Manager
SYSDBA
1. Oracle Enterprise Manager
/ 2.
NT NT
UNIX db UNIX
sqlplus
UNIX /
SYSDBA
Oracle Enterprise Manager
UNIX Windows NT
:
SYSDBA
UNIX :
1. ORACLE
setenv ORACLE_HOME your_oracle_home setenv ORACLE_SID your_oracle_sid
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
5.
6. 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 :
: ORACLE
SYSDBA
1. Oracle Enterprise Manager
2. Oracle Instance Manager
3. SYSDBA
4.
5.
6.
7.
8. 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
Oracle8
Oracle8
Recovery Manager Recovery Manager
Oracle8 Recovery Manager
Recovery Manager Oracle8 Server
: Oracle Enterprise Manager
■
■
■ catrman
1. Oracle Storage Manager
2. DBA
3.
4. rcvcat
5.
: Oracle Enterprise Manager
Oracle8
6.
c:¥orant¥database¥rcvcat01.dbf 7.
10M
8. OK
9.
1. Oracle Security Manager
2. DBA
3.
4.
rman
rman
RCVCAT
TEMPORARY_DATA
5. /
RECOVERY_CATALOG_OWNER 6.
RCVCAT 7.
: Oracle Enterprise Manager
3. create_rman.log
4. Oracle_Home/rdbms/admin catrman
Oracle8 Recovery Manager (GUI)
1. Oracle Enterprise Manager 2.
3.
SYSDBA
2-14
4. 8.0
5. Oracle Backup Manager
6. Oracle8 Recovery Manager OK Oracle8
Recovery Manager Oracle Backup Manager
7.
8.
user=RMAN password=RMAN
9.
Oracle Enterprise Manager
10. Oracle Backup Manager
11.
Recovery Manager Oracle8 Server
1. regedit
2. SOFTWARE¥ORACLE¥OracleSMPConsole¥Email szDestCharSet
3. szDestCharSet
Oracle Enterprise Manager
A: UNIX
$ORACLE_HOME/bin/dbsnmp dbsnmp
1-10 root.sh
B: NT
2-11
C: NT system
NT
■
■
■
■
NT CreateProcessAsUser() Win32 API
NT Windows NT
1-4 NT
1-4 NT
Windows NT
1.
2. 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 NTFS
NT
1. Windows NT 2. Oracle
3.
4.
5.
6. OK OK
B:
ping IP
TCP/IP
ping Oracle Daemon Manager TCP/IP
C: DNS listener.ora tnsnames.ora
1.
TCP/IP
2. DNS
*.log
$ORACLE_HOME¥net80¥agent $ORACLE_HOME¥net80
$TEMP $ORACLE_HOME
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 Tuning Pack Oracle Change Management Pack
: Oracle Diagnostics Pack Oracle Tuning Pack Oracle Change Management Pack