RE: Oracle and SQL Server on the Same Machine

In my experience, SQL Server and Oracle do not peacefully coexist on the same machine. I have tried running them together in various version combinations (SQL 6.5, 7.0; Oracle 7.3.4, 8.0.5) and have noticed odd behavior. I have no scientific evidence to support my observations, but I have received application errors and even unexpected crashes (aren't all crashes unexpected?) that did not occur prior to loading both databases on the same machine.

As a general rule, I don't do it anymore unless I absolutely have to test some code side by side. For what it's worth, I have noticed fewer problems running SQL Server 7 with Oracle than when running SQL 6.5 with Oracle.

Good luck.
-km

-----Original Message-----
From: Christine Turner [mailto:christine.turner_at_ips-sendero.com] Sent: Thursday, May 04, 2000 10:29 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Oracle and SQL Server on the Same Machine

Well, I havn't tried your current situation but I have tried Oracle 7.3.4 on NT 4 svcpk 5 with Sql Server 7.0. All my work is done in Oracle, so I just had Sql Server "runnning idle" in the background, no processing done on it. I was doing ok for about 5 days until my machine decided to "blue screen". Which is not good. Anyway I do to check the event log on the NT side and for whatever reason Sql Server had a problem. Error message is as follows......
Operating system error 1899., The endpoint mapper database could not be created.

Now, since I am new to Sql Server, I have no idea how severe this error message is. But, after the blue screen I am hesitant to have them both running again. PLUS, should you call Oracle they will tell you not to do it. Should you call MicroSoft they will tell you there "should" be no problem with it.

So, run at risk at this point.
Take Care,
Christine Turner
FTP Database Administrator
IPS Sendero
Phone: (800) 321-6899 ext. 3286
Fax: (480) 946-8224
E-mail: christine.turner_at_ips-sendero.com

Reply To: 	ORACLE-L_at_fatcity.com
Sent: 	Wednesday, May 03, 2000 10:16 AM
To: 	Multiple recipients of list ORACLE-L

We would like to put Oracle 8 and Sql Server 7 on the same server running NT
4.0 and later Windows 2000. This will be a teaching/training machine and will not contain critical production data. Is anyone currently doing this or tried it? Any gotchas, advice, etc.....? Or do they simply coexist peacefully?

Thanks,

Debbie

--
Author: Debra Ruggerie
  INET: druggerie_at_ugf.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Author: Christine Turner
  INET: christine.turner_at_ips-sendero.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may