Using Administration Tools

1
2
Using Administration Tools
2
Objectives

• Using the Server Manager Line Mode
• Identifying administration applications supplied
  with the Oracle Enterprise Manager
• Using Oracle Enterprise Manager components

3
Database 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
4
Starting Server Manager in Line Mode

• On UNIX

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
5
Server 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
6
Server 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
7
Oracle 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
8
Enterprise Manager Console
1
2
3
4
5
6
9
OEM Common Services

• Repository
• Service Discovery
• Security

10
OEM Database Administration Tools
Components needing console
11
OEM Performance Pack
12
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

13
Using Application Interface
4
3
2
1
14
Using SQL Worksheet
1
2
2
3
4
15
Summary

• Using Server Manager in Line Mode
• Using Oracle Enterprise Manager components