Using Administration Tools - PowerPoint PPT Presentation

About This Presentation
Title:

Using Administration Tools

Description:

Using Administration Tools Objectives Using the Server Manager Line Mode Identifying administration applications supplied with the Oracle Enterprise Manager Using ... – PowerPoint PPT presentation

Number of Views:244
Avg rating:3.0/5.0
Slides: 16
Provided by: bhe95
Category:

less

Transcript and Presenter's Notes

Title: 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
Write a Comment
User Comments (0)
About PowerShow.com