cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 8i and 10g

SOLVED
Go to solution
The Real MD
Valued Contributor

Oracle 8i and 10g

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.
4 REPLIES
Steven E. Protter
Exalted Contributor
Solution

Re: Oracle 8i and 10g

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Alzhy
Honored Contributor

Re: Oracle 8i and 10g

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.
Hakuna Matata.
Yogeeraj_1
Honored Contributor

Re: Oracle 8i and 10g

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Jean-Luc Oudart
Honored Contributor

Re: Oracle 8i and 10g

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
fiat lux