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

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

JamalNUMAN — Thu, 22 Sep 2022 07:15:41 GMT

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?

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

George_Thompson — Thu, 22 Sep 2022 10:46:40 GMT

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.

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

JamalNUMAN — Thu, 22 Sep 2022 11:15:04 GMT

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?

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

George_Thompson — Thu, 22 Sep 2022 12:16:14 GMT

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

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

JamalNUMAN — Sat, 24 Sep 2022 06:20:48 GMT

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?