Oracle9i Database Platform Guide
Release 2 (9.2) for Windows
Part No. B10163-01
Oracle9i release 2 (188.8.131.52) for 64-bit Windows supports 64-bit processing in the following operating systems:
Windows XP 64-Bit Edition Version 2003
Windows Server 2003
This appendix contains:
The following features of Oracle9i database, documented elsewhere in this guide, are not currently supported in the 64-bit version:
Oracle Connection Manager
Oracle Database Upgrade Assistant
Oracle Enterprise Manager Configuration Assistant
Oracle Migration Workbench
Oracle Objects for OLE
Oracle Open Gateways
Oracle Transparent Gateways
See Also:Oracle9i Database Release Notes for Windows for a complete list of unsupported features in Oracle9i release 2 (184.108.40.206) for 64-bit Windows
Oracle9i release 2 (220.127.116.11) 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 (18.104.22.168) for 64-bit Windows.
Pro*COBOL, Oracle Portal, and Oracle Migration Workbench are not supported in Oracle9i release 2 (22.214.171.124) 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.
> Oracle Installation Products
> Universal Installer.
The Oracle Universal Installer: Welcome window appears.
Click Installed Products.
Select the Environment tab.
Select a primary Oracle home and use the up arrow to move it to the top of the list.
Legato Networker is not supported in Oracle9i release 2 (126.96.36.199) for 64-bit Windows.
Oracle9i release 2 (188.8.131.52) 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.
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:
> Control Panel.
The Control Panel window opens.
Double-click Administrative Tools.
The Administrative Tools window opens.
Double-click Local Security Policy.
The Local Security Settings window opens.
In the left pane of the Local Security Settings window, expand Local Policies and select User Rights Assignment.
In the right pane of the Local Security Settings window, select Lock pages in memory and choose Action
The Local Security Policy Setting dialog opens.
The Select Users or Groups dialog opens.
Select the ORACLE user from the Name list.
Click OK to close the Select Users or Groups dialog.
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
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_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
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 (184.108.40.206) for 64-bit Windows. Everything in the library is available for download from the Oracle Technology Network (OTN) at
You must register online before using OTN; registration is free and can be done at