Re: TWO VERSIONS OF ORACLE ON SAME VMS MACHINE

From: YVONNE BAUMERT, DECUS EUROPE AD-SIG CHAIR <y_baumert_at_decus.ch>
Date: 19 Jan 95 13:56:44 +0100
Message-ID: <1995Jan19.135644.48_at_decus>

If you want to set up two different versions of ORACLE on the same VMS machine "you should install the code in parallel directories, one level or more below the login dirctory of the ORACLE account" (Oracle7 for VAX OpenVMS Installation Guide page 1-2)

We do this and have as ORA_ROOT
 [ORACLE.root] for one installation and
 [ORACLE.oracle70] for the other installation. The fist name is not the best to choose and historical.

When installing the second version you will be prompted for ORA_ROOT and that's when you have to give the name.
The installation procedure will create certain command files to set the needed logicals and symbols to run the new version. You have to go through something similar to the procedure given at the end to switch versions (I just set our version switch there).

Regards

Yvonne

---

Yvonne Baumert       LL     TTTTTTTTTT  UU    UU   The statements made 
LTU GmbH             LL     TT  TT  TT  UU    UU   represent my own opinion 
Airport, Hangar 8    LL         TT      UU    UU   and do not necessarily 
D-40474 Düsseldorf   LL         TT      UU    UU   correspond with my 
Germany              LL         TT      UU    UU   employers opinion.
y_baumert_at_decus.ch   LLLLLL    TTTT      UUUUUU     

PSI%(0262)45211013068::baumert Some countries don't need the leading 0!!

---

------------------------------cut here-------------------------------



$!------------------------------------------------------------------------------

$! 	ORA_VERSION_CHOICE.COM

$!

$!	Author: Yvonne Baumert

$!	Date:	09-NOV-1994

$!

$!	This command procedure checks which ORACLE-Version is currently

$!	set and gives you the opportunity to switch to the other version.

$!	You can then choose the SID you want if more then one exist.

$!

$!	change log

$!	----------

$!	date	    | by  | description

$!	---------------------------------------------------------------------

$!	24-NOV-1994 | BAU | ora_db:ora_db_<db_name>.com has to be started

$!		    |     | as well

$!	---------------------------------------------------------------------

$!	24-NOV-1994 | KNL | Switch to define database-specific logicals

$!	---------------------------------------------------------------------

$!		    |     | 

$!	---------------------------------------------------------------------

$!------------------------------------------------------------------------------

$!

$!	current directory


$ SAVE_DIR = f$directory()

$!
$!
$! Which ORACLE Version is currently active
$!

$ pos = F$LOCATE(".", ORA_ROOTDIR)
$ length = F$LENGTH(ORA_ROOTDIR)
$ ora_version = F$EXTRACT(pos+1, length-pos,ORA_ROOTDIR)

$!

$ IF (ora_version .eqs. "ROOT") THEN GOTO PCMS
$	ora_version = "V70"
$	goto weiter 
$PCMS:
$	ora_version = "PCMS"
$WEITER:

$!

$ write sys$output ""
$ write sys$output ""
$ write sys$output ""
$ write sys$output ""
$ write sys$output "Please choose the Database version  "
$ write sys$output "------------------------------------"
$ write sys$output ""
$ write sys$output "1	ORACLE Run Time License for PCMS"
$ write sys$output ""
$ write sys$output "2	ORACLE V7.0.16"
$ write sys$output ""
$ write sys$output ""
$ inquire choice "Default is ''ora_version'. Your choice "

$!

$ IF (choice .eqs. "1") THEN GOTO ONE
$ IF (choice .eqs. "2") THEN GOTO TWO
$ goto continue               
$ONE:

$! setting the needed logicals and symbols

$ _at_awe_c:[oracle.root.util]orauser.com
$ _at_awe_c:[oracle.root.db_pcms]orauser_pcms.com
$ _at_ora_db:ora_db_pcms.com
$ goto continue     
$TWO:

$!

$ write sys$output ""
$ write sys$output ""
$ write sys$output ""
$ write sys$output ""
$ write sys$output "Please choose the test database"
$ write sys$output "-------------------------------"
$ write sys$output ""
$ write sys$output "1	DB_TEST_B"
$ write sys$output ""
$ write sys$output "2	DB_KNOLLE"
$ write sys$output ""
$ write sys$output ""
$ inquire choice "Default is DB_TEST_B. Your choice "

$!

$ IF (choice .eqs. "2") THEN GOTO KNOLLE
$ goto TEST_B              

$!

$TEST_B:

$! setting the needed logicals and symbols

$ _at_awe_c:[oracle.oracle7.util]orauser.com
$ _at_awe_c:[oracle.oracle7.db_test_b]orauser_test_b.com
$ _at_ora_db:ora_db_test_b.com
$ goto CONTINUE

$!

$KNOLLE:

$! setting the needed logicals and symbols

$ _at_awe_c:[oracle.oracle7.util]orauser.com
$ _at_awe_c:[oracle.oracle7.db_knolle]orauser_knolle.com
$ _at_ora_db:ora_db_knolle.com
$ goto CONTINUE

$!

$CONTINUE:


$!	

$!	set new prompt 

$!

$PROMPT "''SAVE_DIR'"

$!

$ EXIT

--------------------cut here-------------------------

$! Prozedur PROMPT.COM
$! Barbara Neeb, 05.05.90
$! Prozedur setzt Prompt auf aktuellen Knoten und aktuelles Directory
$!
$! Aufruf:
$! _at_PROMPT directory !Dabei findet sich directory dann in p1
$!
$! change log
$! ----------
$! 10.11.1994 BAU Wechseln des Directories soll als Teil des neuen
$! Prompts ebenfalls die ORACLE-Version anzeigen.
$!------------------------------------------------------------------------------

$ SET DEFAULT 'p1'                             ! Directory wechseln


$!

$ node = F$GETSYI("NODENAME")		       ! Aktuellen Knoten holen


$!

$!	Bestimmen der ORACLE-Version

$!

$ pos = F$LOCATE(".", ORA_ROOTDIR)
$ length = F$LENGTH(ORA_ROOTDIR)
$ ora_version = F$EXTRACT(pos+1, length-pos,ORA_ROOTDIR)

$!

$ IF (ora_version .eqs. "ROOT") THEN GOTO PCMS

$!

$ ora_version = "V70"
$ goto weiter

$!

$PCMS:
$	ora_version = "PCMS"
$WEITER:


$!

$ teil = F$EXTRACT (1,16,F$DIRECTORY())         ! Haupt-Directory entfernen
$
$ SET PROMPT = "''ora_version'|''node'::[''teil'_>" 	! Prompt auf aktuelles
$                                              		! Directory setzen
$ EXIT

Received on Thu Jan 19 1995 - 13:56:44 CET