{"id":1879,"date":"2016-12-17T00:01:43","date_gmt":"2016-12-17T06:01:43","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=1879"},"modified":"2026-02-07T15:27:14","modified_gmt":"2026-02-07T21:27:14","slug":"12-days-of-cloud-pdb-management-using-dbaas-monitor-console","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2016\/1879\/","title":{"rendered":"12 Days of #Cloud: PDB Management Using #DBaaS Monitor Console"},"content":{"rendered":"<h2>12 Days of #Cloud: Day 4<\/h2>\n<p><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/image22.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\" wp-image-1821 alignleft\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/image22.png?resize=116%2C67&#038;ssl=1\" alt=\"\" width=\"116\" height=\"67\" \/><\/a>DBaaS Monitor Console is part of the Oracle Database Cloud Service.\u00a0DBaaS Monitor Console provides information on the\u00a0database and operating system status and resource usage. If you are managing the database with Oracle Enterprise Manager Cloud Control or if you are familiar with Linux commands, then the status reports and resource usage charts in DBaaS Monitor may not be of much use. But the idea of Cloud Database is to minimize your need to access the Linux VM.<\/p>\n<p id=\"hTzoiPs\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-1884  aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_58540aafc7aa6.png?resize=385%2C369&#038;ssl=1\" alt=\"\" width=\"385\" height=\"369\" \/><\/p>\n<p>Login to the Database Monitor Console using the &#8220;dbaas_monitor&#8221; username and the administration password for the DBaaS Instance. Before you login, remember to open the HTTPS port 443 or create an SSH port forwarding tunnel. As soon as you login, you get to see an excellent overview of your database instance showing database status, listener status, last backup status, storage usage, memory usage and CPU usage.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-1880 alignleft\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5853625a79cf8.png?resize=107%2C343&#038;ssl=1\" alt=\"\" width=\"107\" height=\"343\" \/><\/p>\n<p>As you see in the Database menu, the monitor console gives some useful information that can be consumed by techies and non-techies. I hope in future, we will see more useful reports. Also, hopefully in the future, DBassS monitor console will be enhanced to send alerts on few critical metrics.<\/p>\n<ul>\n<li>Manage: This is the only menu item where you can make any change to the instance. This is where you manage the PDBs.<\/li>\n<li>Listener: Listener status and &#8220;lsnrctl\u00a0status&#8221; output.<\/li>\n<li>Storage: CDB and PDB storage summary as well as tablespace-wise.<\/li>\n<li>Backups: RMAN backup status<\/li>\n<li>Alerts: Aler log messages in an easy to filter framework.<\/li>\n<li>Sessions: Database sessions from CDB and PDB.<\/li>\n<li>Waits: Wait events and affected sessions.<\/li>\n<li>Parameters: Database parameters<\/li>\n<li>Real Time SQL Monitor: Status of SQL statements running in the database<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-1881 alignright\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_585362696c939.png?resize=75%2C187&#038;ssl=1\" alt=\"\" width=\"75\" height=\"187\" \/><\/li>\n<\/ul>\n<p>The OS menu shows Operating System metrics. The menu is pretty much self explanatory.<\/p>\n<p>OK, that was an\u00a0introduction to DBaaS Monitor Console.<\/p>\n<p>Let me get to the subject of this blog &#8211; Managing PDBs.<\/p>\n<p>Let me choose &#8220;Manage&#8221; option from the &#8220;Database&#8221; menu.<\/p>\n<p>The screen shows CDB and all the PDBs in the database and their open status.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-1885  aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_58548a3a690a5.png?resize=543%2C187&#038;ssl=1\" alt=\"\" width=\"543\" height=\"187\" \/><\/p>\n<p>At the CDB and PDB, you have a little menu icon to take action on the CDB or PDB. You can also see the option to create a new PDB.<\/p>\n<p id=\"GWJdIGk\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-1886  alignleft\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_58548ace1857e.png?resize=273%2C179&#038;ssl=1\" alt=\"\" width=\"273\" height=\"179\" \/>The PDB menu has options to<\/p>\n<ul>\n<li>Modify State: Open or Close a PDB<\/li>\n<li>Clone: To duplicate to another PDB<\/li>\n<li>Unplug: Create XML file and detach the PDB from CDB<\/li>\n<li>Drop: Delete the PDB<\/li>\n<li>Connection Details: Shows the database connect details &#8211; to connect using SQL*Plus and JDBC.<\/li>\n<\/ul>\n<p>Before taking action (clone, drop, unplug or modify state), you can click on the &#8220;Show SQL&#8221; button to verify and understand the SQL statements.<\/p>\n<p>When you are performing the operations, remember to choose the option of &#8220;Clone TDE Key&#8221; or &#8220;Export TDE Key&#8221; (depending on the action).<\/p>\n<p>SQL Statements for PDB Clone:<\/p>\n<pre class=\"font-size:10 height-set:true height:300 lang:default highlight:0 decode:true\">BEGIN\n   BEGIN\n      EXECUTE IMMEDIATE 'ADMINISTER KEY MANAGEMENT SET KEYSTORE CLOSE';\n   EXCEPTION\n      WHEN OTHERS THEN\n         NULL;\n   END;\n   BEGIN\n      EXECUTE IMMEDIATE 'ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY \"ABCDEF123#\"';\n   EXCEPTION\n      WHEN OTHERS THEN\n         NULL;\n   END;\nEND;\n\/\nALTER SESSION SET CONTAINER=\"PDBHR\"\n\/\nBEGIN\n   BEGIN\n      EXECUTE IMMEDIATE 'ADMINISTER KEY MANAGEMENT SET KEYSTORE CLOSE';\n   EXCEPTION\n      WHEN OTHERS THEN\n         NULL;\n   END;\n   BEGIN\n      EXECUTE IMMEDIATE 'ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY \"ABCDEF123#\"';\n   EXCEPTION\n      WHEN OTHERS THEN\n         NULL;\n   END;\nEND;\n\/\nALTER SESSION SET CONTAINER=CDB$ROOT\n\/\nBEGIN\n   EXECUTE IMMEDIATE 'CREATE PLUGGABLE DATABASE \"PDBHRARCHIVE\" FROM \"PDBHR\"\n      STORAGE UNLIMITED\n      TEMPFILE REUSE\n      FILE_NAME_CONVERT=NONE\n      KEYSTORE IDENTIFIED BY \"ABCDEF123#\"';\nEND;\n\/\nALTER PLUGGABLE DATABASE \"PDBHRARCHIVE\" OPEN READ WRITE\n\/\nALTER SESSION SET CONTAINER=\"PDBHRARCHIVE\"\n\/\nALTER SESSION SET CONTAINER=CDB$ROOT\n\/\nBEGIN\n   BEGIN\n      EXECUTE IMMEDIATE 'ADMINISTER KEY MANAGEMENT SET KEYSTORE CLOSE IDENTIFIED BY \"ABCDEF123#\" CONTAINER=ALL';\n   EXCEPTION\n      WHEN OTHERS THEN\n         NULL;\n   END;\n   BEGIN\n      EXECUTE IMMEDIATE 'SELECT * FROM V$ENCRYPTION_WALLET';\n   EXCEPTION\n      WHEN OTHERS THEN\n         NULL;\n   END;\n   EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE \"PDBHRARCHIVE\" CLOSE IMMEDIATE';\n   EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE \"PDBHRARCHIVE\" OPEN READ WRITE';\nEND;\n\/\nHOST rm -f \/tmp\/dbm-clone-1YWGI.p12\n\/\n<\/pre>\n<p>SQL statements for Plug in a PDB<\/p>\n<pre class=\"font-size:10 height-set:true height:300 lang:default highlight:0 decode:true\">BEGIN\n   EXECUTE IMMEDIATE 'CREATE PLUGGABLE DATABASE \"PDBHR2\"\n      AS CLONE\n      USING ''\/home\/oracle\/pdbhrarchive.xml''\n      SOURCE_FILE_NAME_CONVERT=NONE\n      NOCOPY\n      STORAGE UNLIMITED\n      TEMPFILE REUSE';\nEND;\n\/\nALTER PLUGGABLE DATABASE \"PDBHR2\" OPEN READ WRITE\n\/\nBEGIN\n   BEGIN\n      EXECUTE IMMEDIATE 'ADMINISTER KEY MANAGEMENT SET KEYSTORE CLOSE';\n   EXCEPTION\n      WHEN OTHERS THEN\n         NULL;\n   END;\n   BEGIN\n      EXECUTE IMMEDIATE 'ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY \"ABCDEF123#\"';\n   EXCEPTION\n      WHEN OTHERS THEN\n         NULL;\n   END;\nEND;\n\/\nALTER SESSION SET CONTAINER=\"PDBHR2\"\n\/\nBEGIN\n   BEGIN\n      EXECUTE IMMEDIATE 'ADMINISTER KEY MANAGEMENT SET KEYSTORE CLOSE';\n   EXCEPTION\n      WHEN OTHERS THEN\n         NULL;\n   END;\n   BEGIN\n      EXECUTE IMMEDIATE 'ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY \"ABCDEF123#\"';\n   EXCEPTION\n      WHEN OTHERS THEN\n         NULL;\n   END;\n   EXECUTE IMMEDIATE 'ADMINISTER KEY MANAGEMENT IMPORT ENCRYPTION KEYS WITH SECRET \"ABCDEF123#\" FROM ''\/home\/oracle\/pdbhrarchive.tdekey'' IDENTIFIED BY \"ABCDEF123#\" WITH BACKUP';\nEND;\n\/\nALTER SESSION SET CONTAINER=CDB$ROOT\n\/\nBEGIN\n   BEGIN\n      EXECUTE IMMEDIATE 'ADMINISTER KEY MANAGEMENT SET KEYSTORE CLOSE IDENTIFIED BY \"ABCDEF123#\" CONTAINER=ALL';\n   EXCEPTION\n      WHEN OTHERS THEN\n         NULL;\n   END;\n   BEGIN\n      EXECUTE IMMEDIATE 'SELECT * FROM V$ENCRYPTION_WALLET';\n   EXCEPTION\n      WHEN OTHERS THEN\n         NULL;\n   END;\n   EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE \"PDBHR2\" CLOSE IMMEDIATE';\n   EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE \"PDBHR2\" OPEN READ WRITE';\nEND;\n\/\n<\/pre>\n<p>So, do you have to use DBaaS Monitor Console to manage a PDB graphically? Of course not, SQL Developer is your friend.<\/p>\n<p id=\"JHYJfNE\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-1887  aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5854905c772f8.png?resize=408%2C288&#038;ssl=1\" alt=\"\" width=\"408\" height=\"288\" \/><\/p>\n<p>And, if you use OEM Cloud Control, you have one more tool to manage PDBs.<\/p>\n<p>Enjoy PDB!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>12 Days of #Cloud: Day 4 DBaaS Monitor Console is part of the Oracle Database Cloud Service.\u00a0DBaaS Monitor Console provides information on the\u00a0database and operating system status and resource usage. If you are managing the database with Oracle Enterprise Manager Cloud Control or if you are familiar with Linux commands, then the status reports and &#8230; <a title=\"12 Days of #Cloud: PDB Management Using #DBaaS Monitor Console\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2016\/1879\/\" aria-label=\"Read more about 12 Days of #Cloud: PDB Management Using #DBaaS Monitor Console\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[55],"class_list":["post-1879","post","type-post","status-publish","format-standard","hentry","category-cloud-autonomous","tag-oracle-cloud"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1879","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=1879"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1879\/revisions"}],"predecessor-version":[{"id":2993,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1879\/revisions\/2993"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1879"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1879"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1879"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}