OraFAQ Forum: Server Administration » Centralizing two instances

Home » RDBMS Server » Server Administration » Centralizing two instances (Oracle 10g)

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

Centralizing two instances [message #612633]

Tue, 22 April 2014 22:45

m.abdulhaq
Messages: 253
Registered: April 2013
Location: Ajman

Senior Member

I have two different instances at two different sites and i need to combine them into one database , what are the steps involved in doing that , is there any reference available.

Report message to a moderator

Re: Centralizing two instances [message #612634 is a reply to message #612633]

Tue, 22 April 2014 22:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> what are the steps involved in doing that ,
It depends

>is there any reference available.
NO

are all the application schemas different between the two databases?

post complete results from SQL below for both databases

SELECT * FROM V$VERSION;

Report message to a moderator

Re: Centralizing two instances [message #612639 is a reply to message #612634]

Wed, 23 April 2014 00:12

Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

are all the application schemas different between the two databases?

And do they use PUBLIC synonyms or not? If so, have they only different public synonyms or some of them are common?

Report message to a moderator

Re: Centralizing two instances [message #612695 is a reply to message #612634]

Wed, 23 April 2014 06:10

m.abdulhaq
Messages: 253
Registered: April 2013
Location: Ajman

Senior Member

thanks blackswan, well the schemas are same but inside each table we are maintaining a seperating field called company code.Basically we have to branches one branch uses company code 'QAR' and the other uses 'RIO' , But one more challenge is some of the procedures may vary at the block level and some schema objects may be created on both sides additionally.

Challenges are.

1) Identify the objects which are different
2) List out the programs that are different
3) merge them together , so when people from RIO wants to connect they will be accessed to their schema alone and when people from QAR they will be logged into theirs.
4) What kind of interface will be suitable as we are using 9ias and they will be using VPN.

Report message to a moderator

Re: Centralizing two instances [message #612696 is a reply to message #612639]

Wed, 23 April 2014 06:13

m.abdulhaq
Messages: 253
Registered: April 2013
Location: Ajman

Senior Member

Quote:

And do they use PUBLIC synonyms or not? If so, have they only different public synonyms or some of them are common?

thanks michael , yes we use public synonyms and they are common too.

Report message to a moderator

Previous Topic:	Redo geneated high in temp table
Next Topic:	Timezone setup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 07:43:14 CDT 2023