{"id":12780,"date":"2024-01-04T08:39:20","date_gmt":"2024-01-04T07:39:20","guid":{"rendered":"https:\/\/roglacup.com\/klaus62\/?p=12780"},"modified":"2024-01-05T08:20:50","modified_gmt":"2024-01-05T07:20:50","slug":"how-to-check-open-open","status":"publish","type":"post","link":"https:\/\/roglacup.com\/klaus62\/2024\/01\/04\/how-to-check-open-open\/","title":{"rendered":"How to check &#038; open PDB"},"content":{"rendered":"\n<p>The&nbsp;<strong>multitenant architecture<\/strong>&nbsp;enables an Oracle database to function as a multitenant container database (CDB).<\/p>\n\n\n\n<p>A&nbsp;<a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/multi\/glossary.html#GUID-135FF536-DE9B-40CF-9F42-C246762BD77F\">CDB<\/a>&nbsp;includes zero, one, or many customer-created pluggable databases (PDBs). A&nbsp;<a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/multi\/glossary.html#GUID-D6932E25-775E-4FF1-BB08-F8999629093C\">PDB<\/a>&nbsp;is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a&nbsp;<a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/multi\/glossary.html#GUID-B2710CAA-8F00-40B3-97AB-4521D2147EE8\">non-CDB<\/a>. All Oracle databases before Oracle Database 12<em>c<\/em>&nbsp;were non-CDBs.<\/p>\n\n\n\n<p>The v$pdbs view is use with a pluggable database.&nbsp;<\/p>\n\n\n\n<p>select name,open_mode from&nbsp;v$pdbs;<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Open the pluggable database<\/strong>:<\/p>\n\n\n\n<p>SQL&gt; alter pluggable database pdbhammer open;<\/p>\n\n\n\n<p>Pluggable database altered.<\/p>\n\n\n\n<p>SQL&gt;<\/p>\n\n\n\n<p>Link : <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/multi\/introduction-to-the-multitenant-architecture.html#GUID-267F7D12-D33F-4AC9-AA45-E9CD671B6F22\">https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/multi\/introduction-to-the-multitenant-architecture.html#GUID-267F7D12-D33F-4AC9-AA45-E9CD671B6F22<\/a><\/p>\n\n\n<p>[the_ad id=&#8217;12166&#8242;]<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The&nbsp;multitenant architecture&nbsp;enables an Oracle database to function as a multitenant container database (CDB). A&nbsp;CDB&nbsp;includes zero, one, or many customer-created pluggable databases (PDBs). A&nbsp;PDB&nbsp;is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a&nbsp;non-CDB. All Oracle databases before Oracle Database 12c&nbsp;were non-CDBs. The v$pdbs view is use&hellip;&nbsp;<a href=\"https:\/\/roglacup.com\/klaus62\/2024\/01\/04\/how-to-check-open-open\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">How to check &#038; open PDB<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":12785,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[884,1047],"tags":[1524],"class_list":["post-12780","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-oracle-it-vendors","tag-pdb-cdb"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/12780","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/comments?post=12780"}],"version-history":[{"count":3,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/12780\/revisions"}],"predecessor-version":[{"id":12786,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/12780\/revisions\/12786"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media\/12785"}],"wp:attachment":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media?parent=12780"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/categories?post=12780"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/tags?post=12780"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}