Re: oracle 8 and 9 in the same box

yls177 wrote:

> Hi, is it possible to have both oracle 8 and 9 in the same box?

Yes. Hope you mean 'Oracle8i' and 'Oracle9i R2', not 'Oracle8' and 'Oracle9i R1', though!

Basic premis - install each in a separate ORACLE_HOME.

> Factors to be consider
>
> 1) hardware, disk space, performance,

Same as keeping two installations of the same version on one box. Read the install manual for details.

Performance will vary widely and IMO tuning two concurrent instances on a box is not going to yield SLA-capable consistancy - doesn't matter whether they are same or different version.

> 2) oracle client configuratoin

Clients should use only one configuration, preferrable the higher version.

> 3) listener port (should have 2 separate ports)

Why. One listener can handle both - higher version.

> 4) tnsnames

One TNSNAMES.ora can handle both as well. Goes with the 'client' statement.

This is not an unusual configuration. However, the way you ask the question implies you do not have a strong background in Oracle concepts. If true, I strongly advise you get local assistance and/or read the concepts manuals at http://docs.oracle.com Received on Thu Sep 16 2004 - 12:04:03 CDT