Oracle databases are always extremely advanced and sophisticated software components that are state of the art for RDBMS.

Till 12.1 came into the market we used to have Single Database associated with Single Instance [Except RAC environment], to support each application we need to create a new database. So the organization which handles 50 different applications will have 50 databases, so the storage, computing power, and memory requirements are high in this case.

For each application, Oracle has its own background processes and SGA defined. To upgrade or patching your applications you need to do those activities 50 times according to this example. Every time you need to patch your databases you need to handle each database separately.

But then, Oracle released 12c a Multitenant architecture..!!!

As a name implies Multi-tenant, there is a container database which acts as a root database instance and each of the Pluggable Databases run within that single Container Database as tenants.

Note: In 12c, ‘C’ means cloud. However, there is no requirement that Oracle 12c must run in the cloud; you may run Oracle 12c just like you run other versions of Oracle without the cloud.

Where you can create a Single container database and plug your all 50 databases in that container database. In multi-tenant architecture each database application can appear to have its own private database, but, in reality, the system is a shared database environment. Use of shared resources and virtualization is a method used by companies and database providers to reduce costs.

The above diagram shows how we can plug a single application database in a container database. For each application we don’t need to create a different database, we can just create a pluggable a database in available container database.

Benefits of Multitenant Architecture :

  • Operates multiple databases in a centrally managed platform to lower costs:
  • It is fully backward compatible with NON-CDBS, databases created without multi-tenancy, it is not necessary to create a database as container database, we can still create non-CDB in 12c database.
  • It is fully operable with Data Guard and RAC.
  • We can use Enterprise manager with the 12c database too.
  • To do upgrade and patching we don’t need to upgrade a single database, we can upgrade all pluggable database in a single shot by upgrading the container database.
  • We can back up the CDB database with RMAN.

In the next article, we will explore the Container Database and Pluggable database in depth.

Stay tuned for More articles on Oracle Multitenant

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.