Oracle 9i Fundamentals I Exam Cram 2

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.

    Категории