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 laterOracle 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 |