Tools for Administering the Database

The intent of this book is to allow you to quickly and efficiently create an Oracle database, and to provide guidance in basic database administration.

The following are some of the products, tools, and utilities you can use in achieving your goals as a database administrator:

• Oracle Universal Installer (OUI)

  The Oracle Universal Installer installs your Oracle software and options. It can automatically launch the Database Configuration Assistant to install a database.

• Database Configuration Assistant (DBCA)

  The Database Configuration Assistant creates a database from templates that are supplied by Oracle, or you can create your own. It enables you to copy a preconfigured seed database, thus saving the time and effort of generating and customizing a database from scratch.

• Database Upgrade Assistant

  This Database Upgrade Assistant guides you through the upgrade of your existing database to a new Oracle release.

• Oracle Net Manager

  Net Manager is an alternate tool for configuring and managing Oracle Database networks.

• Oracle Enterprise Manager

  The primary tool for managing your database is Oracle Enterprise Manager, a web-based interface. After you have installed the Oracle software, created or upgraded a database, and configured the network, you can use Oracle Enterprise Manager for managing your database. In addition, Oracle Enterprise Manager also provides an interface for performance advisors and for Oracle utilities such as SQL*Loader and Recovery Manager.