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

479
2
03-26-2018 09:41 AM
BrandiKirchhoff
New Contributor III

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.  

0 Kudos
2 Replies
ModyBuchbinder
Esri Regular Contributor

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.

0 Kudos