topic Error creating a user or a Oracle 19c geodatabase on ArcGIS Pro 2.6.3 or ArcMap 10.8.1 in Geodatabase Questions

Error creating a user or a Oracle 19c geodatabase on ArcGIS Pro 2.6.3 or ArcMap 10.8.1

RafaelFernandes_de_Souza — Wed, 02 Dec 2020 17:24:20 GMT

I am receiving an error when trying to create an Enterprise Geodatabase or when creating a database user on Oracle 19c using ArcGIS Pro 2.6.3 or ArcMap 10.7.1, 10.8 or 10.8.1.

Please, see the attachment.

Re: Error creating a user or a Oracle 19c geodatabase on ArcGIS Pro 2.6.3 or ArcMap 10.8.1

George_Thompson — Wed, 02 Dec 2020 18:21:37 GMT

Can you provide some more information:

Screen shot of the GP tool parameters entered?
Is this an existing Oracle database or are you expecting the tool to create an Oracle DB and add the geodatabase functionality?
If existing, can you connect to the DB from Pro with a DB user (with just connect)?

Any other information that you can provide on the Oracle side would be useful. Thanks!

Re: Error creating a user or a Oracle 19c geodatabase on ArcGIS Pro 2.6.3 or ArcMap 10.8.1

RafaelFernandes_de_Souza — Wed, 02 Dec 2020 18:42:55 GMT

Hello George.

In the parameters I entered the instance and db info, sys password and sde password to create sde user. I have provided the keycodes file too.

The instance already have the database created.

I can connect to the database with the info provided to the tool with sys user.

Re: Error creating a user or a Oracle 19c geodatabase on ArcGIS Pro 2.6.3 or ArcMap 10.8.1

RafaelFernandes_de_Souza — Wed, 02 Dec 2020 18:52:02 GMT

George,

On the Oracle side, I just installed and created the database with sys and system users enabled.

The database is not container.

Re: Error creating a user or a Oracle 19c geodatabase on ArcGIS Pro 2.6.3 or ArcMap 10.8.1

George_Thompson — Wed, 02 Dec 2020 19:26:07 GMT

Ok, thanks for that additional information.

You may need to create the database (shell) in a container

A new option starting with Oracle 12c, called Multitenant Architecture, consisting of a container database that can hold many pluggable databases, is supported at the pluggable database level. ArcGIS supports the same functionality in pluggable databases as is supported for Oracle 11g R2.
https://desktop.arcgis.com/en/system-requirements/latest/database-requirements-oracle.htm

Can you try that and report back?

Re: Error creating a user or a Oracle 19c geodatabase on ArcGIS Pro 2.6.3 or ArcMap 10.8.1

RafaelFernandes_de_Souza — Wed, 02 Dec 2020 19:55:57 GMT

I will try and report back.

Re: Error creating a user or a Oracle 19c geodatabase on ArcGIS Pro 2.6.3 or ArcMap 10.8.1

RafaelFernandes_de_Souza — Fri, 04 Dec 2020 18:19:48 GMT

George,

I contacted the Oracle support and we solved this issue of create enterprise geodatabase.

Thank you a lot for the help.

Re: Error creating a user or a Oracle 19c geodatabase on ArcGIS Pro 2.6.3 or ArcMap 10.8.1

George_Thompson — Fri, 04 Dec 2020 18:29:30 GMT

Was the issue related to the DB not being a container?

Appreciate the update.

Re: Error creating a user or a Oracle 19c geodatabase on ArcGIS Pro 2.6.3 or ArcMap 10.8.1

RafaelFernandes_de_Souza — Wed, 06 Jan 2021 20:38:08 GMT

Hi @George_Thompson, The problem was not related with being or not a container.

They created the db in their environment. I think that was something wrong that I did in configuring Oracle in my environment to test.