ArcSDE 10.1 (Orcale client 11g R2 64 bit) & ArcSDE 9.3.1 (Orcale client 11gR2 32 bit)

Question

Dear Admins,

I am having 64 bit Oracle 11g R2 database server in Windows Server 2008 R2 operating System.

I need to install ArcSDE 9.3.1 in Windows Server 2003 32bit OS with oracle 11gR2 Client.

As well as need to install ArcSDE 10.1 in Windows Server 2008 64bit OS. with oracle 11gR2 Client.

Can I use a single database for implementing both version of ArcSDE envoirnment with different system???

Please suggest / share valuable inputs & experience from possibilities and especially performance point of view.

Thanks in advance.

Regards 
Ashish

WilliamCraft · Answer

Within the same Oracle instance and within the same Oracle database, you can have multiple user-schema geodatabases but one and only one SDE schema (referred to often as the master schema).  In other words, you have one master geodatabase and multiple user-schema geodatabases which are essentially system-managed through the SDE schema.  All of those user schemas MUST be at the same Esri release; you cannot have one user schema at 9.3.1, one at 10.0, and another at 10.1 SP1 while the SDE user schema is at 10.2.  Upgrading the geodatabase will migrate all user schemas to the same version (at 10.1 and higher, the Upgrade Geodatabase tool does this automatically) and it's not possible to use multiple releases, period.

Ashish_KumarGupta · Answer

Hi Vangelo,

Yeah beside this can I've multigeodatabase with same configuration scenario, with ArcSDE version using a single oracle database as well as single oracle instance???

Regards
Ashish

VinceAngelo · Answer

Besides this?You cannot configure a single Oracle instance to run more than one ArcGIS
geodatabase (not with one ArcGIS release, nor with multiple releases).

- V