Monday, February 20, 2012

oracle and sql

is it possible to have an oracle server (runtime) and an sql server on
the same machine, or better said, is it wise?
the instance of sql server is not that heavily used, neither will the
oracle server service more than 10 users max
what issues could arise with such a setup
thnx
They both sure can be installed on the same machine. But I would only do
that on a development machine, not in production.
In a typical production scenario, both the RDBMSes will be competing for the
resources on the machine. Even from a maintenance point of view, if you have
to reboot the machine for the sake of applying an Oracle patch, you will
unnecessarily impact SQL Server users.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.fa317d5a865c2693.36062@.yahoo.com...
is it possible to have an oracle server (runtime) and an sql server on
the same machine, or better said, is it wise?
the instance of sql server is not that heavily used, neither will the
oracle server service more than 10 users max
what issues could arise with such a setup
thnx
|||Hi,
I also agree with Vyas on this. Earlier I had a non critical production
server which has both SQL Server and Oracle.
For applying any pathes on SQL Server or Oracle needs a reboot and will
cause a downtime.
As well as the resource usage also will be high. So I recommend you to have
either one of this RDBMS installed in a single server.
Thanks
Hari
SQL Server MVP
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.fa317d5a865c2693.36062@.yahoo.com...
> is it possible to have an oracle server (runtime) and an sql server on the
> same machine, or better said, is it wise?
> the instance of sql server is not that heavily used, neither will the
> oracle server service more than 10 users max
> what issues could arise with such a setup
> thnx
>
|||> is it possible to have an oracle server (runtime) and an sql server on the
> same machine, or better said, is it wise?
> the instance of sql server is not that heavily used, neither will the oracle
> server service more than 10 users max
> what issues could arise with such a setup
> thnx
OK
thnx for your input
it'll be an older server that will be used then
grtz

No comments:

Post a Comment