Enable Enterprise Geodatabase Tools Error (Oracle)

[GIS_Solutions]

Hi,

We are getting an error in geodatabase creation. We first created a database with oracle 19c version. Then we used the Enable Enterprise Geodatabase tool, and got the error in image #1.

Afterwards, when we created a database using the Create Enterprise Geodatabase tool with a different name, we got the error in the image number 2.

We got the same errors when we tried these processes with ArcGIS Pro 2.3 and 2.6 or  ArcGIS10.7

Arcgis Pro 2.9.3

Oracle 19C3

64-bit client installed

   

[George_Thompson]

How was the Oracle database created on the 19c instance (i.e. scripting, DBCA, etc.)?

Where the steps here followed? https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/setup-geodatabase-orac...

After the second error, are you able to connect to the geodatabase as SDE?

[GIS_Solutions]

---

@George_Thompson wrote:

How was the Oracle database created on the 19c instance (i.e. scripting, DBCA, etc.)?

Where the steps here followed? https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/setup-geodatabase-orac...

After the second error, are you able to connect to the geodatabase as SDE?

---

Hi @George_Thompson 

"How was the Oracle database created on the 19c instance (i.e. scripting, DBCA, etc.)?"

Yes we are used DBCA

"Where the steps here followed? "

We followed the directions on this page and we have implemented all the work steps on the page

"After the second error, are you able to connect to the geodatabase as SDE?"

Although it says there is a database already exist, when we look through oracle, we see that it does not create the database.

[George_Thompson]

Ok, for the second error, the Create Enterprise Geodatabase GP tool will not create the database in Oracle. It must be created in Oracle first. The tool adds the correct schema, tables, etc. to the database "shell" to make it an Enterprise Geodatabase.

I looked at the initial error again (#1). What the name of the enterprise geodatabase administrator used in that tool?


It MUST be "SDE". We do not support user schema EGDB's anymore.