ORA-65096: invalid common user or role name in 12c

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

show con_name

CON_NAME
——————————
CDB$ROOT

For creating user in CDB$ROOT container than create need to create user with prefix:  C##.

#Create C##scott indentified by tiger;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s