topic Re: Multiple geodatabase oracle in Geodatabase Questions

Multiple geodatabase oracle

yockee — Wed, 12 Jan 2022 08:20:21 GMT

Hi,

I just want explanation and discussion.

When do we use such configuration like the picture below ? Are they different geodatabases or single geodatabase but split into 2 databases ?

Thanks

Re: Multiple geodatabase oracle

George_Thompson — Wed, 12 Jan 2022 12:17:45 GMT

That looks like the suggested model. 1 Oracle database (instance) with 1 SDE schema. You can have multiple data owner or other schemas in the same Oracle geodatabase.

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/setup-geodatabase-oracle.htm

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/overview-geodatabases-oracle.htm

Re: Multiple geodatabase oracle

yockee — Thu, 13 Jan 2022 07:59:27 GMT

Hi George,

What might be the case for using this configuration ? I need a little elaboration...

thanks

Re: Multiple geodatabase oracle

George_Thompson — Thu, 13 Jan 2022 11:13:06 GMT

For which configuration?

If you have a need for a DEV / STAGE / PROD enterprise geodatabases, then you would create a new SID for each one.

You could have multiple data schemas in the same Oracle SID, i.e. GIS / WATER / SEWER / TRANS / etc.

Re: Multiple geodatabase oracle

yockee — Thu, 13 Jan 2022 12:15:18 GMT

I see. Thanks George. That really open my mind.

I was under impression that the configuration showed in the original pict i posted was for creating 1 geodatabase that incorporating 2 databases (2 databases that make up 1 geodatabase). I was using RAID analogy in interpreting the picture, ie : multiple HDDs combines into 1 logical HDD.

Thanks for clearing up.

Re: Multiple geodatabase oracle

George_Thompson — Thu, 13 Jan 2022 13:01:12 GMT

That used to be possible, but we do not support / recommend this approach. It was the user-schema geodatabase option.