Re: TWO VERSIONS OF ORACLE ON SAME VMS MACHINE

In article <jmcarthy.3.0539E300_at_YorkU.CA>, jmcarthy_at_YorkU.CA (John McCarthy) writes:
|>We are relatively new to both VMS and Oracle. We are currently running 12-15
|>SIDS on a single VMS machine (OpenVMS 6.1 AXP), with Oracle 7.0.
|>
|>In looking ahead to migrating to Oracle 7.1, we are not sure what implications
|>there are. Obviously, we do not want to migrate everything at one swell foop,
|>we would prefer to do it one SID at a time.
|>
|>Oracle assures us that this can be done, but cannot tell us HOW. We assume
|>that it is done by installing the new release in a separate directory, and
|>fiddling with logicals and/or symbols. We're not sure how to tell which
|>shareable installed image to use for which SID.
|>
|>Has anybody had multiple versions of Oracle running simultaneously on the same
|>machine ? If so, could you please be so kind as to send me a list of the steps
|>that need to be done to make this work ?
|>

Create a new directory that will be your new ora_root. When you install the new oracle version here, give it a different image identifier letter (I believe the default is either S or V7, so make it something like T). This way, your new oracle images will have names like ORACLET, CORET, etc., and both sets of images can be installed in memory. Some tools will no longer be installable, since they will have the same names under VMS and will confuse the machine, such as SQLPLUS and SQLREP, etc. Do not install these tools in memory.

You will have to "fiddle with logicals and/or symbols" for the two different versions. For example, you will want to run the correct ORAUSER.COM before connecting to one version or the other. There are more details depending on your specific situation, but this should get you well on your way.

-- 
Jennifer Corliss is on an InterGalactic cruise...       |The opinions expressed 
                                                        |above may not be those
   ...in her office                                     |of my employer.