From:
As an Oracle DBA, you can expect to be involved in the following tasks:
See Also:
■ Chapter 4, "Configuring the Network Environment"
■ Chapter 5, "Managing the Oracle Instance"
■ Chapter 6, "Managing Database Storage Structures"Tools for Administering the Database
Introduction 1-3
■ Installing Oracle software
■ Creating Oracle databases
■ Performing upgrades of the database and software to new release levels
■ Starting up and shutting down the database
■ Managing the storage structures of the database
■ Managing users and security
■ Managing database objects, such as tables, indexes, and views
■ Backing up the database and performing recovery operations when necessary
■ Monitoring the state of the database and taking preventive or corrective action as
required
■ Monitoring and tuning database performance
■ Diagnosing and reporting critical errors to Oracle Support Service
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 of the 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. Tools for Administering the Database
1-4 Oracle Database 2 Day DBA
Database Control also provides an interface for performance advisors and for Oracle utilities such as SQL*Loader and Recovery Manager (RMAN).
After you create a database, either during installation or as a standalone operation, you do not need to create another. Each Oracle instance works with a single database only. Rather than requiring that you to create multiple databases to accommodate different applications, Oracle Database uses a single database, and accommodates multiple applications by enabling you to separate data into different schemas within the single database.
With Oracle Database, you typically have a single database that hosts more than one application. You do not need multiple databases to run multiple applications. Instead, you separate the objects that support each different application into different schemas in the same database. However, there may be situations in which you want to create more than one Oracle database on the same host computer. When you do this with DBCA, the new databases typically use the same Oracle home directory as the first database, but store database data files separately from those of the first database
DBCA also enables you to modify a database configuration, delete a database, and
more. This section describes the following DBCA tasks:
■ Starting DBCA
To start DBCA on UNIX or Linux, or at the command-line prompt on the Windows operating system, enter the following command: dbca
■ Creating a Database Using DBCA
■ Changing the Configuration of a Database Using DBCA
■ Deleting a Database Using DBCA
■ Managing Templates with DBCA
Getting Started with Database Administration
This chapter provides a brief roadmap for administering your database, and introduces you to Oracle Enterprise Manager Database Control (Database Control), the Web-based interface for managing an Oracle database.
This chapter contains the following sections:
■ Managing Your Database: A Roadmap
■ Introduction to Oracle Enterprise Manager Database Control
■ Starting and Stopping the Database Control Console Process
■ Accessing the Database Home Page
■ Granting Access to Database Control for Nonadministrative Users
■ Creating Database Control Administrative Users
■ Setting Database Control Preferences
■ About SQL and SQL-Based Management Tools
■ Getting Started with Oracle Enterprise Manager: Oracle By Example Series
阅读(1508) | 评论(0) | 转发(0) |
