This chapter describes new and deprecated features of Oracle Database 10g release 2 (10.2) for Windows and provides pointers to additional information. It also retains new and deprecated features information from previous releases to help those users migrating to the current release.
The following sections describe the new features in Oracle Database:
Oracle Database New Features for the list of new features, options, and enhancements of Oracle Database
The README file at the root level of the documentation media for more information about the Oracle Documentation Library
Oracle Database is supported on Windows Vista and Windows Server 2008 with the 10.2.0.4 release. Use the Oracle Database 10g Release 2 (10.2.0.4) for Microsoft Windows Vista and Windows Server 2008 media available in the 10.2.0.4 media pack and the Oracle Technology Network site. Do not install Oracle Database on Windows Vista or Windows Server 2008 using the media for Oracle Database 10g Release 2 (10.2) for Microsoft Windows.
This section contains this topic:
Its new name is Oracle Clusterware.
You can install and use Oracle Clusterware without having to install Oracle Real Application Clusters. At least one server in the cluster must be licensed for Oracle Database 10g.
The following Oracle Database 10g release 2 (10.2) components that were part of Oracle Database 10g release 1 (10.1) are not available for installation with Oracle Database 10g release 2 (10.2):
Instead, use Oracle Database Recovery Manager (RMAN)
Automatic Storage Management enables creation of a single disk group from a collection of individual disk devices.
See Also:Oracle Database Administrator's Guide for more information about Automatic Storage Management
When a user attempts a remote login to an Oracle Database 10g Release 2 (10.2) database, the password is automatically encrypted before it is sent to the remote database.
See Also:"Administering a Database on Windows" in Oracle Database Platform Guide for Microsoft Windows (x64)
Two new utilities, Data Pump Import and Data Pump Export, offer faster transfer of files to and from Oracle databases. The previous file transfer utilities, Import and Export, are retained for use with Oracle databases created with earlier versions of Oracle software.
See Also:"Database Tools on Windows" in Oracle Database Platform Guide for Microsoft Windows (x64)
The Instant Client feature of Oracle Call Interface (OCI) simplifies OCI installation. The activation of Instant Client mode is only dependent on the ability to load the Instant Client data shared library. It requires only two dynamic link libraries to be loaded by the dynamic loader of the operating system.
"OCI Instant Client" in Oracle Call Interface Programmer's Guide
Oracle Database Client Installation Guide for Microsoft Windows (x64)
Large page support provides a performance boost for memory-intensive database instances running on Windows Server 2003. By taking advantage of newly introduced operating system support, Oracle Database now can make more efficient use of processor memory addressing resources.
See Also:"Large Page Support for 64-Bit Windows" in Oracle Database Platform Guide for Microsoft Windows (32-Bit)
Oracle Enterprise Manager 10g Database Control is installed in the same Oracle home as the database and supports standalone Oracle Containers for Java (OC4J) instances.
Oracle Database 2 Day DBA for details about Oracle Enterprise Manager 10g Database Control
Oracle Home Selector is no longer available from the Start menu. Instead, use Oracle Universal Installer, which has functionality similar to Oracle Home Selector.
Oracle Provider for OLE DB 10g Release 2 (10.2) includes the following new features:
Support for Oracle grids
Oracle Provider for OLE DB is grid-enabled, allowing developers to take advantage of Oracle database grid support without having to make changes to their application code.
Support for the following data types introduced with Oracle Database 10g release 2 (10.2):
Support for multiple Oracle homes
You can install Oracle Provider for OLE DB in multiple Oracle homes, starting with Oracle Database 10g Release 2 (10.2). However, being a COM component, only one instance can be active on the computer. This means that the current (latest) installation renders the previous one inactive.
To make multiple homes available, some of the Oracle Provider for OLE DB files now include a version number, and the use of a
ID is required.
See Also:Oracle Provider for OLE DB Developer's Guide
This release includes a new database scheduler, Oracle Scheduler, to provide enterprise scheduling functionality. You can use the
OracleJobScheduler service to start external jobs. This service is disabled by default. To use the external jobs functionality, the administrator must set the user name and password for the user account under which this service must run, and then enable the service.
"The Scheduler" in Oracle Database New Features
"Overview of Scheduler Concepts" in Oracle Database Administrator's Guide
"Using the Scheduler" in Oracle Database Administrator's Guide
"Managing the Scheduler" in Oracle Database Administrator's Guide
Oracle Services for Microsoft Transaction Server supports .NET transactional applications with Oracle Data Provider for .NET through the Oracle Provider for OLE DB, and ODBC.NET through the Oracle ODBC driver.
The following components were renamed in this release:
|Previous Name||New Name|
|Oracle Windows Performance Monitor||Oracle Counters for Windows Performance Monitor|
|Oracle Administration Assistant for Windows NT||Oracle Administration Assistant for Windows|
|Oracle Demos||Oracle Examples|
INTYPE File Assistant (IFA)
Oracle Trace (use SQL Trace and TKPROF in place of Oracle Traces)