1 / 15

Using Administration Tools

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. Database Administration Tools: Examples. Tool Server Manager Line Mode

gratia
Download Presentation

Using Administration Tools

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 SQL*Loader 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=@credb.sql svrmgrl command=“CONNECT scott/tiger” • On UNIX svrmgr30 command=@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/DISCONNECTDESCRIBEEXECUTESHOW ERRORSSHOW PARAMETER SHOW SGACONNECT… AS SYSDBA CONNECT… AS SYSOPER ARCHIVE LOGRECOVER DATABASESTARTUP/SHUTDOWN

  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. Discovery service Oracle Enterprise Manager (OEM) Oracle system management applications Integrated customer applications Integrated 3rd party applications Agent Enterprise Manager Console Event system Security service Job system 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

More Related