Como criar um usuário no Oracle Database e entender os conceitos de CDB e PDB

Oracle 12c: CREATE USER

No Oracle Database 12c você pode criar um banco de dados do jeito antigo, ou criar um Container Database (CDB), que irá ter abaixo dele um ou mais Pluggable Databases (PDB).

Para criar um usuário no Oracle Database 12c, ou você cria dentro de um Pluggable Database (PDB), ou você cria um usuário “common” (no CDB), que aparece em todos os PDBs. Este usuário “common”, precisa começar com C##.

A seguir, tento criar um usuário no CDB, depois tento cria-lo dentro de um PDB específico (eu tenho dois PDBs, HOMOLOG1 e HOMOLOG2).

[oracle@nerv00 ~]$ sqlplus / AS SYSDBA
 
 SQL*Plus: Release 12.1.0.1.0 Production on Sun Jun 30 08:53:55 2013
 
 Copyright (c) 1982, 2013, Oracle. All rights reserved.
 
 Connected to:
 Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
 With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
 
 SQL> CREATE USER PORTILHO IDENTIFIED BY Nerv2013;
 CREATE USER PORTILHO IDENTIFIED BY Nerv2013
 *
 ERROR at line 1:
 ORA-65096: invalid common user or role name
 
 SQL> SELECT PDB FROM V$SERVICES;
 
 PDB
 ------------------------------
 HOMOLOG2
 HOMOLOG1
 CDB$ROOT
 CDB$ROOT
 CDB$ROOT
 CDB$ROOT
 
 6 rows selected.
 
 SQL> ALTER SESSION SET CONTAINER=HOMOLOG1;
 
 Session altered.
 
 SQL> CREATE USER PORTILHO IDENTIFIED BY Nerv2013;
 
 User created.
 
 SQL> EXIT
 Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
 With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
 [oracle@nerv00 ~]$

Agora eu crio um usuário “common”, no CDB mesmo.

[oracle@nerv00 ~]$ sqlplus / AS SYSDBA
 
 SQL*Plus: Release 12.1.0.1.0 Production on Sun Jun 30 08:53:55 2013
 
 Copyright (c) 1982, 2013, Oracle. All rights reserved.
 
 Connected to:
 Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
 With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
 
 SQL> CREATE USER PORTILHO IDENTIFIED BY Nerv2013;
 CREATE USER PORTILHO IDENTIFIED BY Nerv2013
 *
 ERROR at line 1:
 ORA-65096: invalid common user or role name
 
 SQL> CREATE USER C##PORTILHO IDENTIFIED BY Nerv2013;
 
 User created.
 
 SQL> EXIT
 Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
 With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
 [oracle@nerv00 ~]$

Recomendo a leitura da documentação sobre os conceitos de CDB e PDB.

• http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdblogic.htm#CNCPT89259