Oracle® Database

1 Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program Web site at

http://www.oracle.com/accessibility/

Accessibility of Links to External Web Sites in Documentation This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

2 Documentation

For more information, refer to the Oracle Database 10g release 1 (10.1.0.2.0) documentation available at

http://oracle.com/technology/documentation/

3 Location of README Files

Additional component README files are accessible after installation. They are located in:

• ORACLE_BASE\ORACLE_HOME\doc

• ORACLE_BASE\ORACLE_HOME\relnotes

• Product subdirectories in directory ORACLE_BASE\ORACLE_HOME

4 Unsupported Components on 64-Bit Windows

The following components are not supported with 64-bit Windows:

• Business Components for Java (BC4J)

• DCE and CyberSafe Adapter Support

• Entrust PKI Support

• Generic Connectivity

• INSO filters are not supported on Windows XP 64-bit Edition Version 2003 for 64-bit Itanium 2 Systems.

• Java Server Pages

• nCipher Accelerator Support

• Oracle Data Provider for .NET

• Oracle Enterprise Integration Gateways, which include the following:

  • Oracle Procedural Gateway for APPC

  • Oracle Transparent Gateway for IBM DRDA

• Oracle Enterprise Manager Grid Control CD

  A 64-bit Windows version of Oracle Enterprise Manager Grid Control is not available in this release. Use the Linux version of Oracle Enterprise Manager Grid Control from your Linux system to manage the 64-bit Windows computer nodes remotely.

• Oracle Enterprise Manager Java Console

• Oracle Fail Safe

  Oracle Fail Safe is not available with the initial 10g release 1 (10.1) version for 64-bit Windows. Oracle Fail Safe will be available the beginning of September 2004.

• Oracle Messaging Gateway

• Oracle Migration Workbench

  Oracle Migration Workbench can be executed from a 32-bit Windows environment to migrate third party databases, as supported by release 9.2.0.1.7 or higher, to an Oracle Database 10g release 1 (10.1) database installed on a 64-bit computer.

• Oracle Objects for OLE

• Oracle Open Gateways, which include the following:

  • Oracle Transparent Gateway for Sybase

  • Oracle Transparent Gateway for Teradata

  • Oracle Transparent Gateway for Microsoft SQL Server

• Oracle Workflow Builder

  The Oracle Workflow Builder feature of Oracle Workflow Server is not available on the Oracle Database for 64-bit Windows Client CD. It is available only on the Oracle Database for 32-bit Windows Client CD. Using the Workflow Builder from a 32-bit computer to connect to a 64-bit computer is supported.

• Pro*COBOL

5 Preinstallation Step for Windows Server 2003

To use raw partitions or logical drives on Windows Server 2003, you must enable disk automounting. Enable disk automounting for:

• Raw Partitions for Oracle Real Application Clusters (RAC)

• Cluster File System for Oracle Real Application Clusters

• Oracle Clusterware

• Raw partitions for a single-node database

• Logical drives for Automatic Storage Management (ASM)

Follow these steps to enable automounting:

1. Enter the following commands at a command prompt:

   C:\> diskpart
   DISKPART> automount enable
   DISKPART> exit
   
   

2. Restart your computer.

6 Upgrading an Oracle 7.3.4 Database

The following procedures describe how to upgrade an Oracle 7.3.4 database from 32-bit Windows to an Oracle Database 10g release 1 (10.1) for 64-bit Windows.

Direct upgrade is not supported. Complete the following steps to upgrade to the new Oracle Database 10g release:

• Upgrade to Oracle9i Release 2 (9.2)

• Upgrade to Oracle Database 10g Release 1 (10.1)

http://otn.oracle.com/documentation/

7 Upgrading an Oracle9i Database to Oracle Database 10g

If you upgrade an Oracle9i database to Oracle Database 10g release 1, Oracle Flashback features using a timestamp may fail. To work around this problem, enter the following SQL commands from the Oracle Database 10g database:

