ORA-65096 invalid common user or role name
Oracle SQL Error: ORA-65096: 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.
Solution:
Ask the database administrator to perform the operation or grant the required privileges or specify a valid common user or role name.
Example:
CREATE USER test2 IDENTIFIED BY test_user2
Output:
SQL Error: ORA-65096: invalid common user or role name
Correct
Connect as SYSDBA and execute the following commands:
alter session set "_ORACLE_SCRIPT"=true; CREATE USER test2 IDENTIFIED BY test_user2 ;
Output:
Session altered.
User TEST2 created.
