oracle 8 and 9 in the same box

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

1) hardware, disk space, performance,
2) oracle client configuratoin
3) listener port (should have 2 separate ports)
4) tnsnames

not too sure about point (2)

Thanks

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

If it is a Unix/Solaris box no real problem, just read the manual.

If it is a Windows box, buy another box :-)


"yls177" <yls177@hotmail.com> wrote in message
news:c06e4d68.0409160827.7f019448@posting.google.c om...
> Hi, is it possible to have both oracle 8 and 9 in the same box?
> Factors to be consider
>
> 1) hardware, disk space, performance,
> 2) oracle client configuratoin
> 3) listener port (should have 2 separate ports)
> 4) tnsnames
>
> not too sure about point (2)
>
> Thanks

On Thu, 16 Sep 2004 09:27:26 -0700, yls177 wrote:

> Hi, is it possible to have both oracle 8 and 9 in the same box?
> Factors to be consider
>
> 1) hardware, disk space, performance,
> 2) oracle client configuratoin
> 3) listener port (should have 2 separate ports)
> 4) tnsnames
>
> not too sure about point (2)
>
> Thanks

Of course, no problem. We have running 7.3.4 and 8.0.6 (yeah, I know that
these are old versions) on the same AIX 4.3.3 box.
As for client side, e.g. we have an oper user for the export procedure
(one part of the backups we drive is export). The procedure connects to
the db, asks which version and sets ORACLE env for the user/procedure as
needed. In fact, we have client software installed for 7, 8.0 and 8.1.
I see no problem.
If you decide to have a single listener listening for different
installations/db versions, no problem, maybe it is preferrable to have the
highest version listener running. But, we also had a configuration where a
listener per version was running. Just pay attention not to garble with
the ports.

HTH, best regards, Igor