My Oracle Support Banner

FAQ for Oracle RDBMS Release 9.2.X for Alpha OpenVMS (Doc ID 222553.1)

Last updated on AUGUST 24, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.2 to 9.2.0.8 [Release 9.2]
HP OpenVMS Alpha
Digital Alpha OpenVMS


Purpose

checked for relevance on 29-JUL-2011.



This article provides answers to common questions, and discusses important information for Oracle RDBMS  release 9.2.X on HP Alpha OpenVMS.

Preface:

Oracle 9.2.0.2.0 has a new look compared to all prior releases on OpenVMS.

This release is the first to incorporate a UNIX like directory structure,
the first to utilize the Database Configuration Assistant (DBCA) to create
databases, and the first to rely solely on the Oracle Universal Installer (OUI) for
installations. These enhancements will allow DBAs to transition between
platforms easier.

For more information on the directory structure, configuration files,
and command files see <Note 223105.1>.

For more information on the OUI tool see <Note 224236.1>.

For more information on the DBCA tool see <Note 226184.1>.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 
Section 1. Ordering, Certification and New Features.
====================================================
 What is the Oracle part number for Oracle RDBMS 9.2.0.2.0 for Alpha OpenVMS?
 How long has Oracle RDBMS 9.2.0.2.0 been available on Alpha OpenVMS?
 What versions of Alpha OpenVMS are certified with Oracle RDBMS 9.2.X?
 The current Alpha OpenVMS certification matrix is listed in <Note 62150.1>. 
 
What new features are available with Oracle RDBMS 9.2.X?
 How can I order Oracle RDBMS 9.2.0.2.0 for OpenVMS?
 @What products are included in this release?
 Section 2. Installation Questions.
 =============================================
 What should you do to prepare for this release of Oracle?
 
Where are the OpenVMS-specific Installation and Administration guides
for Oracle RDBMS 9.2.0.2.0?
 
Where should the Oracle RDBMS 9.2.X be installed?
 
What utility do I use to create a database?
 
Section 3. Migration and Upgrade Questions.
===========================================
 
Does Oracle support migrating or upgrading directly to RDBMS 9.2.X?
 
What are the requirements for using the MIGRATE tool to migrate to
Oracle RDBMS 9.2.X?
 
Does the MIGRATE tool move the database files from your old code tree
to the 9.2.0.2.0 code tree?
 
How do you upgrade your database to Oracle RDBMS 9.2.0.2.0
if you cannot use the supplied MIGRATE tool?
 
Is the DBUA tool supported on OpenVMS?
 
Section 4. Tool and Utility Related Questions.
==================================
 What compilers are supported with Oracle RDBMS 9.2.X?
 32-bit client
 
 
What versions of Developer 2000 are supported with Oracle RDBMS 9.2.X?
 
4.3 How do I use RMAN with Oracle RDBMS 9.2?
 
Section 5. Connectivity (Net) Questions.
========================================
 
What changes have been made to Net Services (SQL*NET) in Oracle 9.2.X?
 
What TCP/IP vendors are supported with Oracle RDBMS 9.2.X?
 
Does Oracle support LDAP clients or LDAP servers in Oracle Server
release 9.2.X?
 
Where can I find client/server interoperability information?
 
Section 6. Patches.
===================
 OpenVMS specific patches for Oracle 9.2.X.
 Information on 9.2.X patchsets.
 
Is the opatch utility available for Oracle RDBMS 9.2.X on OpenVMS?
 
Section 7. Alerts:
==================
  Generic 9.2 Alerts.
 
Oracle RDBMS 9.2.X is unsupported and will not work on Alpha chipsets
prior to EV56.
 
Oracle RDBMS 9.2.X MUST be installed on an ODS-5 formatted
disk.
 The base inventory directory must reside on an ODS-5  formatted disk.
 
An ORA-12535 error may occur during database creation.
 Include the OUI base inventory directories in your backups.
 The Precompilers require a custom install
 Certain database initialization parameters are unsupported on OpenVMS
 Section 8. Warnings:
====================
 
OUI may hang if pgflquota is too low.
 The default character set for databases created via DBCA is based on the OpenVMS character set.
 
Startup may fail with ORA-3113 error after shutdown abort.
 Unix style directory paths are used throughout Oracle RDBMS 9.2.X.
 The extended file format (ODS-5) needs parse_style=extended.
 Establish a performance baseline in your current and planned environment.
 
Physical rowid format has changed in Oracle 8 and later versions.
 Datafiles greater than 4095MB require Oracle patches.
 
Mandatory OpenVMS ECO's needed for RAC.
 Precompiler performance information under 8i and 9i.
 
OUI will use the OpenVMS logical oracle_base if defined.
 DBCA will use the OpenVMS logical oracle_base if defined.
 OpenVMS logicals and symbols for 9.2.X need to be deassigned prior to using a pre-9.2 code.
 
The syntax for oratab.ora entries is incorrect in the Admin
guide.
 DECW$CLOCK may fail with Mrmfailure message.
 
The instructions on page 4-2 in the install guide for installing from a hard drive are incorrect.
 How to relink Oracle.
 
Oracle 9.2.X may not be compatible as a client or server
with older releases.
 
Clarification of disk_asynch_io parameter.
 
Clarification of tape_asynch_io parameter.
 
Apply Patch 3126930 prior to migrating your databases.
 Apply Patch 3126930 prior to creating databases.
 Ensure correct ownership and permissions of your code tree.
 
Ensure that certain OpenVMS utilities can be invoked.
 
Upgrading to OpenVMS 7.3-2 may deinstall JDK.
 Do not use <> characters when changing directories.
 
Client only installs are not supported.
 
Do not use rooted logicals.
 
Decryption of old data.
 Installation of Java has changed for 9.2
 @Bug 1766062 (export file attributes) is present.
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.