Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2006
    Posts
    3

    Unanswered: mssql2000 and oracle 10g on same server

    I have mssql2000 running on a Windows 2003 server and now have a requirement to run an Oracle 10g database as well. Is it possible to run both mssql2000 and oracle 10g on the same server without running into any conflicts or will the two programs cause errors with each other?

    Anyone have any experience with this? Oracle says it's technically possible but the tech had never seen it done.

    Scott

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Although I've never run them in production, they run well enough on a test/dev machine. I'm pretty sure that you ought to be fine.

    -PatP

  3. #3
    Join Date
    Aug 2006
    Posts
    3
    Thanks for the reply. We are a small business and I dont have a testbox to play with. I'll make sure everything gets backed up before install of course just to make sure.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'm just being nosy now, but those are the database engine equivalent of oxen. Either one of them is massive overkill for a small business... either one can handle the needs of a small business in their sleep.

    Why do you need both of them? Software that is database engine specific?

    To clarify on my previous post, I haven't run both SQL Server and Oracle 10g on one machine in production, but the two coexist happily on dev/test boxes.

    One thing that I'd very strongly encourage is that you take whatever machine you can spare (whimpy is good in this case) and make it a dev/test box. You really don't want to be trying things out for the very first time on your production machine if you have any choice in the matter. I have actually seen people (more than one) lose their business by making that mistake.

    -PatP

  5. #5
    Join Date
    Aug 2006
    Posts
    3
    I agree, it is a risky proposition. I will be making an image of the machine and backing up all data before doing the install. I also have to have it operational by tommorow because of business requirements. No pressure!

    As to why we are running both you nailed it on the head. Software requirements. We will eventually, a couple years, be migrated completely to Oracle.......or at least that's the plan today.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •