Re: Oracle 9i and 10g on same Linux host

From: Mark Bole <makbo_at_pacbell.net>
Date: Tue, 30 Aug 2005 02:53:29 GMT
Message-ID: <JSPQe.1197$oJ2.110@newssvr17.news.prodigy.com>

EdStevens wrote:

> bnies_at_bluewin.ch wrote:
> 

>>Hi,
>>
>>Has someone managed to install and run Oracle 9i and 10g on the same
>>Linux host (RHEL4 x86_64)?
>>
>>I intend to install them into
>>
>> /opt/oracle/9.2.0.4
>> /opt/oracle/10.1.0.3
>>
>>with databases in
>>
>> /data/oracle/9.2.0.4
>> /data/oracle/10.1.0.3
>>
>>move the
>>
>> /etc/oraInst.loc
>> /etc/oratab
>> /etc/oracle
>>
>>to
>>
>> /etc/oracle/9.2.0.4
>> /etc/oracle/10.1.0.3
>>
>>and set the approprite links before starting up the database.
>>
>>Thanks in advance.
>>
>>Regards,
>>Bernd

> 
> 
> As Holger pointed out, oraInst.loc and oratab are not version specific
> and will/do support multiple versions in what they do, so should not be
> placed in version-specific directories.  Likewise the database files
> themselves.  While a given DB *is* a specific version at any given
> point in time, what happens when you upgrade it?  You don't want to
> have to relocate those files just because you placed them in a, now,
> inappropreately named directory.  Leave your databases in non-version
> specific directories.  In fact, looks like you might want to look into
> the idea of the $ORACLE_BASE variable in addition to $ORACLE_HOME, and
> do some reading on Oracle Flexible Architecture.
> 

[...]

It is possible to "install and run Oracle 9i and 10g" on the same host for _any_ supported platform, and if you find otherwise you should fully exercise your licensing rights by contacting Metalink. ;-)

This problem (multiple versions of vendor software on the same system) has been solved a long time ago -- don't try to re-invent the wheel. Do NOT relocate the oratab and oraInst.loc files from their default location for your platform, unless you are grabbing for "enough rope to hang yourself".

-Mark Bole Received on Mon Aug 29 2005 - 21:53:29 CDT