SQL> DELETE FROM smon_scn_time WHERE orig_thread <> 0;
SQL> COMMIT;

This issue is tracked with Oracle bug 3994270.

8 Invalid packages owned by OLAPSYS

Under certain conditions, two packages owned by the OLAP Catalog schema, OLAPSYS, will be listed as INVALID in your upgraded database. These packages are:

• CWM2_OLAP_AW_CREATE

• CWM2_OLAP_VALIDATE_MAPPING

These packages are obsolete with this release and should be dropped from the database.

DROP PACKAGE OLAPSYS.CWM2_OLAP_AW_CREATE
DROP PACKAGE OLAPSYS.CWM2_OLAP_VALIDATE_MAPPING

9 Services and High Availability in Real Application Clusters

Bug 3636652 affects the creation of services with Database Configuration Assistant (DBCA). If you use DBCA to configure high availability services, then the process fails during the start phase. The failure occurs at approximately when the progress bar indicates that it is 50% complete. At this time, DBCA displays an error message indicating that DBCA could not start the service called service_name.

In addition, the use of SRVCTL commands to start the services that you created with DBCA or SRVCTL also fail with the following errors:

• PRKP-1030: Failed to start the service service_name

• CRS-1006: No more members to consider

• CRS-0215: Could not start resource resource_name

As a workaround, download and install the patched file, racgchsn.exe using the following procedure:

1. Download the patch into a local subdirectory.

2. Rename your original version of the racgchsn.exe file by running the following command:

   rename ORACLE_BASE\ORACLE_HOME\bin\racgchsn.exe ORACLE_BASE\ORACLE_HOME\bin\racgchsn.bk1
   
   

3. Copy the downloaded version of racgchsn.exe into the ORACLE_BASE\ORACLE_HOME\bin directory by running the following command:

   copy download_location\racgchsn.exe ORACLE_BASE\ORACLE_HOME\bin
   
   

If your Oracle home is on a shared cluster file system partition, then you only need to perform this procedure once and you can perform this procedure on any node in your cluster.

If your Oracle home is on a non-shared file system, that is, if your Oracle home is on a file system in which each node has a local copy of the binaries, then perform this procedure on each node in your cluster. After you install the updated racgchsn.exe file, you can use DBCA and SRVCTL to configure and start services.

10 Installing Oracle HTML DB on Windows Server 2003

Bug 3602534

Users installing Oracle HTML DB on Windows Server 2003 should download the env.exe patch and place it in the PATH on the system before proceeding with the installation. The link to the env.exe patch is provided in bug 3602534.

Remove this binary from the system once the Oracle HTML DB installation is complete.

To find and download patches:

1. Go to the OracleMetaLink Web site

   http://metalink.oracle.com/
   

2. Log in to OracleMetaLink.

   
   

   Note: If you are not an OracleMetaLink registered user, then click Register for MetaLink! and follow the registration instructions.

   
   

3. Select Patches on the main OracleMetaLink page.

4. Select Simple Search.

5. Specify the following information, then click Go:

   • In the Search By field, choose Patch Number(s), and enter 3602534.

   • In the Platform or Language field, select Microsoft Windows (64-bit).

6. Review the installation instructions by clicking View README.

7. Return to the patch download page and click Download. Save the patch to a location in the PATH. For example, ORACLE_BASE\ORACLE_HOME\bin.

11 Virtual IP Configuration Assistant

If you choose to perform a software only install in a RAC environment no configurations tools will be executed by Oracle Universal Installer, this includes Virtual IP Configuration Assistant (VIPCA), Network Configuration Assistant and Database Configuration Assistant.

If you decide to run Network Configuration Assistant and or Database Configuration Assistant after the installation, you must first configure and start the VIPs, GSD and ONS applications by running VIPCA. You run VIPCA only once for the cluster.

To start VIPCA execute vipca.bat from the ORACLE_BASE\ORACLE_HOME\bin directory.