{"id":2258,"date":"2021-03-02T09:53:36","date_gmt":"2021-03-02T09:53:36","guid":{"rendered":"https:\/\/swiv.com.br\/creating-an-oracle-cdb-database-using-dbca-gui\/"},"modified":"2026-05-27T20:02:52","modified_gmt":"2026-05-27T19:02:52","slug":"creating-an-oracle-cdb-database-using-dbca-gui","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/03\/02\/creating-an-oracle-cdb-database-using-dbca-gui\/","title":{"rendered":"Creating an Oracle CDB database using DBCA GUI"},"content":{"rendered":"\n<p>Neste breve artigo vou explorar a instala\u00e7\u00e3o de um banco Oracle 18C na arquitetura multinent.<\/p>\n\n\n\n<p>Setando a vari\u00e1vel DISPLAY e invocando o DBCA:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 ~]$ export DISPLAY=192.168.0.105:0.0\n&#x5B;oracle@oel8 ~]$ dbca &amp;amp;\n&#x5B;1] 2609\n<\/pre><\/div>\n\n\n<p>Create Database:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-307.png\" alt=\"\" class=\"wp-image-8101\"\/><\/figure>\n\n\n\n<p>Advanced:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-308.png\" alt=\"\" class=\"wp-image-8102\"\/><\/figure>\n\n\n\n<p>Next:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-309.png\" alt=\"\" class=\"wp-image-8103\"\/><\/figure>\n\n\n\n<p>Nesse ponto, devemos selecionar a op\u00e7\u00e3o &#8220;Create as Container Database&#8221;, \u00e9 sugerido tamb\u00e9m a op\u00e7\u00e3o &#8220;Use Local Undo Tablespace for PDBs&#8221;. Como s\u00f3 vou criar o root container, n\u00e3o vou habilitar a op\u00e7\u00e3o de criar PDBS:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-310.png\" alt=\"\" class=\"wp-image-8104\"\/><\/figure>\n\n\n\n<p>Habilitando recurso de OMF:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-311.png\" alt=\"\" class=\"wp-image-8105\"\/><\/figure>\n\n\n\n<p>Definindo FRA e habilitando archiving:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-312.png\" alt=\"\" class=\"wp-image-8107\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-313.png\" alt=\"\" class=\"wp-image-8108\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-314.png\" alt=\"\" class=\"wp-image-8109\"\/><\/figure>\n\n\n\n<p>Criando listener:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-315.png\" alt=\"\" class=\"wp-image-8110\"\/><\/figure>\n\n\n\n<p>Next:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-316.png\" alt=\"\" class=\"wp-image-8111\"\/><\/figure>\n\n\n\n<p>Definindo tamanho da SGA e PGA:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-317.png\" alt=\"\" class=\"wp-image-8112\"\/><\/figure>\n\n\n\n<p>Aumentando o valor dos processos:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-318.png\" alt=\"\" class=\"wp-image-8113\"\/><\/figure>\n\n\n\n<p>Utilizando este character set (a partir da 12C R2) nos d\u00e1 a liberdade posterior de definir diferentes character sets para os PDBs:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-319.png\" alt=\"\" class=\"wp-image-8114\"\/><\/figure>\n\n\n\n<p>Next:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-320.png\" alt=\"\" class=\"wp-image-8115\"\/><\/figure>\n\n\n\n<p>Next:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-321.png\" alt=\"\" class=\"wp-image-8116\"\/><\/figure>\n\n\n\n<p>Definindo senha:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-322.png\" alt=\"\" class=\"wp-image-8117\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-323.png\" alt=\"\" class=\"wp-image-8118\"\/><\/figure>\n\n\n\n<p>Create database:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-324.png\" alt=\"\" class=\"wp-image-8119\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-325.png\" alt=\"\" class=\"wp-image-8120\"\/><\/figure>\n\n\n\n<p>Sum\u00e1rio:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-326.png\" alt=\"\" class=\"wp-image-8121\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-327.png\" alt=\"\" class=\"wp-image-8122\"\/><\/figure>\n\n\n\n<p>Criando:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-328.png\" alt=\"\" class=\"wp-image-8123\"\/><\/figure>\n\n\n\n<p>Nasce mais um monstro:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-329.png\" alt=\"\" class=\"wp-image-8124\"\/><\/figure>\n\n\n\n<p>Validando:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Tue Mar 2 06:51:14 2021\nVersion 18.3.0.0.0\n \nCopyright (c) 1982, 2018, Oracle.  All rights reserved.\n \n \nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.3.0.0.0\n \nSQL&gt; select instance_name,status from gv$instance;\n \nINSTANCE_NAME    STATUS\n---------------- ------------\nTALAMO           OPEN\n \nSQL&gt; select name,cdb from v$database;\n \nNAME      CDB\n--------- ---\nTALAMO    YES\n \nSQL&gt;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Neste breve artigo vou explorar a instala\u00e7\u00e3o de um banco Oracle 18C na arquitetura multinent. Setando a vari\u00e1vel DISPLAY e invocando o DBCA: Create Database: Advanced: Next: Nesse ponto, devemos selecionar a op\u00e7\u00e3o &#8220;Create as Container Database&#8221;, \u00e9 sugerido tamb\u00e9m a op\u00e7\u00e3o &#8220;Use Local Undo Tablespace for PDBs&#8221;. Como s\u00f3 vou criar o root container, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-2258","post","type-post","status-publish","format-standard","hentry","category-multitenant"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2258","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=2258"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2258\/revisions"}],"predecessor-version":[{"id":9250,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2258\/revisions\/9250"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2258"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}