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-orac... for both paths.

[JamalNUMAN]

Performing the “create enterprise geodatabase” tool dnds up with the “ORA-12154: TNS: could not resolve the connect identifier specifiedNo extended error” error

What could be the issue here?

[George_Thompson]

just use the EZConnect string: ServerName/SID or make sure your TNS is configured correctly.

[JamalNUMAN]

The screenshots below show the content of the listener.ora and tnsnames.ora files. The “net manager” is also configured where the oracle home director is set to be:

C:\Oracle\Software\OracleDatabaseHome_X64_19.3

Nevertheless, the “create enterprise geodatabase” tool fails

What other issues I need to check?