ORA-65096: invalid common user or role name

 ORA-65096: invalid common user or role name means you logged on the CDB where you should be logged into a PDB.

 

This can be avoid by setting hidden parameter "_ORACLE_SCRIPT"=true.

 

Since this hidden parameter hence it is always advisable to use it under direction of Oracle Support.

 

SQL> create user shaan identified by shaan123 default tablespace users quota unlimited on users;
create user shaan identified by shaan123 default tablespace users quota unlimited on users
            *
ERROR at line 1:
ORA-65096: invalid common user or role name


SQL> alter session set "_ORACLE_SCRIPT"=true;

Session altered.

SQL> create user shaan identified by shaan123 default tablespace users quota unlimited on users;

User created.

SQL> grant connect, resource to shaan;

Grant succeeded.

SQL> conn shaan/shaan123
Connected.
SQL> show user
USER is "SHAAN"