ORA-65096: Invalid Common User Or Role Name

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 20 Dec, 2023
  • 0 Comments
  • 1 Min Read

ORA-65096: Invalid Common User Or Role Name

Problem :

While creating a user in root container multitenant database, got this error.
Solution :
We can’t create normal users in root containers. We can create only common users which start with c## in root container.
SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL> create user c##TESTUSER identified by TESTUSER;

User created.