ORACLE12C New Concept CDB and PDB analysis

Source: Internet
Author: User
Tags informix unique id

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.