Oracle 8i and 10g

[The Real MD]

Team,

does anyone know if you can have oracle 8i and oracle 10g installed and working on the same hpux 11 machine. If anyone has come across this it would be good to know if there are any gotchas.

Many Thanks

Martin.

[Steven E. Protter · Accepted solution]

If you are referring to the database, you can do that.

All you need to do is keep your ORACLE_HOME variables straight in scripting and startup and decide who gets to use port 1521. Its possible to share port 1521 with a solid tnsnames.ora setup.

There really are no gotcha's besides that. If a memory conflict issue comes up however, watch out, because Oracle may not support this configuration.

We've done it though and it is possible.

SEP

[Alzhy]

Of course you can.. If you're concerned there'll be overlaps etc in the installation directory - it won't since the software installs under its own subdirectory in the "product" subdirectory.

As far as tunables, SGA considerations and instance co-existence - nothing should change.

[Yogeeraj_1]

hi,

there should not be any problems as long as you use different ORACLE_HOMEs and i would use different ports for the listeners in each case.

I have had oracle8i and oracle9i running together for quite some time! next will be Oracle 10g. Have not applied the patches yet. be as soon i have the server ready, i will be testing the 10g.

hope this helps!

regards
Yogeeraj

[Jean-Luc Oudart]

Martin,

Oracle8i end of support is end of this December.
Oracle 10G has been certified for HPUX 11i not HPUX 11.0.

As mentioned in the posts above , separate the 2 environments =>
- different ORACLE_HOME
- listener on different ports
- ...

Regards
Jean-Luc