Re: 9i & 10g databases on same W2K box

On 9/13/05, DBA Deepak <oracle.tutorials_at_gmail.com> wrote:
>
> Hi All,
>
> Want to know what are the considerations for installing both 9i & 10g
> databases on the same W2K box. Will affect any application configurations?
>
> Please help...
>

Deepak

You'll want to consider

1. Each database can use less of the hardware resources than it could if it was on its own dedicated server.
2. One Oracle home has to be be the primary home, this may affect applications that run on the server itself (hopefully there aren't any)
3. What is your network configuration going to be and where will it reside? One listener is probably best for example.
4. Maintenance windows for one system will affect the second as well.
5. If the disks are common you will have to find someway of monitoring io at the OS level as well as the database level to ensure the two databases aren't competing for the same disk.
6. What is the ORACLE_BASE and ORACLE_HOME structure going to be? 9i style or 10g style?

None of these mean you can't do what you are suggesting, just that maintenance and configuration is more complicated than the alternative and you may get less out of the box. You may of course utilize the one box more effectively than if you'd bought two.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

--
http://www.freelists.org/webpage/oracle-l