Title: Using Administration Tools
12
Using Administration Tools
2Objectives
- Using the Server Manager Line Mode
- Identifying administration applications supplied
with the Oracle Enterprise Manager - Using Oracle Enterprise Manager components
3Database Administration Tools Examples
Tool Server Manager Line Mode Oracle Enterprise
Manager SQLLoader Export or Import utility
Password File utility
Description A line mode utility used for
administrative tasks like starting up, shutting
down or recovering a database Graphical user
interface to administer, monitor, and tune
multiple databases. Utility for loading data
from external files into Oracle tablesUtility
for exporting/importing data in Oracle
format Utility for creating database password file
4Starting Server Manager in Line Mode
svrmgrl
svrmgr30
On NT
Starting and executing a script
svrmgrl command_at_credb.sql svrmgrl
commandCONNECT scott/tiger
On UNIX
svrmgr30 command_at_u16run.sql
On NT
5Server Manager Commands
Category Command that do not need database
connection Commands needing Oracle
privileges Commands needing special Oracle
privileges
Commands EXITREMARK SET SHOWSPOOLCONNECT/DI
SCONNECTDESCRIBEEXECUTESHOW ERRORSSHOW
PARAMETER SHOW SGACONNECT AS SYSDBA CONNECT
AS SYSOPER ARCHIVE LOGRECOVER DATABASESTARTUP/SH
UTDOWN
6Server Manager Commands Examples
SET CHARWIDTH 20 SET NUMWIDTH 8
Set the column display widthfor character or
numeric data
SPOOL credb.log
Spool output to a file
Display current settings
SHOW ALL
SHOW SPOOL
7Oracle Enterprise Manager (OEM)
Oracle system management applications
Integrated customer applications
Integrated 3rd party applications
Agent
Enterprise Manager Console
Event system
Job system
Security service
Agent
Repository
Managedsystems
8Enterprise Manager Console
1
2
3
4
5
6
9OEM Common Services
- Repository
- Service Discovery
- Security
10OEM Database Administration Tools
Components needing console
11OEM Performance Pack
12Starting 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
13Using Application Interface
4
3
2
1
14Using SQL Worksheet
1
2
2
3
4
15Summary
- Using Server Manager in Line Mode
- Using Oracle Enterprise Manager components