My Oracle Support Banner

Schema Creator Gets 'ORA-65096: invalid common user or role name' During User Creation on Container Database (CDB) (Doc ID 2766225.1)

Last updated on MAY 15, 2024

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.1.0.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.1.0.0.0 and later
Oracle Financial Services Profitability Management - Version 8.1.0.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When attempting to run the Schema Creator with the Offline and Silent options with an Oracle Container Database (CDB), the user creation statement fails.

The following user creation statement is generated by the Schema Creator in sysdba_output_scripts.sql:

CREATE USER <CONFIG USERNAME> IDENTIFIED BY <PASSWORD> DEFAULT TABLESPACE <TABLESPACE NAME> TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON <TABLESPACE NAME>
/


This DDL fails with the error listed below:

ORA-65096: invalid common user or role name
65096. 00000 - "invalid common user or role name"
*Cause: An attempt was made to create a common user or role with a name
that was not valid for common users or roles. In addition to the
usual rules for user and role names, common user and role names
must consist only of ASCII characters, and must contain the prefix
specified in common_user_prefix parameter.
*Action: Specify a valid common user or role name.

As a result, you cannot proceed with the installation.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.