ORA-65096 invalid common user or role name

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.