Oracle 9i and Oracle 10g on same Windows Server?

Posted on 2007-10-18
Last Modified: 2008-02-07

I have a PowerEdge860, DualCore 3ghz processor, 4gb ram, running  Windows 2000 Server, with plenty of disk space.

Can I install Oracle 9i and Oracle 10g on this server, or will they conflict with each other?

The Oracle instances involved are for software development purposes and will not be high-use databases, so I'm sure that resources won't be an issue, but I'm worried about introducing software bugs or configuration glitches that wouldn't be an issue if the Oracle 9 and Oracle 10 were on two separate boxes.  (At the moment I don't have two separate boxes.)

What do you think?

Question by:gateguard
    LVL 34

    Accepted Solution

    Yes, you can install and run two separate versions of Oracle in two separate installs (Oracle_homes) on one Windows server.  Will lthey conflict with each other?  No, not directly.  Is it a good idea?  Maybe.  Windows is not particularly stable, so if this will be a production environment, it may not be wise.  For testing and development, this should be fine.

    Two other issues are:
    1. memory
    2. listener port(s)

    First, regarding memory, 4GB is the minimum I would recommend for a single Oracle database on Windows supporting a few dozen to a few hundred concurrent users.  This would allow you to have an SGA of close to 2GB.  To run two Oracle databases simultaneously, you will need to monitor the memory and swap file usage (the Windows Performance Monitor is a great tool for this) to avoid excessive swap file activity, but maximize use of physical RAM.  You may be able to have your two SGA's total 2 - 2.5GB.

    Then for your Oracle listener(s), you can have either one or two.  If you use one, it must be the higher version, but it can be the default port:1521, and it can use the default name: "LISTENER".  You will have to add an entry manually to the Oracle10 listener.ora file for the Oracle9 instance then.  Or, you can use two listeners, one from each Oracle_home, with one for each database.  But then only one can be on the default port, and only one can use the default listener name.

    You mentioned "plenty of disk space".  That may be true, but I hope this is not all one RAID5 array.  Local SCSI discs in a WindowsServer that are all RAID5 are terrible for these parts of a Windows/Oracle system:
    1. the Windows temp directory
    2. the Windows pagefile
    3. the Oracle temp tablespace
    4. the Oracle rollback or undo tablespace(s)
    5. the Oracle on-line redo log files
    6. the Oracle archived redo log files
    7. Oracle export "dump" files

    Most of those are much better off on non-RAID or RAID0.  The on-line redo log files and the rollback or undo tablespaces should be on RAID1.  RAID5 is fine for: all executable files, and the Oracle system, data and index tablespaces.
    LVL 34

    Expert Comment

    If you do this, you should install the lower version of Oracle first.  With Oracle9 and 10, it may not matter, but with earlier versions of Oracle this was a requirement (the lowest version had to be installed first).
    LVL 47

    Assisted Solution

    Windows 2000 is not the best OS for Oracle.
    There are too much complains about bad
    functionality of Oracle 9i on this Os. I also have
    bad experience.
    I will recommend to use different machines for
    every Oracle instance.
    But if you decide to run both version on the same
    machine either provide different ports for 9i and 10g
    listeners or use only the 10g listener for both instances.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Suggested Solutions

    Title # Comments Views Activity
    Formatting varchar to numeric 8 58
    Cross Outer Join 4 41
    Format Number Field 10 34
    Generate HTML charts from SQL 4 37
    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now