In Oracle 12c, Two ways to install the database.
Error: ORA-65096: invalid common user or role name in 12c
1. Same as 11g (standalone database one instance and one database)
2. Installed as container so later you can add as many pluggable database into it. (one instance handle multiple pluggable database).
In previous version of oracle up to 11g, Only one instance must handle one database except RAC environment.
In 12c Environment if you installed with 2nd option and you tried to execute the following command it will generated error.
It is the container database in which you got the following error.
you must need to put C## prefix for create the user in 12c version of Oracle.
Container database act as master database having all information of data dictionary and all pluggable database.
Note: C## is stand for common user. It is created in all databases present in 12c when we create it in ROOT container.(and pluggable database)
create user hr identified by hr;
create user hr identified by hr
ERROR at line 1:ORA-65096: invalid common user or role name In Oracle 12c When we try to create the normal user then it will generate the error
Check the container name in which container we are tried to execute the command in 12c
For creating user in CDB$ROOT container than create need to create user with prefix: C##.
#Create C##scott indentified by tiger;