ArcGIS Enterprise 10.9.1: Enabling Oracle 19.3 database fails and ends up with “Geodatabase must be created under SDE schema” error,

JamalNUMAN

ArcGIS Enterprise 10.9.1: Enabling Oracle 19.3 database fails and ends up with “Geodatabase must be created under SDE schema” error,

 

 

I couldn’t figure out why enabling Oracle 19.3 database fails and ends up with “Geodatabase must be created under SDE schema” error

 

“Geodatabase must be created under SDE schema.  You cannot create a geodatabase in Oracle in any other schema starting with ArcGIS 10.7 and ArcGIS Pro 2.3”

 

How this issue can be resolved?

 

George_Thompson

When you run the enable you must have the SDE user / tablespace already created. Based on your screenshots, you need to run the Create Enterprise Geodatabase tool, since you have the "sys" user.

Here are the workflows; https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/setup-geodatabase-oracle.htm for both paths.