Administrative Tools

Oracle provides many tools to assist both DBAs and developers with accomplishing their jobs in a more effective and efficient manner. Several tools can be used to help you maintain your databases. The tools covered by the exam will be covered in this book. Table 2.1 provides the list of tools that will be covered and a brief description of each.

Table 2.1. Oracle Provided Management Tools

Tool	Description
Oracle Universal Installer (OUI)	Java-based graphical user interface used to assist with the installation, upgrade, and removal of Oracle software components.
Oracle Database Configuration Assistant	Java-based graphical user interface that can either interact with OUI or be run independently. Used to create, delete, or modify a database.
Password File Utility	Utility for creating a database password file.
SQL*Plus	Utility used to access data in an Oracle database, alter structures, and perform maintenance.
Oracle Enterprise Manager (OEM)	Graphical user interface used to administer, monitor, tune, and troubleshoot single or multiple databases.