Oracle 12c create PDB user i.e. local user (PDB and CDB)

Source: Internet
Author: User

Oracle 12C user creation vs. table space allocation
After the database installation is complete, the table space ' IMEI ' in the Database Container (CDB) is first created with the System User link Database Container (CDB) sql>create
Tablespace
Iemi
DataFile ' E:\Oracle_DB\
cdb_iemi.dbf ' size 10240m autoextend on next 200m; The tablespace has been created.
The next time a user is created in the Oracle 12C database, ORA-65096 errors are reported. Sql> create user IMEI identified by IMEI default tablespace imei temporary tablespace imei_temp; *
ERROR at line 1:
Ora-65096:invalid common user or role name ORA-65096: The public user name is not valid
I've never seen this error before, what is a generic user (common)? The previous version is not the concept Ah, Internet search to see the following image, the original and common user corresponding to the local user.

This common user and local user are related to the new feature pluggable database (PDB) for Oracle 12c. The user that is created in the PDB is local user. As can be seen, common user must try to establish a C # #开头的common user in either uppercase or lowercase C # #开头.

sql> Create User C # #imei identified by IMEI default tablespace imei temporary tablespace imei_temp; User created.
Sql> Grant DBA to C # #imei; Grant succeeded.
Each PDB is a separate unit with its own user (local user), tablespace, data file, and each local user has access to its own PDB, and common user can access any PDB as long as the permissions are sufficient.

Oracle 12C introduces new features of CDB and PDB, allowing a single database container (CDB) to host multiple pluggable databases (PDB) in a multi-tenancy environment (multitenant environment) introduced by Oracle 12C. CDB is all called container database, the Chinese translation is a data base container, the PDB is all called pluggable database, you can plug and Unplug databases. Before Oracle 12C, the instance and database were one-to-one or many-on relationships (RAC): an instance could be associated with only one database, and the database could be loaded by multiple instances. The instance and database cannot be a one-to-many relationship. When you enter Oracle 12C, the instance and database can be a one-to-many relationship. The following is an official document about the CDB vs. pdb diagram.

CDB component (components of a CDB) a CDB database container contains the following components: Root component
ROOT is also known as Cdb$root, which stores the metadata provided by Oracle and the Common user, an example of which is the source code for the PL/SQL package provided by Oracle, Common user refers to users who exist in each container.

Oracle 12c create PDB user i.e. local user (PDB and CDB)

Related Article

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.