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