topic Re: Are the DBA and DBA password really "OPTIONAL" when using Create Enterprise Geodatabase? Anyone tried creating a user geodatabase in Oracle RDS on AWS? in Developers Questions

Are the DBA and DBA password really "OPTIONAL" when using Create Enterprise Geodatabase? Anyone tried creating a user geodatabase in Oracle RDS on AWS?

BrandiKirchhoff — Mon, 26 Mar 2018 16:41:33 GMT

I'm trying to create a user/schema enterprise geodabase using the Create Enterprise Geodatabase geoprocessing tool. In the tool, the database administrator (DBA) & DBA password are marked as "optional"; however. the documentation states you HAVE to login as DBA ('sys' in Oracle) in order to create a user/schema geodatabase. We are attempting to test replication in Oracle RDS on AWS and do not have access to the "sys" account so I'm not sure if there is a workaround if these are "optional". Is anybody using Oracle RDS in AWS as their enterprise geodatabase? Thank you for any information anyone might have about the possibility of working around this complication in Oracle RDS.

Re: Are the DBA and DBA password really "OPTIONAL" when using Create Enterprise Geodatabase? Anyone tried creating a user geodatabase in Oracle RDS on AWS?

George_Thompson — Mon, 26 Mar 2018 16:50:47 GMT

Adding a larger audience: Geodatabase‌ Enterprise GIS‌ArcGIS Enterprise‌

It also looks like you can have enterprise geodatabases on AWS with PostgreSQL or SQL Server.

Geodatabases on Amazon Web Services—ArcGIS Enterprise on AWS | ArcGIS Enterprise

Geodatabases in PostgreSQL included with ArcGIS Enterprise on Amazon Web Services—ArcGIS Enterprise on AWS | ArcGIS Ente…

Enterprise geodatabases in SQL Server on Amazon Web Services—ArcGIS Enterprise on AWS | ArcGIS Enterprise

Optional enterprise geodatabase management—ArcGIS Enterprise on AWS | ArcGIS Enterprise

Re: Are the DBA and DBA password really "OPTIONAL" when using Create Enterprise Geodatabase? Anyone tried creating a user geodatabase in Oracle RDS on AWS?

ModyBuchbinder — Tue, 27 Mar 2018 05:16:21 GMT

You must remember that this GPtool works for different RDBMS.

In case of Oracle you must use sys with its password.

If you work with Sql Server and use windows authentication and your login is the manager then you do not have to give password.

It will fail for Oracle if you do not give password.