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"