You can get ” ORA-65096: invalid common user or role name ” error while creating new user in Oracle 12c.
ORA-65096: invalid common user or role name
When i create new user in Oracle 12c , i got following error.
[[email protected] ]$ sqlplus / as sysdba SQL*Plus: Release 220.127.116.11.0 Production on Thu Mar 21 10:01:05 2019 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 18.104.22.168.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> create user mehmet identified by mehmet; create user mehmet identified by mehmet * ERROR at line 1: ORA-65096: invalid common user or role name
invalid common user or role name
To solve this problem, execute following query and try to create new user again.
alter session set "_ORACLE_SCRIPT"=true;
If you got this error on Container database, then it is related with the user creation on pluggable and container database.
If you use Container and Pluggable database, you can create only common users which start with c## in root container.
SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> create user c##MSDBA identified by MSDBA123; User created.
If you created any common user on both root container and pluggable database, then this user can log in to any container. You need to give the priviliges separately within each pluggable database.
1,381 views last month, 3 views today