Skip Headers

Oracle9i Database Platform Guide
Release 2 (9.2) for Windows
Part No. B10163-01
Go To Table Of Contents
Contents
Go To Index
Index

Previous Next

G Oracle9i Database for 64-Bit Windows

Oracle9i release 2 (9.2.0.2) for 64-bit Windows supports 64-bit processing in the following operating systems:

This appendix contains:

Unsupported Features on 64-Bit Windows

The following features of Oracle9i database, documented elsewhere in this guide, are not currently supported in the 64-bit version:


See Also:

Oracle9i Database Release Notes for Windows for a complete list of unsupported features in Oracle9i release 2 (9.2.0.2) for 64-bit Windows

Oracle9i Architecture on 64-Bit Windows

Oracle9i release 2 (9.2.0.2) for 64-bit Windows does not support Very Large Memory (VLM) configurations. VLM enables the address space for 32-bit computers to expand beyond its default value of 2 to the power 32 bytes. The default address space for 64-bit computers is already 2 to the power 64 bytes.

Neither Windows XP 64-Bit Edition Version 2003 nor Windows Server 2003 support 4 GB RAM Tuning, so it is not available in Oracle9i release 2 (9.2.0.2) for 64-bit Windows.

Database Tools for 64-Bit Windows

Pro*COBOL, Oracle Portal, and Oracle Migration Workbench are not supported in Oracle9i release 2 (9.2.0.2) for 64-bit Windows.

Oracle Enterprise Manager can manage a 64-bit database from a remote 32-bit computer.

Oracle Universal Installer enables you to edit your environment PATH to make a specific Oracle home directory your primary home when you have multiple active Oracle home directories on a single computer.

  1. Choose Start > Programs > Oracle Installation Products > Universal Installer.

    The Oracle Universal Installer: Welcome window appears.

  2. Click Installed Products.

  3. Select the Environment tab.

  4. Select a primary Oracle home and use the up arrow to move it to the top of the list.

  5. Click Apply.

  6. Click Close.

Backing Up and Recovering 64-Bit Database Files

Legato Networker is not supported in Oracle9i release 2 (9.2.0.2) for 64-bit Windows.

Users and Roles for 64-Bit Windows

Oracle9i release 2 (9.2.0.2) for 64-bit Windows supports enterprise users and roles stored in Oracle Internet Directory, but administration tools must be run from a 32-bit computer.

Configuration Parameters for 64-Bit Windows

To enable large page support, the system administrator must grant the "Lock pages in memory" privilege to the ORACLE user. This privilege is not enabled by default when Windows is installed. To grant this privilege:

  1. Choose Start > Settings > Control Panel.

    The Control Panel window opens.

  2. Double-click Administrative Tools.

    The Administrative Tools window opens.

  3. Double-click Local Security Policy.

    The Local Security Settings window opens.

  4. In the left pane of the Local Security Settings window, expand Local Policies and select User Rights Assignment.

  5. In the right pane of the Local Security Settings window, select Lock pages in memory and choose Action > Security...

    The Local Security Policy Setting dialog opens.

  6. Click Add...

    The Select Users or Groups dialog opens.

  7. Select the ORACLE user from the Name list.

  8. Click Add.

  9. Click OK to close the Select Users or Groups dialog.

  10. Click OK to close the Local Security Policy Setting dialog.

The amount of physical memory must be greater than the amount of System Global Area (SGA) specified in the initialization parameter file.


Caution:

Do not set initialization parameter lock_sga when large pages are enabled. Large page usage locks the entire SGA into physical memory. When used with parameter lock_sga, the database startup will fail with an error because the operating system automatically locks. That is, it prevents memory from being paged to disk when large pages are requested. Physical memory is not released during a shrink operation.


See Also:

Your Windows documentation for restrictions on allocating large pages.

Large pages may not be allocated at all times during instance startup. Oracle currently uses an all or none scheme for large pages. That is, either all of the SGA is allocated using large pages or all of the SGA is allocated using regular pages.

To enable large pages for SGA on an Oracle instance, set instance-specific registry parameter ORA_SID_LPENABLE=1 or ORA_LPENABLE=1. Oracle will then allocate all of the SGA using large pages at startup.


Note:

Although Registry Editor lets you view and modify registry keys and parameter values, you normally are not required to do so. In fact, you can render your system useless if you make incorrect changes. Therefore, only advanced users should edit the registry! Back up your system before making any changes in the registry

When using large pages, Oracle by default allocates the minimum available large page size. On 64-bit platforms, the minimum available large page size (16 MB) is obtained by using the GetLargePageMinimum function.

Oracle9i release 2 (9.2.0.2) for 64-bit Windows Documentation

The Oracle9i Online Documentation Library CD-ROM for Windows and the Oracle9i Online Documentation Library CD-ROM for Windows - Installation CD are not shipped with Oracle9i release 2 (9.2.0.2) for 64-bit Windows. Everything in the library is available for download from the Oracle Technology Network (OTN) at http://otn.oracle.com/documentation/

You must register online before using OTN; registration is free and can be done at http://otn.oracle.com/membership/


Previous Next
Oracle Logo
Copyright © 2003 Oracle Corporation

All rights reserved
Go To Table Of Contents
Contents
Go To Index
Index