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 youOracle and MSSQL on the same machine is possible without problems ?
have you experience about this ?

thank you
Dario|||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.|||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|||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 ?|||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 ;)|||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.