Oracle Enterprise Manager

Download Report

Transcript Oracle Enterprise Manager

2
Using Administration Tools
Objectives
• Using the Server Manager Line Mode
• Identifying administration applications
supplied with the Oracle Enterprise
Manager
• Using Oracle Enterprise Manager
components
2-2
Database Administration
Tools: Examples
Tool
Description
Server Manager Line
Mode
A line mode utility used for
administrative tasks like starting
up, shutting down or
recovering a database
Oracle Enterprise
Manager
Graphical user interface to
administer, monitor, and tune
multiple databases.
SQL*Loader
Utility for loading data from
external files into Oracle tables
Export or Import utility
Utility for exporting/importing
data in Oracle format
Password File utility
Utility for creating database
password file
2-3
Starting Server Manager in
Line Mode
On UNIX
svrmgrl
On NT
svrmgr30
Starting and executing a script:
On UNIX
svrmgrl [email protected]
svrmgrl command=“CONNECT scott/tiger”
On NT
svrmgr30 [email protected]
2-4
Server Manager Commands
Category
Commands
Command that do not need
database connection
EXIT
REMARK
SET
SHOW
SPOOL
Commands needing Oracle
privileges
CONNECT/DISCONNECT
DESCRIBE
EXECUTE
SHOW ERRORS
SHOW PARAMETER SHOW
SGA
Commands needing special
Oracle privileges
CONNECT… AS SYSDBA
CONNECT… AS SYSOPER
ARCHIVE LOG
RECOVER DATABASE
STARTUP/SHUTDOWN
2-5
Server Manager
Commands: Examples
Set the column display width
for character or numeric data:
SET CHARWIDTH 20
SET NUMWIDTH 8
Spool output to a file:
SPOOL credb.log
Display current settings:
SHOW ALL
SHOW SPOOL
2-6
Oracle Enterprise Manager (OEM)
Oracle
system
management
applications
Integrated
3rd party
applications
Integrated
customer
applications
Agent
Enterprise Manager Console
Job
system
Event
system
Discovery Security
service
service
Agent
Repository
Managed
systems
2-7
Enterprise Manager Console
1
2
3
4
5
6
2-8
OEM Common Services
• Repository
• Service Discovery
• Security
2-9
OEM Database Administration Tools
Components needing console
2-10
OEM Performance Pack
2-11
Starting and Using OEM
• Create repository automatically by invoking
OEM
• Define services
– Auto discovery
– Manual
• Set up security using preferred credentials
• Use the navigator and launch palette to
invoke applications
2-12
Using Application Interface
4
3
2
1
2-13
Using SQL Worksheet
1
2
3
4
2-14
Summary
• Using Server Manager in Line
Mode
• Using Oracle Enterprise Manager
components
2-15