Failed to access DBMS Server while creating enterprise geodatabase

wizgis

Hi Community, 

Am very new to Oracle so this might be a very simple question. 

Environment: ArcGIS Pro 3.2 & Oracle 19c (Client & DB are on same machine)

I have created a database in Oracle and am able to connect to it in ArcGIS Pro through SDE as well SYS user and can run the tool of Enable Enterprise Geodatabase successfully however, if I try to create a new enterprise geodatabase using the Create Enterprise Geodatabase tool it fails with the error of Failed to access DBMS server.

I observed that if I create the database in oracle and run the tool of Create Enterprise Geodatabase by giving <server name/dbname> in the instance parameter then it also runs successfully. 

I would like to know that in Oracle is it necessary to create the database from the Oracle end as in SQL Server or PostgreSQL we can run the tool of Create Enterprise Geodatabase and it will create the database and configure it with GDB behavior. 

George_Thompson

Most people using Oracle create the database in Oracle, then you can run either tool (Create / Enable - if you have the SDE user already).

Here is the doc on this: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/setup-geodatabase-oracle.htm