Running SQL and Oracle on the same server

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • KR

    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

    Karthika

  • Jens

    #2
    Re: Running SQL and Oracle on the same server

    I 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.

    ---

    ---

    Comment

    • DA Morgan

      #3
      Re: Running SQL and Oracle on the same server

      KR wrote:[color=blue]
      > 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[/color]

      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.wash ington.edu
      (replace x with u to respond)
      Puget Sound Oracle Users Group
      Oracle PL/SQL examples, syntax, DBMS packages, string, timestamp, substring, PHP code, and Javascript Code Reference Library (formerly known as Morgan's Library)

      Comment

      Working...