Oracle and MS SQL locations - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Oracle and MS SQL locations

Author

Topic

donafams
Starting Member

11 Posts

Posted - 2007-01-17 : 13:59:34

Can oracle91 and MS SQL2005 be on same server

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-01-17 : 14:06:04

probably yes, but why would you want this?

Go with the flow & have fun! Else fight the flow

blog thingie: http://weblogs.sqlteam.com/mladenp

donafams
Starting Member

11 Posts

Posted - 2007-01-17 : 14:12:51

because im running sql2005 now, we have oracle and i want to lean it and maybe migrate existing db's to it. and right now the only available server i have to use is the one running the MS SQL

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-01-17 : 14:28:17

cool.

Is there a good reason that you'd like to migrate existing data to oracle?
sql server isn't that bad

Go with the flow & have fun! Else fight the flow

blog thingie: http://weblogs.sqlteam.com/mladenp

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-01-17 : 14:29:48

Sounds like a "career enhancement" driven project.

CODO ERGO SUM

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-01-17 : 14:32:45

If you really want to learn Oracle, then you should do it on a Linux/Unix box rather than a Windows box.

Tara Kizer

donafams
Starting Member

11 Posts

Posted - 2007-01-17 : 15:08:50

im not asking about learning oracle, im wondering if they can co-exist on the same server????

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-01-17 : 15:11:17

I guess I don't know what "lean it" means. I thought it was a typo for "learn it".

Tara Kizer

donafams
Starting Member

11 Posts

Posted - 2007-01-17 : 15:21:30

I guess I don't know what "lean it" means. I thought it was a typo for "learn it".

what???

does anyone know if they can run on the same server please?

donafams
Starting Member

11 Posts

Posted - 2007-01-17 : 15:23:37

I guess I don't know what "lean it" means. I thought it was a typo for "learn it".

im not asking this forum about "LEARNING" oracle.. im asking if they can run on the same server

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-01-17 : 15:27:38

Yes I realize that. I was just explaining why I posted what I did earlier. I don't know what "lean it" means, that's all.

Tara Kizer

donafams
Starting Member

11 Posts

Posted - 2007-01-17 : 15:28:36

OMG... just forget it.

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-01-17 : 17:10:18

Yes they can run on the same server. For learning SQL Server, Oracle or anything else though, I'd recommend creating virtual machines. Virtual PC is free and lets you create complete server installations in a virtual machine environment without having to install anything on your real machine.
See http://www.microsoft.com/windows/virtualpc/default.mspx

agossage
Starting Member

9 Posts

Posted - 2007-01-17 : 17:35:54

FYI... Microsoft and Oracle do not support installation on any version of VMWare, including Microsoft's.

Adam Gossage
Lake Wylie, SC, USA

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-01-18 : 01:57:49

quote:
FYI... Microsoft and Oracle do not support installation on any version of VMWare, including Microsoft's.

What do you mean by that, Microsoft don't have a version of VMWare?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-18 : 02:04:38

SQL Server 2005 works very well in virtual machines.

Peter Larsson
Helsingborg, Sweden

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-01-18 : 02:09:45

Yes it does, in fact you can create a SQL Server fail-over cluster in virtual machines, which is why I'm wondering what agossage was getting at. I'm not suggesting you should put a cluster in virtual machines for a production server but it's great for testing and learning.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-01-18 : 10:48:22

quote:
Originally posted by agossage

FYI... Microsoft and Oracle do not support installation on any version of VMWare, including Microsoft's.

Adam Gossage
Lake Wylie, SC, USA

I'm not sure what you mean by this. VMWare is an EMC product, not a Microsoft product.

Microsoft calls their product Virtual Server, and at least SQL Server is supported on it. I don't know about Oracle. I know it now supports Linux as a "guest" OS.

CODO ERGO SUM

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-01-18 : 10:56:53

as i understood him he meant that if you have sql server or oracle on a virtual machine and you need
MS or Oracle support they won't help you.

Go with the flow & have fun! Else fight the flow

blog thingie: http://weblogs.sqlteam.com/mladenp

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-01-18 : 11:22:30

I don't think that's true either though - I'm not sure about Oracle, but Microsoft do support (as in technical support) SQL Server on Virtual Server, see
http://www.support.microsoft.com/kb/897613/
http://www.support.microsoft.com/kb/897614/

agossage
Starting Member

9 Posts

Posted - 2007-01-18 : 15:32:57

Please forgive me. When I wrote VMWare, I was referring to the Virtual Machine technology in general.

My advice is from a best practice point of view. I am not suggesting that SQL Server does not run on VM technology. I am sure it runs fine in some instances. Simply put, it is an untested environment. The total number of servers running SQL in VM technology is limited. Therefore, any issues generated from that type of environment will not be in the mix for the hotfixes/service packs. If you have difficulties and ask Microsoft for assistance, you will be provided limited support and no promises. I am sure each of you would agree that running SQL Server in an environment that is untested is considered risky.

The KB articles 897613 and 897614 are just information that Microsoft decided to publish. No where does it suggest that SQL Server is supported in a VM environment. Microsoft does not publish everything.

Adam Gossage
Lake Wylie, SC, USA

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources