Error: Oracle error ORA-65096 is received when performing operation that creates a new user or role
【相关信息】
Article ID: 43411
Software:
ArcSDE 10.2.1, 10.2.2
ArcGIS for Desktop Advanced 10.2.1, 10.2.2
ArcGIS for Desktop Standard 10.2.1, 10.2.2
Platforms: N/A
【错误信息】
When running certain geoprocessing tools on an Oracle 12c database the following error is encountered:
"ORA-65096: invalid common user or role name."
Below is an example 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
【错误原因】
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).
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.
Article ID: 43411
Software:
ArcSDE 10.2.1, 10.2.2
ArcGIS for Desktop Advanced 10.2.1, 10.2.2
ArcGIS for Desktop Standard 10.2.1, 10.2.2
Platforms: N/A
【错误信息】
When running certain geoprocessing tools on an Oracle 12c database the following error is encountered:
"ORA-65096: invalid common user or role name."
Below is an example 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
【错误原因】
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).
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.
1 个回复
EsriSupport
赞同来自:
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:
If the result of this query is 'YES', run the following query to determine if there are any pluggable databases within the container:
If there are pluggable databases available, ask the DBA 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, please visit Oracle's website for creating a pluggable database.
Create Pluggable Database
Related Information
Created: 11/14/2014 Last Modified: 12/3/2014
【原文链接】
http://support.esri.com/en/kno ... 43411
要回复问题请先登录或注册