This section describes new features that are documented in this guide and provides pointers to additional information.
Oracle Real Application Clusters (Oracle RAC) Configuration Audit Tool (RACcheck) is available to check your Oracle Database installation.
Note:The RACcheck tool is available starting with Oracle Database 11g Release 2 (188.8.131.52).
Starting with Oracle Database 11g Release 2 (184.108.40.206) you can enter the Proxy Realm information when providing the details for downloading software updates. The proxy realm identifies the security database used for authentication. If you do not have a proxy realm, then you do not have to provide an entry for the Proxy Username, Proxy Password, and Proxy Realm fields. It is case-sensitive.
This proxy realm is for software updates download only.
The following is a list of new features or enhancements provided with Oracle Database 11g Release 2 (220.127.116.11):
Starting with the release of the 18.104.22.168 patch set for Oracle Database 11g Release 2, Oracle Database patch sets are full installations of the Oracle Database software. Note the following changes with the new patch set packaging:
Direct upgrades from previous releases (11.x, 10.x) to the most recent patch set are supported.
Out-of-place patch set upgrades, in which you install the patch set into a new, separate Oracle home, are the best practices recommendation. In-place upgrades are supported but are not recommended.
New installations consist of installing the most recent patch set, rather than installing a base release and then upgrading to a patch release.
This functionality is available starting with Oracle Database 11g Release 2 (22.214.171.124). Use the Software Updates feature to dynamically download and apply software updates as part of the Oracle Database installation. You can also download the updates separately using the
-downloadUpdates option and later apply them during the installation by providing the location where the updates are present.
See Also:"Software Updates Option"
This functionality is available starting with Oracle Database 11g Release 2 (126.96.36.199). Use the In-Place Upgrade feature of Oracle Database Client to upgrade an existing Oracle Database Client 11g Release 2 (11.2) version with the latest Oracle Database Client version.
See Also:Oracle Database Client Installation Guide for Linux for more information about In-Place Upgrade
Transparent Data Encryption (TDE) can automatically detect whether the database host system includes specialized cryptographic silicon that accelerates the encryption or decryption processing. When detected, TDE uses the specialized silicon for cryptographic processing accelerating the overall cryptographic performance significantly.
Starting with Oracle Database 11g Release 2 (188.8.131.52), cryptographic hardware acceleration for TDE is available on Intel Xeon with AES-NI, and for Linux x86 and Linux X86-64 on Oracle Linux 5 and Red Hat Enterprise Linux 5.
The following is a list of new features or enhancements provided with Oracle Database 11g Release 2 (184.108.40.206):
Oracle Database 11g Release 2 introduces the Oracle Grid Infrastructure installation. For single instance databases, Oracle Grid Infrastructure includes Oracle Automatic Storage Management (Oracle ASM), the listener, and Oracle Restart. Oracle Restart is a new feature that provides the ability to monitor, manage, and automatically restart if the Oracle Database environment including the Oracle Database instance, Oracle Automatic Storage Management instance, and listeners fails. In a clustered environment, Oracle Grid Infrastructure includes Oracle Clusterware, Oracle ASM, and the listener.
To use Oracle Grid Infrastructure for a standalone server, you must install the Oracle software from the Oracle Grid Infrastructure media before you install the database.
Oracle Database 11g Release 2 introduces a new option that enables you to specify the type of system on which the database is installed. If you are installing on a laptop or a desktop, then select the Desktop Class option; otherwise, select the Server Class option to install on a server. These options are available on the System Class screen.
There is no difference in the software that gets installed after you select any one option but the Desktop Class option installs a single instance database without the advanced configuration options.
See Also:"Interactive Installation Types" for more information about the desktop and server class options
When time zone version files are updated due to daylight saving time changes, TIMESTAMP WITH TIMEZONE (TSTZ) data could become stale. In previous releases, database administrators ran the SQL script
utltzuv2.sql to detect TSTZ data affected by the time zone version changes and then had to perform extensive manual procedures to update the TSTZ data.
With this release, TSTZ data is updated transparently with minimal manual procedures using newly provided DBMS_DST PL/SQL packages. In addition, there is no longer a need for clients to patch their time zone data files.
Oracle Database Upgrade Guide for information about preparing to upgrade Timestamp with Time Zone data
Oracle Database Globalization Support Guide for information about how to upgrade the Time Zone file and Timestamp with Time Zone data
Oracle Call Interface Programmer's Guide for information about performance effects of clients and servers operating with different versions of Time Zone files
Starting with Oracle Database 11g Release 2 (11.2), Oracle ASM administration must be done with the
SYSASM privilege. The
SYSASM privilege also can be granted using password authentication on the Oracle ASM instance.
You can designate
OPERATOR privileges (a subset of the
SYSASM privileges, including starting and stopping Oracle ASM) to members of the
OSOPER for an Oracle ASM group.
SYSASM privilege for ASM administration creates a clear division of responsibility between ASM administration and database administration. It also provides the optional capability to prevent different databases using the same storage from accidentally overwriting each other's files.
See Also:Oracle Automatic Storage Management Administrator's Guide for more information about the
OSASMoperating system group
Starting with Oracle Database 11g Release 2 (11.2), the Oracle Universal Installer (OUI) detects when minimum requirements for an installation are not completed, and creates scripts, called fixup scripts, to resolve many incomplete system configuration requirements. If OUI detects an incomplete task, then click the Fix & Check Again button to generate the fixup script.
For Oracle Clusterware, you also can have Cluster Verification Utility (CVU) generate fixup scripts before the installation.
The fixup script is generated during the installation. You are prompted to run the script as root in a separate terminal session. When you run the script, it sets some system parameters to Oracle-recommended values, if necessary, and completes other operating system configuration tasks.
Database Smart Flash Cache feature is a transparent extension of the database buffer cache using solid state device (SSD) technology. The SSD acts as a Level 2 cache to the (Level 1) Oracle system global area (SGA).
SSD storage is faster than disk storage, and cheaper than RAM. Database Smart Flash Cache with SSD storage gives you the ability to greatly improve the performance of your Oracle databases by reducing the amount of disk I/O at a lower cost than adding an equivalent amount of RAM.
Database Smart Flash Cache is supported on Oracle Solaris and Oracle Linux only.
Oracle Universal Installer no longer provides the custom installation option of individual components. Use the
chopt tool, a command-line utility that is located in the
/bin directory, to configure the database options.
Use the new deinstallation tool (
deinstall) available as an Oracle Technology Network download (before installation) and in the Oracle home directory (after installation) to remove Oracle Database software.
The Intelligent Data Placement feature enables you to specify disk regions on Oracle ASM disks to ensure that frequently accessed data is placed on the outermost (hot) tracks which provide higher performance.
See Also:Oracle Automatic Storage Management Administrator's Guide for more information about Oracle ASM Intelligent Data Placement
Oracle Automatic Storage Management Cluster File System (Oracle ACFS) is a new multiplatform, scalable file system, and storage management design that extends Oracle ASM technology, to support data that cannot be stored in Oracle ASM, in both single instance and cluster configurations. Additionally, Oracle ACFS provides snapshot functionality for a point in time copy of an Oracle ACFS system.
The software required for Oracle Automatic Storage Management Cluster File System is installed with the Oracle Grid Infrastructure installation.
Oracle Automatic Storage Management Administrator's Guide for more information about Oracle ACFS
Data Pump provides a legacy mode in which you can use original export and import parameters when performing Oracle Data Pump export and import operations.
See Also:Oracle Database Utilities for more information about Data Pump Legacy Mode
Oracle Restart is a new feature included in this release to enhance the availability of Oracle databases in a single-instance environment. If you install Oracle Restart, and there is a temporary failure of any part of the Oracle Database software stack, including the database, listener, and Oracle ASM instance, Oracle Restart automatically restarts the failed component. In addition, Oracle Restart starts all these components when the database host computer is restarted. The components are started in the proper order, taking into consideration the dependencies among components.
See Also:Chapter 4, "Configuring Automatic Restart of an Oracle Database" in the Oracle Database Administrator's Guide for more information about Oracle Restart
In past releases, Oracle ASM was installed as part of the Oracle Database installation. With Oracle Database 11g Release 2 (11.2), Oracle ASM is installed when you install the Oracle Grid Infrastructure components and shares an Oracle home with Oracle Clusterware when installed in a cluster such as with Oracle Real Application Cluster (Oracle RAC) or with Oracle Restart on a single instance database.
If you want to upgrade an existing Oracle ASM, then you must upgrade Oracle ASM by running an Oracle Grid Infrastructure upgrade. If you do not have Oracle ASM installed and you want to use Oracle ASM as your storage option, then you must complete an Oracle Grid Infrastructure installation before you start your Oracle Database installation.
SRVCTL was enhanced to support single-instance databases with Oracle Restart on standalone servers and on clusters with Oracle Clusterware. SRVCTL is a command-line interface used to manage Oracle processes (database instance, listener, Oracle ASM instance) when using Oracle Restart. With SRVCTL, you can manage the Oracle Restart configuration, see the status of processes managed by Oracle Restart, and start or stop processes such as the Oracle Database.
See Also:Chapter 4, "Configuring Automatic Restart of an Oracle Database" in the Oracle Database Administrator's Guide for more information about SRVCTL commands
The following are not supported or not available anymore with Oracle Database 11g Release 2:
Installing data files directly on raw devices is no longer available during installation with Oracle Universal Installer or Database Configuration Assistant. You must use a file system or use Oracle ASM.
Oracle Ultra Search