{"id":2474,"date":"2021-03-08T08:26:30","date_gmt":"2021-03-08T08:26:30","guid":{"rendered":"https:\/\/swiv.com.br\/creating-an-oracle-database-from-the-seed-using-dbca\/"},"modified":"2026-05-27T20:02:51","modified_gmt":"2026-05-27T19:02:51","slug":"creating-an-oracle-database-from-the-seed-using-dbca","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/03\/08\/creating-an-oracle-database-from-the-seed-using-dbca\/","title":{"rendered":"Creating an Oracle Database from the seed using DBCA"},"content":{"rendered":"\n<p>Exportando o DISPLAY e abrindo 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.103:0.0\n&#x5B;oracle@oel8 ~]$ dbca &amp;amp;\n&#x5B;1] 3568\n<\/pre><\/div>\n\n\n<p>Manage Puggable databases:<\/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-275.png\" alt=\"\" class=\"wp-image-8058\"\/><\/figure>\n\n\n\n<p>Create:<\/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-276.png\" alt=\"\" class=\"wp-image-8059\"\/><\/figure>\n\n\n\n<p>Escolhendo o CDB que abrigar\u00e1 o PDB e informando credenciais:<\/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-277.png\" alt=\"\" class=\"wp-image-8060\"\/><\/figure>\n\n\n\n<p>Escolhendo o SEED:<\/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-278.png\" alt=\"\" class=\"wp-image-8061\"\/><\/figure>\n\n\n\n<p>Definindo nome do PDB e seu usu\u00e1rio de adminitra\u00e7\u00e3o:<\/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-279.png\" alt=\"\" class=\"wp-image-8062\"\/><\/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-280.png\" alt=\"\" class=\"wp-image-8063\"\/><\/figure>\n\n\n\n<p>Manter op\u00e7\u00e3o de cria\u00e7\u00e3o de uma tablespace padr\u00e3o:<\/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-281.png\" alt=\"\" class=\"wp-image-8064\"\/><\/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-282.png\" alt=\"\" class=\"wp-image-8065\"\/><\/figure>\n\n\n\n<p>Progresso:<\/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-283.png\" alt=\"\" class=\"wp-image-8067\"\/><\/figure>\n\n\n\n<p>Sucesso:<\/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-284.png\" alt=\"\" class=\"wp-image-8068\"\/><\/figure>\n\n\n\n<p>Validando ambiente. Como o PDB foi criado via DBCA, o mesmo est\u00e1 aberto (diferente se fosse com SQL *Plus, onde deveria ser aberto manualmente):<\/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 Mon Mar 8 05:07:23 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; col name format a10\nSQL&gt; SELECT NAME, CON_ID, OPEN_MODE, GUID FROM V$PDBS ORDER BY 1;\n \nNAME           CON_ID OPEN_MODE  GUID\n---------- ---------- ---------- --------------------------------\nHIPOFISE1           3 MOUNTED    BCF7B920CA5C126AE0536B00A8C0B4F1\nHIPOFISE2           4 READ WRITE BD02D62DBD0C163FE0536B00A8C0EF43\nPDB$SEED            2 READ ONLY  BC8B772AA6A82204E0536B00A8C0CF6B\n \nSQL&gt;\n<\/pre><\/div>\n\n\n<p>Checando se o novo PDB foi registrado no listener:<\/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 ~]$ ps -ef | grep lsnr\noracle    1841     1  0 04:44 ?        00:00:00 \/oracle\/18.0.0\/product\/bin\/tnslsnr LISTENER -inherit\noracle    9421  3024  0 05:13 pts\/0    00:00:00 grep --color=auto lsnr\n&#x5B;oracle@oel8 ~]$ lsnrctl service\n \nLSNRCTL for Linux: Version 18.0.0.0.0 - Production on 08-MAR-2021 05:14:02\n \nCopyright (c) 1991, 2018, Oracle.  All rights reserved.\n \nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel8.localdomain)(PORT=1521)))\nServices Summary...\nService &quot;TALAMO.localdomain&quot; has 1 instance(s).\n  Instance &quot;TALAMO&quot;, status READY, has 1 handler(s) for this service...\n    Handler(s):\n      &quot;DEDICATED&quot; established:0 refused:0 state:ready\n         LOCAL SERVER\nService &quot;TALAMOXDB.localdomain&quot; has 1 instance(s).\n  Instance &quot;TALAMO&quot;, status READY, has 1 handler(s) for this service...\n    Handler(s):\n      &quot;D000&quot; established:0 refused:0 current:0 max:1022 state:ready\n         DISPATCHER &amp;lt;machine: oel8.localdomain, pid: 2597&gt;\n         (ADDRESS=(PROTOCOL=tcp)(HOST=oel8.localdomain)(PORT=18101))\nService &quot;bcf7b920ca5c126ae0536b00a8c0b4f1.localdomain&quot; has 1 instance(s).\n  Instance &quot;TALAMO&quot;, status READY, has 1 handler(s) for this service...\n    Handler(s):\n      &quot;DEDICATED&quot; established:0 refused:0 state:ready\n         LOCAL SERVER\nService &quot;bd02d62dbd0c163fe0536b00a8c0ef43.localdomain&quot; has 1 instance(s).\n  Instance &quot;TALAMO&quot;, status READY, has 1 handler(s) for this service...\n    Handler(s):\n      &quot;DEDICATED&quot; established:0 refused:0 state:ready\n         LOCAL SERVER\nService &quot;hipofise1.localdomain&quot; has 1 instance(s).\n  Instance &quot;TALAMO&quot;, status READY, has 1 handler(s) for this service...\n    Handler(s):\n      &quot;DEDICATED&quot; established:0 refused:0 state:ready\n         LOCAL SERVER\nService &quot;hipofise2.localdomain&quot; has 1 instance(s).\n  Instance &quot;TALAMO&quot;, status READY, has 1 handler(s) for this service...\n    Handler(s):\n      &quot;DEDICATED&quot; established:0 refused:0 state:ready\n         LOCAL SERVER\nThe command completed successfully\n&#x5B;oracle@oel8 ~]$\n<\/pre><\/div>\n\n\n<p>Realizando a configura\u00e7\u00e3o no Net Service Name usando a ferramenta gr\u00e1fica NETCA:<\/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 admin]$ netca &amp;amp;\n&#x5B;1] 10065\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-285.png\" alt=\"\" class=\"wp-image-8069\"\/><\/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-286.png\" alt=\"\" class=\"wp-image-8070\"\/><\/figure>\n\n\n\n<p>Definindo o service name:<\/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-287.png\" alt=\"\" class=\"wp-image-8071\"\/><\/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-288.png\" alt=\"\" class=\"wp-image-8072\"\/><\/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-289.png\" alt=\"\" class=\"wp-image-8073\"\/><\/figure>\n\n\n\n<p>Fazendo teste:<\/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-290.png\" alt=\"\" class=\"wp-image-8074\"\/><\/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-291.png\" alt=\"\" class=\"wp-image-8075\"\/><\/figure>\n\n\n\n<p>Sucesso:<\/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-292.png\" alt=\"\" class=\"wp-image-8076\"\/><\/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-293.png\" alt=\"\" class=\"wp-image-8078\"\/><\/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-294.png\" alt=\"\" class=\"wp-image-8079\"\/><\/figure>\n\n\n\n<p>Finalizado:<\/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-295.png\" alt=\"\" class=\"wp-image-8080\"\/><\/figure>\n\n\n\n<p>Podemos perceber que uma nova string de conex\u00e3o foi adicionada ao tnsnames.ora:<\/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 admin]$ cat tnsnames.ora\n# tnsnames.ora Network Configuration File: \/oracle\/18.0.0\/product\/network\/admin\/tnsnames.ora\n# Generated by Oracle configuration tools.\n \nCORTEX =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = oel7.localdomain)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = cortex.localdomain)\n    )\n  )\n \nTALAMO =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = oel8.localdomain)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = TALAMO.localdomain)\n    )\n  )\n \nHIPOFISE2 =\n  (DESCRIPTION =\n    (ADDRESS_LIST =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = oel8)(PORT = 1521))\n    )\n    (CONNECT_DATA =\n      (SERVICE_NAME = hipofise2.localdomain)\n    )\n  )\n \nHIPOFISE1 =\n  (DESCRIPTION =\n    (ADDRESS_LIST =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = oel8.localdomain)(PORT = 1521))\n    )\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = HIPOFISE1.localdomain)\n    )\n  )\n \nLISTENER_TALAMO =\n  (ADDRESS = (PROTOCOL = TCP)(HOST = oel8.localdomain)(PORT = 1521))\n \n \n&#x5B;oracle@oel8 admin]$\n<\/pre><\/div>\n\n\n<p>Validando conex\u00e3o:<\/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 admin]$ sqlplus system\/oracle@HIPOFISE2\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Mon Mar 8 05:23:40 2021\nVersion 18.3.0.0.0\n \nCopyright (c) 1982, 2018, Oracle.  All rights reserved.\n \nLast Successful login time: Mon Mar 08 2021 05:20:19 -03:00\n \nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.3.0.0.0\n \nSQL&gt;\n<\/pre><\/div>\n\n\n<p>Obs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laborat\u00f3rio pessoal para fins de aprendizado.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Exportando o DISPLAY e abrindo o DBCA: Manage Puggable databases: Create: Escolhendo o CDB que abrigar\u00e1 o PDB e informando credenciais: Escolhendo o SEED: Definindo nome do PDB e seu usu\u00e1rio de adminitra\u00e7\u00e3o: Manter op\u00e7\u00e3o de cria\u00e7\u00e3o de uma tablespace padr\u00e3o: Sum\u00e1rio: Progresso: Sucesso: Validando ambiente. Como o PDB foi criado via DBCA, o mesmo [&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-2474","post","type-post","status-publish","format-standard","hentry","category-multitenant"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2474","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=2474"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2474\/revisions"}],"predecessor-version":[{"id":9244,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2474\/revisions\/9244"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2474"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2474"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}