What's New in Oracle Database 11g

The following is a list of new features or enhancements provided with Oracle Database 11g:

New Components Available for Installation

The following are the new components available while installing Oracle Database 11g:

See Also:

The following sections and guides for more information:

Changes in the Install Options

The following are install option changes for Oracle Database 11g:

See Also:

The following sections and guides for more information:

Database Configuration Assistant

The following additions and enhancements are made to Database Configuration Assistant:

Added Support to Configure New Database Options

The following options in Oracle Database 11g can be configured using Database Configuration Assistant:

Automatic Memory Management

This is a new initialization parameter in Oracle Database 11g to automate the memory allocation. By default, Database Configuration Assistant now uses MEMORY_TARGET instead of specifying individual values for SGA_TARGET and PGA_AGGREGATE_TARGET. The Memory management page of Database Configuration Assistant has a new option to select automatic memory management.

See Also:

The "Using Automatic Memory Management" section of Oracle Database Administrator's Guide

Oracle Base and Diagnostic Destination Configuration

The directory that you specify when you are prompted for ORACLE_BASE by Oracle Universal Installer is stored in the Oracle home inventory. Database Configuration Assistant uses this value to derive the default database locations and the DIAGNOSTIC_DEST parameter. The diagnostic destination location contains all Automatic Diagnostic Repository directories (diagnostic files, such as Alert logs and so on). Starting with Oracle Database Release 11g, the initialization parameter settings for background dump, user dump, and core dump destinations are replaced by the Diagnostic Destination.

See Also:

"Optimal Flexible Architecture" for more information about Oracle base and diagnostic destination configuration

Oracle Data Mining

In Oracle Database 11g, Data Mining metadata is created with the SYS metadata. It is created by the catproc.sql and other scripts that are run as the SYS user. You no longer configure the Data Mining option through the Database Features screen of Oracle Database Configuration Assistant.

See Also:

Oracle Data Mining Administrator's Guide for more information about Oracle Data Mining

Secure Database Configuration

Oracle Database 11g has new defaults for audit and password profiles. Database Configuration Assistant has a new screen to enable the new security settings during the database creation and existing database configuration.

See Also:

The "Database Security Options" for more information

Switching a Database from Database Control to Grid Control Configuration

In previous releases, Database Configuration Assistant contains the functionality to configure a database either with Database Control, or with Grid Control. You can configure a database either while creating it or later. However, reconfiguring a database from Database Control to Grid Control requires significant manual effort. With Oracle Database 11g, Database Configuration Assistant provides the Enterprise Manager Configuration plug-in, which automates the process to switch configuration of a database from Database Control to Grid Control.

See Also:

Oracle Real Application Clusters Installation Guide for Linux and UNIX for more information about configuring Grid Control

Database Upgrade Assistant

The following additions and enhancements are made to Database Configuration Assistant:

Command Line Option to Auto Extend System Files

The command line option AUTOEXTEND facilitates auto extending of the data files as a part of the upgrade. This option automatically extends the data files during the upgrade and turns the autoextend back to its original settings after the upgrade. This option is useful if there is enough space on the disk, and if you do not need to add new data files or manually increase the size of the files.

See Also:

The "Altering a Bigfile Tablespace" section in Oracle Database Administrator's Guide for more information about the AUTOEXTEND clause

Express Edition Upgrade

For single-instance databases, Oracle Database Upgrade Assistant configuration utility enables you to upgrade from Oracle Database Express Edition (Oracle Database XE) to Oracle Database 11g. The XE database files reside under the path ORACLE_BASE/oradata/XE. These files must be copied to a new location as the user may remove the XE Home after upgrade.

Integration with Oracle Database 11g Pre-upgrade Tool

Database Upgrade Assistant uses the new pre-upgrade script for Oracle Database 11g. This script is used to estimate disk space, initialization parameters, statistics gathering, and providing feedback on possible problem areas.

Moving Data Files into ASM, SAN, and Other File Systems

You can move data files to ASM, OFS, or other storage devices, such as Storage Area Networks (SAN) and Network Area Storage (NAS), as part of the upgrade. If you move the database files during the upgrade, then you can benefit from the typical downtime for this tablespace by rebalancing disks and moving files to a better storage device, such as SAN, NAS, or ASM.

See Also:

The Preparing Disk Groups for an Automatic Storage Management Installation for more information about preparing disk groups for Automatic Storage Management

Oracle Base and Diagnostic Destination Configuration

The directory that you specify when you are prompted for ORACLE_BASE by Oracle Universal Installer is stored in the Oracle home inventory. Database Upgrade Assistant uses this value to derive the default database locations and the DIAGNOSTIC_DEST parameter. The diagnostic destination location contains all ADR directories (diagnostic files, such as the alert logs, trace files, and so on). This diagnostic destination directory is required while upgrading an earlier Oracle Database release to Oracle Database 11g release of the database. If the Oracle base directory already exists, then Oracle Database Upgrade Assistant automatically retrieves this information and populates its path. Starting with Oracle Database 11g Release 1, the initialization parameter settings for background dump (BACKGROUND_DUMP_DEST), user dump (USER_DUMP_DEST), and core dump (CORE_DUMP_DEST) destinations are replaced by the Diagnostic Destination (DIAGNOSTIC_DEST).

See Also:

Appendix D, "Optimal Flexible Architecture"for more information about Oracle base and diagnostic destination configuration

Automatic Storage Management Fast Mirror Resync

