pdlarue
asked on
Running SQL Server and Oracle on the same computer
Anybody out there think there will be a problem? Why?
SERVER:
The server will only be running Oracle Enterprise.
CLIENTS:
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,
Patricia
SERVER:
The server will only be running Oracle Enterprise.
CLIENTS:
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,
Patricia
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.