{"id":3713,"date":"2013-11-29T08:21:04","date_gmt":"2013-11-29T08:21:04","guid":{"rendered":"http:\/\/blog.esds.co.in\/?p=3713"},"modified":"2019-01-25T09:30:59","modified_gmt":"2019-01-25T09:30:59","slug":"creating-container-and-pluggable-databases-using-dbca","status":"publish","type":"post","link":"https:\/\/www.esds.co.in\/blog\/creating-container-and-pluggable-databases-using-dbca\/","title":{"rendered":"Creating Container and Pluggable Databases using DBCA"},"content":{"rendered":"

In my earlier article, we got the short and sweet understanding of Multi-Tenant database, its features and benefits. The intent of article is understanding the process of creating Container Databases CDB <\/i><\/b>that can hold none, single or many Pluggable Databases PDB<\/i><\/b>.<\/p>\n

The creation of CDB databases is as almost same as those in previous releases, whereas there is difference in PBD <\/i><\/b>databases. Also we shall further see the way we connect to this databases. And finally how to plug and unplug the databases.<\/p>\n

We shall start with Creating Container Database. We shall make use of DBCA utility to create the both CDB and PDB databases. The very first screen we see the introductory screen prompting us selection of operations for creation and managing. Select \u201cCreate Database\u201d and move ahead.<\/p>\n

\"image001\"<\/p>\n

Select the \u201cAdvance Option\u201d, this gives clear picture of the options with which we are about to create container database.<\/p>\n

\"image002\"<\/p>\n

Here as we can select the template as our requirement. In our case \u201cGeneral Purpose or Transactional Processing\u201d and get going.<\/p>\n

\"image003\"<\/p>\n

Name the database as you wish, in our case here \u201cCBD\u201d. We also see the option to create the database as container database with or without any pluggable database. Here, I have chosen to \u201cCreate As Container Database\u201d with \u201cCreate and Empty container Database\u201d.<\/p>\n

\"image004\"<\/p>\n

Select the option to Configure and Register with EM.<\/p>\n

\"image005\"<\/p>\n

Provide the passwords for database users. Here, I have specified the same password for all the database users.<\/p>\n

Again, you will notice on more textbox, where you need to provide the oracle password that you provided while installing database software. This is additional to Oracle 12c release.<\/p>\n

\"image006\"<\/p>\n

Choose the listener name and port number on which listener will listen. And click \u201cNext\u201d.<\/p>\n

\"image007\"<\/p>\n

Select the storage options and Archiving, as per requirement and click \u201cNext\u201d<\/p>\n

\"image008\"<\/p>\n

If you are using database vault, configure the vault options else click \u201cNext\u201d, as default settings.<\/p>\n

\"image009\"<\/p>\n

Configure memory and sizing for database.<\/p>\n

\"image010\"<\/p>\n

You can save the database creation script for further reference.<\/p>\n

\"image011\"<\/p>\n

You can see the summary of the options you have selected so far. If you wish you can go back and change the settings. Click \u201cFinish\u201d to start the installation.<\/p>\n

\"image012\"<\/p>\n

You see the progress of installation step-by-step.<\/p>\n

\"image013\"<\/p>\n

\"image014\"<\/p>\n

\"image015\"<\/p>\n

Click \u201cClose\u201d and here you have successfully created the container database. Now let us create the pluggable database in this container.<\/p>\n

Creating Pluggable Database is very simple process. The only you specified to Container are directly applicable to pluggable database. From DBCA, select the \u201cManage Pluggable Databases\u201d and move \u201cNext\u201d.<\/p>\n

\"image016\"<\/p>\n

Select the option to create the pluggable database here.<\/p>\n

\"image017\"<\/p>\n

Select the container in which you want to create the pluggable database. In our case, we only have CDB.<\/p>\n

\"image018\"<\/p>\n

Specify \u201cCreate new Pluggable Database\u201d and Click \u201cNext\u201d.<\/p>\n

\"image019\"<\/p>\n

Provide the name of database as \u201cPDB\u201d, provide the username and password for this database.<\/p>\n

\"image020\"<\/p>\n

Have glance at the options selected and modify if required. And \u201cFinish\u201d to create the database.<\/p>\n

\"image021\"<\/p>\n

You can see the progress of database creation step-by-step.<\/p>\n

\"image022\"<\/p>\n

\"image023\"<\/p>\n

Click \u201cClose\u201d to complete the creation of PDB.<\/p>\n

Now once the both container and pluggable database are created, it\u2019s important to understand the how to connect to both databases. We must know differences in the database. If it is container what are different pluggable database in it. How do we switch between containers? We shall learn about this in next article.<\/p>\n","protected":false},"excerpt":{"rendered":"

In my earlier article, we got the short and sweet understanding of Multi-Tenant database, its features and benefits. The intent of article is understanding the process of creating Container Databases CDB that can hold none, single or many Pluggable Databases PDB. The creation of CDB databases is as almost same as those in previous releases,… <\/p>\n

<\/div>\n

Read More<\/a><\/p>\n","protected":false},"author":18,"featured_media":3728,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[197],"tags":[1190],"class_list":["post-3713","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-backup-services","tag-pluggable-databases"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/posts\/3713","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/comments?post=3713"}],"version-history":[{"count":7,"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/posts\/3713\/revisions"}],"predecessor-version":[{"id":9558,"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/posts\/3713\/revisions\/9558"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/media\/3728"}],"wp:attachment":[{"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/media?parent=3713"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/categories?post=3713"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esds.co.in\/blog\/wp-json\/wp\/v2\/tags?post=3713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}