Running SQL Server and Oracle on the same computer

Posted on 2006-04-26
Last Modified: 2010-08-05
Anybody out there think there will be a problem?  Why?

The server will only be running Oracle Enterprise.

Clients will be running Oracle Express (uses maximum of 4GB disk storage and 1GB memory).  Oracle Express is necessary for stand-alone capability on the client and replication of a subset of data from the central server.  The Oracle Express data will typically be less than 300MB all the time.  

HOWEVER:  Some of these clients are already running SQL Server.  The problem is that we cannot control the client-side.  Some of these clients may be running SQL Server for another application.  If we come along and install Oracle EXPRESS (the small FREE version) on the client also but for our application, can our Oracle EXPRESS database run on a client that is running SQL Server database for a different application?  Think 2 applications, 2 different databases.  I do not see a problem with this as long as the client machine has enough memory and disk space (and perhaps processing power).

Management seems to think that you cannot have the two databases running on the same machine.  In my mind, that is just like saying that 2 application (i.e., Microsoft Money and Quicken) cannot run on the same machine.

Am I missing an important detail here?  Please advise.

Anybody out there think there will be a problem?  Why?

Thank you,
Question by:pdlarue
    LVL 19

    Assisted Solution

    In my own working pc, I have MS SQL 2000 and Oracle 9i. Both running in the same time and I don't see any problem as long as they use different ports (defaults are always good and safe).

    LVL 11

    Assisted Solution

    I dont think there should be any problem running SQL Server and Oracle on the same machine. Challenge should be to run  two Oracle databases in a same machine (Specially if they are of diff versions like 8i and 9i).
    LVL 7

    Accepted Solution

    agreed, should not be a problem.


    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.

    Join & Write a Comment

    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    Via a live example, show how to take different types of Oracle backups using RMAN.

    732 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

    18 Experts available now in Live!

    Get 1:1 Help Now