Automatic Storage Management fast mirror resync quickly resynchronizes Automatic Storage Management disks within a disk group after transient disk path failures, as long as the disk drive media is not corrupted. Any failures that render a failure group temporarily unavailable are considered transient failures. Disk path malfunctions, such as cable disconnections, host bus adapter or controller failures, or disk power supply interruptions, can cause transient failures. The duration of a fast mirror resync depends on the duration of the outage. The duration of a resynchronization is typically much shorter than the amount of time required to completely rebuild an entire Automatic Storage Management disk group.

See Also:

The "Automatic Storage Management Fast Mirror Resync" section in Oracle Database Storage Administrator's Guide for more information about ASM fast mirror resync

SYSASM Privilege for Automatic Storage Management Administration

Oracle Database 11g introduces an optional system privilege, SYSASM, and an optional operating system group, OSASM, to secure privileges to perform Automatic Storage Management administration tasks. Oracle recommends that you use SYSASM instead of SYSDBA for Automatic Storage Management administration, to separate Automatic Storage Management administration from database administration. In a future release, Oracle may restrict access to Automatic Storage Management only to operating system users that are members of the OSASM operating system group, and require the use of SYSASM to administer Automatic Storage Management.

Note:

You can create an operating system group for Automatic Storage Management administrator, in addition to dba and oper groups.

See Also:

The "Authentication for Accessing ASM Instances" section in Oracle Database Storage Administrator's Guide for more information about SYSASM privilege for Automatic Storage Management

Automatic Maintenance Tasks Management

This feature provides out-of-the-box management of scheduling and resource allocation, such as CPU time, among the various database maintenance tasks, such as Automatic Optimizer Statistics Collection and Automatic Segment Advisor. Maintenance tasks are regulated to the extent that end-user activity gets the necessary resources to finish its work.

See Also:

Chapter 24, "Managing Automated Database Maintenance Tasks" of Oracle Database Administrator's Guide for more information about Automatic Maintenance task management

Automatic Diagnostic Repository

The Automatic Diagnostic Repository is a feature added to Oracle Database 11g. It is a new system managed repository for storing and organizing trace files and other error diagnostic data. The Automatic Diagnostic Repository provides a comprehensive view of the critical errors encountered by the database. This feature also enables you to maintain the relevant data needed for problem diagnostics and their eventual resolution. The Automatic Diagnostic Repository reduces the time to resolve errors and code defects. The repository is stored as a directory structure under the ADR base directory that contains the diag directory. The default location of the ADR base directory is set by DIAGNOSTIC_DEST. If the ORACLE_BASE variable is set, then the default value of DIAGNOSTIC_DEST is equal to the value of the ORACLE_BASE variable. If the value of the ORACLE_BASE variable is not set, then the default value of DIAGNOSTIC_DEST is set to $ORACLE_HOME/log. However, this location can be changed by using the DIAGNOSTIC_DEST parameter of the init.ora file.

See Also:

The "Automatic Diagnostic Repository (ADR)" section in Oracle Database Administrator's Guide for more information about the Automatic Diagnostic Repository

Enhanced Optimal Flexible Architecture

The following enhancements are made to the Optimal Flexible Architecture in Oracle Database 11g:

Oracle Base and Oracle Home

In Oracle Database 11g, Oracle Universal Installer prompts you to specify the Oracle base. You can share this Oracle base across all of the Oracle homes you create on the system. Oracle recommends that you share an Oracle base for all of the Oracle homes created by the same user.

Oracle Universal Installer has a list box where you can edit or select the Oracle base. The installer derives the default Oracle home from the Oracle base location you provide in the list box. However, you can change the default Oracle home by editing the location.

When installing Oracle Clusterware, the Oracle Clusterware home should not be under Oracle base. This is because the root.sh script in UNIX operating systems changes the ownership of the parent directories up to the root file system (/) to the root user. If you specify an Oracle Clusterware home under Oracle base, Oracle Universal Installer displays an error.

The following are the changes made in Oracle Database 11g with respect to Oracle base to make it Optimal Flexible Architecture compliant:

See Also:

Oracle Clusterware Installation Guide for Linux for more information about Oracle Clusterware home

Flash Recovery Area and Data File Location

In Oracle Database 10g, the default locations for the flash recovery area and data files are one level above the Oracle home directory. However, in Oracle database 11g, Oracle base is the starting point to set the default locations for flash recovery and data files. However, Oracle recommends that you keep the flash recovery area and data file location on separate disks. To mount the disks you can use the following mount points for flash recovery area and data file location respectively:

$ORACLE_BASE/flash_recovery_area
$ORACLE_BASE/oradata

Oracle recommends you use separate disks for oradata, flash recovery, and the Oracle home.

If you install Oracle RAC, then you must share flash recovery area and data file location among all the nodes.

See Also:

Appendix D, "Optimal Flexible Architecture" for more information about Optimal Flexible Architecture

Oracle Direct Network File System Client

This feature is implemented as a Direct Network File System (NFS) client as a part of Oracle RDBMS Kernel in Oracle Disk Manager library. NAS-based storage systems use NFS to access data. In Oracle Database 10g, NAS storage devices are accessed using the operating system provided kernel NFS driver, which require specific configuration settings to ensure its efficient and correct usage with Oracle. The following are the major problems that arise in correctly specifying configuration parameters:

The following are the main advantages of implementing Oracle Direct NFS client functionality in Oracle RDBMS Kernel:

See Also:

Oracle Clusterware Installation Guide for Linux for more information in Network File System

Deprecated Components in Oracle Database 11g Release 1 (11.1)

The following is a list of components that were part of Oracle Database 10g release 2 (10.2), and are not available for installation with Oracle Database 11g: