Tuesday, February 21, 2012

Running SQL and Oracle on the same server

I know that this is primarily a SQL server group, but I am hoping
someone has experience in running Oracle alongside SQL servers. We
currently only have SQL server installations in our organization.
However one of our department is considering buying a third-party
application that runs on Oracle. We are interested to find out any
problems that people might have experienced in such an environment. I
am doing some research on this subject to find out what I can, but I
thought I would look to the experts on this.

Any input would be greatly appreciated.

Thanks

KarthikaI did that at several customer site, due to the lack of budget of the
customers and it worked. They are using a different port, so network
traffic will be separated. The only thing that would make me thinking
of a dedicated box would be performance, which can lousy if the
database are load intensive and the feeling of a Single point of
failure.

HTH, jens Suessmeyer.

--
http://www.sqlserver2005.de
--|||KR wrote:
> I know that this is primarily a SQL server group, but I am hoping
> someone has experience in running Oracle alongside SQL servers. We
> currently only have SQL server installations in our organization.
> However one of our department is considering buying a third-party
> application that runs on Oracle. We are interested to find out any
> problems that people might have experienced in such an environment. I
> am doing some research on this subject to find out what I can, but I
> thought I would look to the experts on this.
> Any input would be greatly appreciated.
> Thanks
> Karthika

We do it a lot out here. In fact most companies run some combination
of databases: Many Oracle with SQL Server.

The only real issue is training. The underlying architecture,
concepts, and design of Oracle are substantially different from
SQL Server which is based on the Ingres model. If you need someone
to provide SQL Server to Oracle training contact me off-line and I
will see if I know someone in your area.
--
Daniel A. Morgan
University of Washington
damorgan@.x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

No comments:

Post a Comment