understanding oracle pluggable databases

All we need is an easy explanation of the problem, so here it is.

I’m learning a little bit about Oracle Database. As I understand:

  • In previous versions of Oracle DB (versions <= 11ng), each DB should be installed in a
    separate server.

    1. Is this statement true? We can’t create more than of one database in each instance of Oracle installation? or I’m missing something here.
  • To take care of the problem, oracle updated its architecture and introduced the pluggable databases.

    1. Why not just using the same architecture of other DBMS systems like MySQL whre you can have N number of databases in you single installation of DBMS?

I’m guessing that I’m not fully understanding the first statement as I never had any experiences with Oracle Database.

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

Two things going on here:

First, Oracle defines "database" differently than other "databases" like MySQL. When Oracle talks about a database, they mean the physical instance of the software, data files, and processes that run on on the server. Each database instance may house hundreds or thousands of individual users/schemas, each with their own tables and other objects. It is possible to run multiple database instances on a single server – even using different versions of the software simultaneously. Operating multiple instances/databases – usually but not always of the same version – on a single server is quite common, actually.

Most other database engines equate "database" with a single schema of objects, and often only support one installation of the software on an individual server, though they may house hundreds or thousands of users/schemas.

Second, Oracle’s pluggable databases (introduced in Oracle 12c) are a virtualization of the database instance (the running processes, data files, etc.) that allows them to share some common, system-level resources. A container database (CDB) manages those system level resources, and may host many pluggable databases (PDB). A single server may host multiple container databases of different software versions, each with their own pluggable databases. Each pluggable database may contain hundreds or thousands of users/schemas. The pluggable database architecture allows for consolidation of compute and storage resources: a higher density architecture that makes more efficient use of both on-premise and cloud hardware.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply