Home » RDBMS Server » Server Administration » Centralizing two instances (Oracle 10g)
Centralizing two instances [message #612633] Tue, 22 April 2014 22:45 Go to next message
m.abdulhaq
Messages: 254
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.
Re: Centralizing two instances [message #612634 is a reply to message #612633] Tue, 22 April 2014 22:51 Go to previous messageGo to next message
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;
Re: Centralizing two instances [message #612639 is a reply to message #612634] Wed, 23 April 2014 00:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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?

Re: Centralizing two instances [message #612695 is a reply to message #612634] Wed, 23 April 2014 06:10 Go to previous messageGo to next message
m.abdulhaq
Messages: 254
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.


Re: Centralizing two instances [message #612696 is a reply to message #612639] Wed, 23 April 2014 06:13 Go to previous message
m.abdulhaq
Messages: 254
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.
Previous Topic: Redo geneated high in temp table
Next Topic: Timezone setup
Goto Forum:
  


Current Time: Thu Mar 28 12:58:56 CDT 2024