OraFAQ Forum: Server Administration » create a distributed database on two servers

Home » RDBMS Server » Server Administration » create a distributed database on two servers

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create a distributed database on two servers [message #610586]

Fri, 21 March 2014 09:29

Oussama
Messages: 6
Registered: March 2014

Junior Member

Hi everyone,

I have two Windows XP machines connected as a LAN

I have installed the Oracle database software on the first one (11g R2) and the SQL SERVER 2012 software on the second one

I want to create a database (really simple just for test) distributed between both machines (half of data on one machine and the other half on the other) so as I could run SQL queries on any of the machines and get data just like if it was a single database.

Thanks in advance for any answer or help

Report message to a moderator

Re: create a distributed database on two servers [message #610587 is a reply to message #610586]

Fri, 21 March 2014 09:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

you should start Reading The Fine Manuals at URL below

http://www.oracle.com/technetwork/database/enterprise-edition/documentation/database11gr1-087487.html

Report message to a moderator

Re: create a distributed database on two servers [message #610588 is a reply to message #610587]

Fri, 21 March 2014 09:42

Oussama
Messages: 6
Registered: March 2014

Junior Member

Hi,

It's my first topic here and I really need an answer for my problem as soon as possible, that's why I wrote this fast

I don't see why I have to read the whole Oracle documentation. I want to do sometihng specific ...

Report message to a moderator

Re: create a distributed database on two servers [message #610589 is a reply to message #610588]

Fri, 21 March 2014 09:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

In theory, theory and practice are identical. In practice, theory and practice are unrelated.

>so as I could run SQL queries on any of the machines and get data just like if it was a single database.
In theory, it could be done. In practice it would be messy & borderline unmaintainable.

Report message to a moderator

Re: create a distributed database on two servers [message #610590 is a reply to message #610589]

Fri, 21 March 2014 10:07

Oussama
Messages: 6
Registered: March 2014

Junior Member

I know, but I just want to do it with a really simple database (two columns ID and name for example) just to see how it could be done in practice
I'm not trying to implement it in an Entreprise, I know it would be messy

Report message to a moderator

Re: create a distributed database on two servers [message #610591 is a reply to message #610590]

Fri, 21 March 2014 10:11

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

Read up on RAC and dataguard.

Report message to a moderator

Re: create a distributed database on two servers [message #610592 is a reply to message #610590]

Fri, 21 March 2014 10:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You are free to proceed.
You don't need permission from anyone here.
Previously posted documentation shows how to inter-operate with SQL Server database.
So have at it.
I hope you will enjoy this exercise in futility.

Report message to a moderator

Re: create a distributed database on two servers [message #610593 is a reply to message #610591]

Fri, 21 March 2014 10:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

cookiemonster wrote on Fri, 21 March 2014 08:11

Read up on RAC and dataguard.

RAC & SQL Server do not mix
>and the SQL SERVER 2012 software on the second one

Report message to a moderator

Re: create a distributed database on two servers [message #610596 is a reply to message #610593]

Fri, 21 March 2014 10:44

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

It's somewhat possible of course.

You can create a Link from SQL Server to Oracle via the "Linked Server to Oracle" functionality in SQL Server for one direction.

For the other direction you can create a "Database Link" in Oracle via Oracle "Heterogeneous Services" to connect to the SQL server.

It's not really trivial of course, and you will never really be able to use it "as if it were the same database" It might work for 50% of the "standard" SQLs you can come up with, but most of the time you have to tweak the SQLs you run pretty much so that they work sufficiently over the link. And "running identical queries on both sides" would be really hard to achieve.

[Updated on: Fri, 21 March 2014 10:45]

Report message to a moderator

Re: create a distributed database on two servers [message #610597 is a reply to message #610596]

Fri, 21 March 2014 11:04

Oussama
Messages: 6
Registered: March 2014

Junior Member

I understand that running identical queries would be hard to achieve, but this is not a problem

Like I said I just want to test the operation using one or two basic simple sql queries (like select name from table) because what is important for me is to just make it work

So can you explain to me how I can in practice, create a Link from SQL Server to Oracle and a Database Link from Oracle to connect to the SQL server with steps assuming I have a database called db and a unique table called employee with one column called ID (something really simple, the purpose is just to make it work)

Thanks in advance

Report message to a moderator

Re: create a distributed database on two servers [message #610602 is a reply to message #610597]

Fri, 21 March 2014 12:33

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As this have been addressed many times you can easily find the answer here and on the web without we have to repeat it.
But you are free to then put here the complete solution you will find and test.

Report message to a moderator

Re: create a distributed database on two servers [message #610619 is a reply to message #610602]

Fri, 21 March 2014 18:40

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Hint: The words I put in quotation marks give pretty good Google results on the subject, with a lot of step-by-step instructions. Razz

Report message to a moderator

Previous Topic:	ORA-01034: ORACLE not available (some users only)
Next Topic:	Confusion about nologging

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 05:41:56 CST 2024