Oracle 9i on OpenVMS Clusters

[Mike Naime]

Douglas:

We run OPS (8I) on our 2-node production clusters. You have Instance1 on Node1, and Instance2 on Node2. The Application can connect to either Instance, Although you have the Primary Instance normally running on Node1.

SQL traffic is routed through a direct-connect crossover cable between the 2 nodes.

Our DBA's are playing with 9I on our test cluster. I'm not sure exactly were they are with it. I heard that installing 9I from CD took 6+ hours.

[Hein van den Heuvel]

It shouldn't need much more than an hour.

Mike, tell them NOT to install directly from CD!
Offload the CD structures to directories on a hard-drive and install from there.
Much nicer, specially if you have to do it again... (and you will :-)

Metalink/releasenotes have articles on the desired structure (notably needed for a downloaded kit)

Hein.

[Andreas Fassl]

Hi,

as already mentioned there are lots of articles on http://metalink.oracle.com, THE source for information regarding oracle.
The attached article is a question from another using about 9i on OpenVMS with lots of pointers to other notes.

Regards

Andreas

From: Amit Jain 16-May-03 20:53
Subject: RAC on Alpha-VMS


RAC on Alpha-VMS

Hi, I want to test the RAC on ORACLE 9i Rel 2 ( 9.2.0.2.0) on Alpha-VMS ( 7.3 ), But As I'm new to RAC field. I've some common questions to ask.

1. Does we any additional software from ORACLE to Install RAC,
I mean we do have ORACLE 9i EE ( Above Release ).
Is this enogh to Install, Configure and Test for
Testing/Developement purposes OR Do we have to buy or Download any
Additional other software for that.
2. What else do we need in Operating system side, I mean any other
patches/Software Etc.
3. Any Step-by-Step Document for this on VMS.
4. As I have to Difference Nodes, but they are not sharing the same
Storage and I gonna to try, making as One node as an ORACLE 9i RAC
and the other to just as a Simple Node..
OR How can I gonna to work out on this..Any Suggestion.

The main thing is that ORACLE 9i CD's are enough or do I need any extra Software/Script Etc on VMS

Thanks
-PKS







From: Oracle, MADHAVI YELESWARAPU 22-May-03 19:20
Subject: Re : RAC on Alpha-VMS

Hi Amit,

Please review the following document for installation information. This should give you an idea about installing RAC on 9202/Alpha OpenVMS

Ext/Pub Step-By-Step Installation of RAC on HP OpenVMS Cluster

This document will provide you with everything needed including:

1. Configuring the Cluster Hardware
1.1 Minimal Hardware list / System Requirements
1.2 Setup Server Parameters
2. Software Requirements
2.1 Operating System and Layered Products
2.2 Operating System Patches
3. Configuring the Cluster
3.1 Install the OpenVMS Operating System
3.2 Install the Operating System Patches
3.3 Adding the Second Node
3.4 Configuring TCP/IP
3.5 Adjusting System Parameters
4. Installing RAC
4.1 Creating the ORACLE Account
4.2 Installing the Software
5. Setting up the Database
5.1 Create the Database
5.2 Configuring the Database for RAC
5.3 Reserving Memory for the SGA
6. References

Another source is the OpenVMS FAQ Note 222553.1 (Section 9.1), there is a good section on RAC and 9202:

Section 9. RAC questions
========================

9.1 Is the Real Application Cluster (RAC) feature available on OpenVMS?

Yes.

Oracle Parallel Server (OPS) has been renamed to Real Application Cluster (RAC).
Please be sure that all OpenVMS ECO's are installed. This is very important
if you are running RAC.

For more information please read the following notes:

<132987.1> High Availability - Real Application Clusters Library Page
<162922.1> OpenVMS: How to redirect OPS TCP/IP traffic to a private network
<162725.1> OPS/RAC VMS: Using alternate TCP Interconnects on 8i OPS and 9i RAC on OpenVMS
<234484.1> How to relink Oracle 9.2.0.X on OpenVMS Alpha with or without RAC

There is another note for the OpenVMS patches needed to run RAC on OpenVMS:

<223566.1> VMS: List of patches for Oracle 9.2.0.2.0 on OpenVMS

Thanks
Madhavi

[Andreas Fassl]

Hi,

another point: Oracle 9 is only supported with 7.3. And only with TCPIP-Services by HP.

Certify - Certification Matrix: RAC for OpenVMS Alpha on HP Alpha OpenVMS

Server Certifications

OS Product Certified With Version Status Addtl. Info. Components Other Install Issue
7.3-2 9.2 64-bit N/A N/A Certified None None None None
7.3-1_EV7-V0100 9.2 64-bit N/A N/A Certified None None None None
7.3-1 9.2 64-bit N/A N/A Certified None None None None
7.3 9.2 64-bit N/A N/A Certified None None None None

Regards

Andreas