ERROR

Oracle error ORA-65096 is received when performing operation that creates a new user or role

Last Published: March 18, 2023

Error Message

When running certain geoprocessing tools on an Oracle 12c database the following error is encountered:

"ORA-65096: invalid common user or role name."

Below are examples of error messages received using the Create Enterprise Geodatabase tool:

"Error creating geodatabase admin user. [ERROR: Failed to create new Oracle user sde (-51)."
"Error: Underlying DBMS error (-51).
Extended error code: (65096)"
"ORA-65096: invalid common user or role name."
"Failed to execute (CreateEnterpriseGeodatabase)."

This error is encountered when running the following tools:

  • Create Enterprise Geodatabase
  • Create Database User
  • Create Role

Cause

This is due to the specified Oracle instance being a container database. As part of the new multi-tenant functionality at Oracle 12c, databases can be created as a container database with associated pluggable database(s).

[O-Image]

Currently, Oracle is designed to support users at the container level only for administrative tasks. Due to this design, enterprise geodatabases do not function at the container level.

Solution or Workaround

Instead of providing the connection string to the container database, provide a connection string to one of the pluggable databases.

To check if a connection is to a container database run the following query in Oracle:

SELECT CDB FROM V$DATABASE;
[O-Image]

If the result of this query is 'YES', run the following query to determine if there are any pluggable databases within the container:

SELECT NAME, OPEN_MODE FROM V$PDBS WHERE CON_ID > 2;

If there are pluggable databases available:

  • Ask the database administrator¬†which pluggable database may be used to create an enterprise geodatabase.

Or,

  • If a pluggable database does not exist or is not available for use, visit Oracle's website for creating a pluggable database. Create Pluggable Database.

Article ID:000012259

Software:
  • Legacy Products
  • ArcMap

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic