ORACLE12C New Concept CDB and PDB analysis

Reprinted from: http://www.cnblogs.com/siyunianhua/p/4004361.html

Original article title: "Ora-65096:invalid common user or role name" error when Oracle 12c creates a user

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;

----------------------------------------------------------------------------------------------------
Cdb$root

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

Sql>select Con_id,dbid,name,open_mode from V$pdbs;

3. The PDB Open:

sql> Alter pluggable database PDBORCL open;

4. View Container

Sql>select Con_id,dbid,name,open_mode from V$pdbs;

5. Switch container to PDB

Sql> alter session set CONTAINER=PDBORCL;

6. View current Use container

7. Create user

Sql>create user Informix identified by GMGL; Sql>grant dba to Informix;

ORACLE12C New Concept CDB and PDB analysis