Oracle 12c Creation User is an error that appears "ora-65096:invalid common user or role name"

This article mainly introduces the basic management of CDB and PDB, data source Oracle official.

Basic concepts:

Multitenant Environment: Multi-tenant environment

CDB (Container database): DB container

PD (Pluggable database): pluggable databases

CDB vs. pdb diagram

COMMON users (ordinary users): often built on the CDB layer, user name in C # #或c # #开头;

Local Users: Only the PDB layer is established, and container is specified when it is established.

In Oracle 12c, using a container (container) concept, let's take a look at the official introduction of it, in order to preserve the original meaning, here is quoted in English instead of translation.

The data dictionary in each container in a CDB are separate, and the current container is the container whose data Dictiona Ry is used for name resolution and for privilege authorization. The current container can be the root or a PDB. Each session had exactly one current container at any point in time, but it was possible for a session to switch from one C Ontainer to another.

Each container have a unique ID and name in a CDB. You can use the con_id and Con_name parameters in the USERENV namespace to determine the current container ID and NAME wit H the Sys_context function.

1. View version of Oracle 12c

SQL>Select* from V$version;

SQL>SelectSys_context ('USERENV', 'Con_name')  fromdual;
Sys_context ('USERENV','Con_name')
----------------------------------------------------------------------------------------------------
Cdb$root

2. We can specify other containers by alter SESSION SET CONTAINER

SQL > Select   from V$pdbs;

3. The PDB Open:

SQL > Alter Database Open;

4. View Container

SQL>Select from V$pdbs;

5. Switch container to PDB

SQL>alterset container=PDBORCL;

6. View current Use container

SQL>Select sys_context ('USERENV'con_name  ' from

7.

Oracle 12c Creation User is an error that appears "ora-65096:invalid common user or role name"