Oracle Managing Database Control

When you install Oracle Database 10g, a set of directories and files related to Enterprise Manager is created in the Oracle Home directory:

• emca and emctl utilities are installed in the ORACLE_HOME/bin

• Files that are shared among all instances of the database are stored in   ORACLE_HOME/sysman

• Files that are unique to each instance of the database are stored in   ORACLE_HOME/hostname_sid/

• The log files for the Management Agent for that instance are installed in   ORACLE_HOME/hostname_sid/sysman/log/

• The files required to deploy the Database Control application are installed in the
  ORACLE_HOME/oc4j/j2ee directory structure.

• The emd.properties and emoms.properties files store agent run-time parameters, and   targets.xml lists the configured targets.

You can use the operating system command line to configure Database Control. You can use Enterprise Manager Configuration Assistant (EMCA) to perform the following tasks:

• add or remove the Enterprise Manager configuration, including the management   repository.

Oracle Database 10g introduces a new database process called Manageability Monitor Process (MMON), which records both the database usage statistics and the HWM statistics for various objects.

MMON process is primarily responsible for:

o issuing database alerts
o collecting statistics
o taking snapshots of data into disks

MMON records the various statistics inside the Automatic Workload Repository (AWR), which is a new Oracle Database 10g innovation that stores database performance data.

The related views are:

o DBA_FEATURE_USAGE_STATISTICS to find out the usage statistics    of various features that MMON has stored in the AWR.

o DBA_HIGH_WATER_MARK_STATISTICS to see the HWM statistics    and a description of all the database attributes that the database is    currently monitoring.

Following are the steps to view database usage statistics in the OEM Database Control:

You can migrate directly to the Oracle Database 10g version only if your database is one of the following versions: 8.0.6, 8.1.7, 9.0.1, or 9.2.

You can upgrade to Oracle Database 10g in two ways:

• the traditional manual mode

• by using the Database Upgrade Assistant (DBUA)

Note: The DBUA is a GUI tool, but you can also run it in the silent mode, by using the following command at the operating system level: dbua

Oracle now includes a brand-new tool, called the Upgrade Information Tool, to help you collect various pieces of critical information before you start the upgrade process.

The Upgrade Information Tool provides important information and actions you should do before upgrading the existing database.

Note: In Oracle 10g Release 2, the Pre-Upgrade Information Utility (utlu102i.sql) has been enhanced to provide improved resource estimations for tablespace space usage and elapsed upgrade runtime.

Oracle Database 10g also provides a Post-Upgrade Status Tool (utlu10*s.sql), which gives you an accurate summary of the upgrade process and any necessary corrective steps to be taken.

You can restart a failed database upgrade job from the point where you failed.

If you use the DBUA to upgrade, the script runs automatically. If you are performing a manual upgrade, you need to run the script yourself, after the upgrade process is finished.

Oracle provides the DBUA to facilitate the database upgrade process. You can use the DBUA to upgrade any database configuration, including RAC and standby databases.

The DBUA takes care of the following tasks for you:

• Deletes all obsolete initialization parameters

• Changes the ORACLE_HOME settings automatically

• Runs the appropriate upgrade scripts for your current release

• Configures your listener.ora file

On Windows: Programs | Oracle | Configuration and Migration Tools | Database Upgrade Assistant.

On a UNIX system: simply type dbua

Silent startup: dbua -silent –dbName nina