DBA TASKS AND TOOLS

Common Oracle DBA Tasks

As an Oracle DBA, you can expect to be involved in the following tasks:

• Installing Oracle software
• Creating an Oracle database
• Upgrading the database and software to new releases
• Starting up and shutting down the database
• Managing the storage structures of the database
• Managing users and security
• Managing schema objects, such as tables, indexes, and views
• Making database backups and performing database recovery, when necessary
• Proactively monitoring the condition of the database and taking preventive or corrective actions, as required
• Monitoring and tuning database performance
• Diagnosing and reporting critical errors to Oracle Support Services

Tools for Administering the Database

The goal of this guide is to enable you to quickly and efficiently create an Oracle database, and to provide guidance in basic database administration.

The following are some products, tools, and utilities you can use to achieve your goals as a database administrator:

• Oracle Universal Installer : Oracle Universal Installer (OUI) is a utility that installs your Oracle software and options. It can automatically start Oracle Database Configuration Assistant to install a database.

• Oracle Database Configuration Assistant : Oracle Database Configuration Assistant (DBCA) is a utility that 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 new database.

• Database Upgrade Assistant : The Database Upgrade Assistant is a tool that guides you through the upgrade of your existing database to a new Oracle Database release.

• Net Configuration Assistant : Net Configuration Assistant (NETCA) is a utility that enables you to configure listeners and naming methods, which are critical components of the Oracle Database network.

• Oracle Enterprise Manager Database Control :The primary product for managing your database is Oracle Enterprise Manager Database Control (Database Control), a Web-based interface. After you have installed the Oracle Database software, created or upgraded a database, and configured the network, you can use Database Control to manage your database. Database Control also provides an interface for performance advisors and for Oracle utilities such as SQL*Loader and Recovery Manager (RMAN).