Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2007
    Location
    Europe
    Posts
    3

    Unanswered: have you ever installed MSSQL on a server with Oracle already running ?

    am i going to cause problems if i install MSSQL2005 on a server with Oracle already installed and running ?

    thank you

  2. #2
    Join Date
    Apr 2007
    Location
    Europe
    Posts
    3

    Oracle and MSSQL on the same machine ?

    Oracle and MSSQL on the same machine is possible without problems ?
    have you experience about this ?

    thank you
    Dario

  3. #3
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    I have them both on my dev box at home, but it's difficult to run them both simultaneously. They both grab a lot of memory, but especially oracle.

    I only run the services simultaneously when absolutely necessary.

    I would never run them on the same box in a production environment.

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    I have an Oracle server and a SQL Server running on the same box in a production environment, but there's a couple of BIG catches:

    1. The Oracle server (9iR2) is only being used for Oracle Enterprise Management services and as an RMAN catalog/repository. Nothing else. It's certainly NOT an OLTP machine;

    2. The SQL Server is SQL 2005 Standard Edition and is the back end for SQL Reporting Services and WSUS (Windows Update Services). The Reporting Services install is used only for management reports (nothing goes to the outside world).

    So, yes they can be installed on the same machine together. I wouldn't recommend it for anything that was mission critical (I can lose OEM, WSUS and Reporting Services and not impact production applications).

    Regards,

    hmscott
    Have you hugged your backup today?

  5. #5
    Join Date
    Apr 2007
    Location
    Europe
    Posts
    3
    THat server has 2Gbyte ram
    Right now oracle.exe is using 430MB memory and java.exe 100MB of memory

    I would install Sql Server 2005 Express edition (will not be used heavly)
    do you think i should find another machine for this task ?

  6. #6
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    it's not just the memory that's the issue. both will be competing for other resources such as disk and cpu.

    my instinct is to put express on a separate server.

    there's nothing to prevent you from trying it on the same server and reporting back here with your experience howerver

  7. #7
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    Well. It's quite possible to run both SQL Server and Oracle on the same computer, without any problems. However, as mentioned, they will compete for CPU, Memory, I/O and other resources, so the performance may drop quite a bit when both are executing queries at the same time. In a testing-environment this should really not be a too big issue. What I've done is going a bit further, installing SQL Server and Oracle in their own Virtual PCs. They still compete for resources, but it's easy for me to transfer one of the Virtual PCs to a different physical computer if I should need to do so.

    If you end having Oracle and SQL Server on the same computer, please ensure that you configure both Oracle and SQL Server, so that they both get enough memory.
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •