TutorialDBA - Support | Training | Consultant

Oracle has modified its architecture by introducing the concept of containers. The main component of this architecture is the CDB container. It is a container which owns the memory structure, the background processes and SYSTEM, SYSAUX tablespaces which are all shareable with other databases which are “plugged” into it. The SGA for the CDB consists of the traditional memory components such as the Buffer cache and Shared pool, DBWR and LGWR processes, which access the SYSTEM, SYAUX and UNDO tablespaces. These ‘plugged-in’ databases are also called PDB databases. While the CDB container stores most of the metadata information, the user data is stored in the user tablespace which is part of the PDB database. This ensures that the system metadata is totally segregated and that the individual tablespaces in the PDB is only visible within the PDB that the tablespace is a part of. Read more details in the articles below. Benefits of Multitenant Databases in Oracle 12c With O...

When installing Oracle Software using OUI, you can create and configure a database, just like you used to do in the previous versions of the Oracle database. However, due to the new multitenant architecture there are some changes in options presented to you. In this article we will look at how you can create and configure 12c CDB/PDBs’ using the OUI, as part of software installation process. Create 12c CDB, PDB Databases Using OUI To create and configure a CDB/PDB database, as part of an installation, you must choose the option to Install the software and create a database. This will enable OUI to call the DBCA once the software installation is complete. Whether you choose the Basic installation method or the Advanced installation, the options presented to you are pretty similar. Below is the screen that you can use to specify the creation of database. The option of prime importance is the checkbox at the end, which asks you whether you want to  create a container datab...

he Oracle 12c Database has the most new features ever released with any version of any database. As you might have guessed from it’s name, the new version is more focused on Cloud Computing. Larry Ellison had pointed out in his Keynote session, at Openworld 2012, that in-fact it is the biggest release of database that they have done in quite some time. This time there have been some drastic architectural changes in this version, with about 500 new features! Container and Pluggable Databases 12c Pluggable Databases Oracle 12c Container and Plugable Databases It is a major design change on how Oracle deals with databases and the underlying architecture. This is the most talked about feature in Oracle 12c. Oracle introduces the concept of Container databases and Pluggable databases. The container database has all the metadata which will be inherited by the core Oracle components when it is installed. Pluggable databases will store user’s data and other pertinent metadata. Thi...

In 12c, the database configuration assistant can also be used to manage the PDB’s alongside the CDB and non-CDB databases. In this article we will look at managing the PDBs, using the database configuration assistant. Managing PDBs When you launch DBCA, you will see a new option “Manage Pluggable Databases”, as shown below. The new Manage Pluggable databases option can be used to manage the PDBs inside the different CDBs. The following sections demonstrate the different options available in DBCA, with respect to PDB management. Create PDB Database You can create a new PDB by clicking Next once the Manage Pluggable Databases option is selected in the DBCA. The following screens will guide you through the process of creating a new PDB database. Choose the Create option and click Next. Choose the CDB container for which the new PDB database should be part of. You will also have to provide the SYSDBA credentials for the CDB chosen. Then click on Next. You can ...