{"id":4856,"date":"2020-12-14T18:27:33","date_gmt":"2020-12-14T21:27:33","guid":{"rendered":"https:\/\/www.dbarj.com.br\/?p=4856"},"modified":"2020-12-14T18:39:39","modified_gmt":"2020-12-14T21:39:39","slug":"how-to-create-your-21c-oracle-database","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2020\/12\/how-to-create-your-21c-oracle-database\/","title":{"rendered":"How to create your 21c Oracle Database"},"content":{"rendered":"<p>In the previous article, I showed how you can build a <strong>Gold Image<\/strong> of your <strong>Oracle Database 21c in DBaaS<\/strong> to play and study the new features in your own VMs (<a href=\"https:\/\/www.dbarj.com.br\/en\/2020\/12\/playing-with-new-oracle-database-21c-in-your-virtualbox\/\" target=\"_blank\" rel=\"noopener noreferrer\">Playing with new Oracle Database 21c in your VirtualBox<\/a>).<\/p>\n<p>Now that you have successfully deployed the binaries, the next step is to create a database.<\/p>\n<p>Generally speaking, you would have <strong>3 options<\/strong> to go..<\/p>\n<ol>\n<li><strong>Create a RMAN backup on DBaaS and restore it on your VM.<\/strong><\/li>\n<li><strong>Create the Database using catalog \/ catproc approach.<\/strong><\/li>\n<li><strong>Create with DBCA.<\/strong><\/li>\n<\/ol>\n<p>Option 3 is the easiest one and would be my first choice. However, as you may have seen in the previous article, the DBaaS Gold Image does not contain the <span style=\"text-decoration: underline;\">General Purpose<\/span> templates. Only a single one named &#8220;<em>seed_db.dbc<\/em>&#8221; which is bases on ASM and cannot be used in this lab scenario.<\/p>\n<p>So, we are only left with option 1 or 2. I will go with option 2 as I want a brand new and clean one.<\/p>\n<p>The overall steps are:<\/p>\n<ol>\n<li>Create the parameter file.<\/li>\n<li>Create the database using CREATE DATABASE syntax.<\/li>\n<li>Run catalog &amp; catproc on CDB e PDBS.<\/li>\n<\/ol>\n<h4>Create the SPFILE<\/h4>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">cat &gt; initdb21c.ora &lt;&lt;'EOF'\r\ndb_name='db21c'\r\nmemory_target=2G\r\nprocesses = 150\r\ndb_block_size=8192\r\ndb_domain=''\r\ndb_create_file_dest='\/u01\/app\/oracle\/oradata'\r\ndb_create_online_log_dest_1='\/u01\/app\/oracle\/oradata'\r\ndb_recovery_file_dest='\/u01\/app\/oracle\/fra'\r\ndb_recovery_file_dest_size=2G\r\ndiagnostic_dest='\/u01\/app\/oracle'\r\ndispatchers='(PROTOCOL=TCP) (SERVICE=db21cXDB)'\r\nopen_cursors=300 \r\nremote_login_passwordfile='EXCLUSIVE'\r\nundo_tablespace='UNDOTBS1'\r\ncontrol_files = '\/u01\/app\/oracle\/oradata\/control01.ctl'\r\nenable_pluggable_database=TRUE\r\nencrypt_new_tablespaces=DDL\r\nwallet_root='\/u01\/app\/oracle\/wallet'\r\ntde_configuration=\"KEYSTORE_CONFIGURATION=FILE\"\r\nEOF<\/pre>\n<h4>Prepare the Instance<\/h4>\n<p>First create the folders for oradata, fra and DB wallet:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[oracle@lab21c ~]$ mkdir \/u01\/app\/oracle\/{oradata,fra,wallet}\r\n[oracle@lab21c ~]$ mkdir \/u01\/app\/oracle\/wallet\/tde<\/pre>\n<p>Now start the DB in nomount:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@lab21c dbs]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 21.0.0.0.0 - Production on Mon Dec 14 12:15:00 2020\r\nVersion 21.1.0.0.0\r\n\r\nCopyright (c) 1982, 2020, Oracle.  All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL&gt; create spfile from pfile;\r\n\r\nFile created.\r\n\r\nSQL&gt; startup nomount;\r\nORACLE instance started.\r\n\r\nTotal System Global Area 2147480016 bytes\r\nFixed Size                  9687504 bytes\r\nVariable Size            1207959552 bytes\r\nDatabase Buffers          922746880 bytes\r\nRedo Buffers                7086080 bytes\r\nSQL&gt;<\/pre>\n<h4>Create your Wallet<\/h4>\n<p>It&#8217;s usually recommended to have the Oracle Wallet properly configured before creating the database<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; administer key management create keystore '\/u01\/app\/oracle\/wallet\/tde' identified by welcome1;\r\n\r\nkeystore altered.\r\n\r\nSQL&gt; set lines 1000 pages 1000\r\nSQL&gt; col WRL_PARAMETER for a30\r\nSQL&gt; select WRL_TYPE, WRL_PARAMETER, STATUS, CON_ID from v$encryption_wallet;\r\n\r\nWRL_TYPE             WRL_PARAMETER                  STATUS                             CON_ID\r\n-------------------- ------------------------------ ------------------------------ ----------\r\nFILE                 \/u01\/app\/oracle\/wallet\/tde\/    CLOSED                                  1\r\n\r\nSQL&gt; administer key management create auto_login keystore from keystore '\/u01\/app\/oracle\/wallet\/tde' identified by welcome1;\r\n\r\nkeystore altered.\r\n\r\nSQL&gt; select WRL_TYPE, WRL_PARAMETER, STATUS, CON_ID from v$encryption_wallet;\r\n\r\nWRL_TYPE             WRL_PARAMETER                  STATUS                             CON_ID\r\n-------------------- ------------------------------ ------------------------------ ----------\r\nFILE                 \/u01\/app\/oracle\/wallet\/tde\/    OPEN_NO_MASTER_KEY                      1\r\n<\/pre>\n<h4>Create the Database<\/h4>\n<p>I will run the following command to create my 21c database control file:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">CREATE DATABASE db21c\r\n USER SYS IDENTIFIED BY Oracle11__\r\n USER SYSTEM IDENTIFIED BY Oracle11__\r\n LOGFILE\r\n  GROUP 1 SIZE 100M BLOCKSIZE 512,\r\n  GROUP 2 SIZE 100M BLOCKSIZE 512,\r\n  GROUP 3 SIZE 100M BLOCKSIZE 512\r\n MAXLOGHISTORY 1\r\n MAXLOGFILES 16\r\n MAXLOGMEMBERS 3\r\n MAXDATAFILES 1024\r\n CHARACTER SET AL32UTF8\r\n NATIONAL CHARACTER SET AL16UTF16\r\n EXTENT MANAGEMENT LOCAL\r\n DATAFILE SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED\r\n SYSAUX DATAFILE SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED\r\n DEFAULT TABLESPACE users DATAFILE SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED\r\n DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED\r\n UNDO TABLESPACE undotbs1 DATAFILE SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED\r\n USER_DATA TABLESPACE usertbs DATAFILE SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED\r\n ENABLE PLUGGABLE DATABASE\r\n SEED\r\n  SYSTEM DATAFILES SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED\r\n  SYSAUX DATAFILES SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED\r\n;<\/pre>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; @create_database.sql\r\n\r\nDatabase created.\r\n\r\nSQL&gt;<\/pre>\n<h4>Create the Catalog<\/h4>\n<p>Finally, I will create and setup my catalog.<\/p>\n<p>First start the DB in upgrade mode:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; startup upgrade;\r\nORACLE instance started.\r\n\r\nTotal System Global Area 2147480016 bytes\r\nFixed Size                  9687504 bytes\r\nVariable Size            1207959552 bytes\r\nDatabase Buffers          922746880 bytes\r\nRedo Buffers                7086080 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\nSQL&gt; show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       MIGRATE    YES\r\nSQL&gt;<\/pre>\n<p>Now call the catctl:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[oracle@lab21c ~]$ mkdir \/home\/oracle\/log\r\n[oracle@lab21c ~]$ $ORACLE_HOME\/perl\/bin\/perl $ORACLE_HOME\/rdbms\/admin\/catctl.pl \\\r\n-d $ORACLE_HOME\/rdbms\/admin \\\r\n-n 2 \\\r\n-c 'CDB$ROOT PDB$SEED' \\\r\n-l \/home\/oracle\/log \\\r\ncatpcat.sql\r\n<\/pre>\n<p>And after some time:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">Argument list for [\/u01\/app\/oracle\/product\/21.0.0.0\/dbhome_1\/rdbms\/admin\/catctl.pl]\r\nFor Oracle internal use only A = 0\r\nRun in                       c = CDB$ROOT PDB$SEED\r\nDo not run in                C = 0\r\nInput Directory              d = \/u01\/app\/oracle\/product\/21.0.0.0\/dbhome_1\/rdbms\/admin\r\nEcho OFF                     e = 1\r\nSimulate                     E = 0\r\nForced cleanup               F = 0\r\nLog Id                       i = 0\r\nChild Process                I = 0\r\nLog Dir                      l = \/home\/oracle\/log\r\nPriority List Name           L = 0\r\nUpgrade Mode active          M = 0\r\nSQL Process Count            n = 2\r\nSQL PDB Process Count        N = 0\r\nOpen Mode Normal             o = 0\r\nStart Phase                  p = 0\r\nEnd Phase                    P = 0\r\nReverse Order                r = 0\r\nAutoUpgrade Resume           R = 0\r\nScript                       s = 0\r\nSerial Run                   S = 0\r\nClassic Upgrade              t = 0\r\nRO User Tablespaces          T = 0\r\nUpgrade PDBs in Upgrade mode x = 0\r\nDisplay Phases               y = 0\r\nDebug catcon.pm              z = 0\r\nDebug catctl.pl              Z = 0\r\n\r\ncatctl.pl VERSION: [21.0.0.0.0]\r\n           STATUS: [Production]\r\n            BUILD: [RDBMS_21.0.0.0.0_LINUX.X64_201030]\r\n\r\n\r\n...\r\n...\r\n...\r\n\r\nGrand Total Time: 1527s [PDB$SEED]\r\n\r\n     Time: 1397s For CDB$ROOT\r\n     Time: 1534s For PDB(s)\r\n\r\nGrand Total Time: 2931s\r\n<\/pre>\n<p>Now that the process is completed. Restart the database to remove the upgrade mode and recompile any invalid objects:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">SQL&gt; show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       MIGRATE    YES\r\nSQL&gt; shut immediate;\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\nSQL&gt; startup;\r\nORACLE instance started.\r\n\r\nTotal System Global Area 2147480016 bytes\r\nFixed Size                  9687504 bytes\r\nVariable Size            1291845632 bytes\r\nDatabase Buffers          838860800 bytes\r\nRedo Buffers                7086080 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\nSQL&gt; show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       READ ONLY  NO\r\nSQL&gt; select count(*) from cdb_objects where status='INVALID';\r\n\r\n  COUNT(*)\r\n----------\r\n         0\r\n<\/pre>\n<p>Finally, you can create your first PDB from Seed:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; CREATE PLUGGABLE DATABASE pdb01 ADMIN USER pdb_adm IDENTIFIED BY Password1;\r\n\r\nPluggable database created.\r\n\r\nSQL&gt; show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       READ ONLY  NO\r\n         3 PDB01                          MOUNTED\r\nSQL&gt; alter pluggable database all open;\r\n\r\nPluggable database altered.\r\n\r\nSQL&gt; show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       READ ONLY  NO\r\n         3 PDB01                          READ WRITE NO\r\nSQL&gt;<\/pre>\n<p>That&#8217;s it. Now you can create your labs and play with the new 21c features.<\/p>\n<b>Have you enjoyed? Please leave a comment or give a \ud83d\udc4d!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-4856 jlk' href='javascript:void(0)' data-task='like' data-post_id='4856' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-4856 lc'>+11<\/span><\/a><\/div><\/div> <div class='status-4856 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>In the previous article, I showed how you can build a Gold Image of your Oracle Database 21c in DBaaS to play and study the new features in your own VMs (Playing with new Oracle Database 21c in your VirtualBox). Now that you have successfully deployed the binaries, the next step is to create a &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2020\/12\/how-to-create-your-21c-oracle-database\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-4856","post","type-post","status-publish","format-standard","hentry","category-database-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to create your 21c Oracle Database - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"In this article, I will show how to create your first Oracle Database 21c to check and study its new features.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbarj.com.br\/en\/2020\/12\/how-to-create-your-21c-oracle-database\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2020\\\/12\\\/how-to-create-your-21c-oracle-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2020\\\/12\\\/how-to-create-your-21c-oracle-database\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"How to create your 21c Oracle Database\",\"datePublished\":\"2020-12-14T21:27:33+00:00\",\"dateModified\":\"2020-12-14T21:39:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2020\\\/12\\\/how-to-create-your-21c-oracle-database\\\/\"},\"wordCount\":321,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"Oracle Database General\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2020\\\/12\\\/how-to-create-your-21c-oracle-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2020\\\/12\\\/how-to-create-your-21c-oracle-database\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2020\\\/12\\\/how-to-create-your-21c-oracle-database\\\/\",\"name\":\"How to create your 21c Oracle Database - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"datePublished\":\"2020-12-14T21:27:33+00:00\",\"dateModified\":\"2020-12-14T21:39:39+00:00\",\"description\":\"In this article, I will show how to create your first Oracle Database 21c to check and study its new features.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2020\\\/12\\\/how-to-create-your-21c-oracle-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2020\\\/12\\\/how-to-create-your-21c-oracle-database\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2020\\\/12\\\/how-to-create-your-21c-oracle-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to create your 21c Oracle Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to create your 21c Oracle Database - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"In this article, I will show how to create your first Oracle Database 21c to check and study its new features.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbarj.com.br\/en\/2020\/12\/how-to-create-your-21c-oracle-database\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2020\/12\/how-to-create-your-21c-oracle-database\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2020\/12\/how-to-create-your-21c-oracle-database\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"How to create your 21c Oracle Database","datePublished":"2020-12-14T21:27:33+00:00","dateModified":"2020-12-14T21:39:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2020\/12\/how-to-create-your-21c-oracle-database\/"},"wordCount":321,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["Oracle Database General"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2020\/12\/how-to-create-your-21c-oracle-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2020\/12\/how-to-create-your-21c-oracle-database\/","url":"https:\/\/www.dbarj.com.br\/en\/2020\/12\/how-to-create-your-21c-oracle-database\/","name":"How to create your 21c Oracle Database - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"datePublished":"2020-12-14T21:27:33+00:00","dateModified":"2020-12-14T21:39:39+00:00","description":"In this article, I will show how to create your first Oracle Database 21c to check and study its new features.","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2020\/12\/how-to-create-your-21c-oracle-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2020\/12\/how-to-create-your-21c-oracle-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2020\/12\/how-to-create-your-21c-oracle-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"How to create your 21c Oracle Database"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/4856","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=4856"}],"version-history":[{"count":5,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/4856\/revisions"}],"predecessor-version":[{"id":4875,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/4856\/revisions\/4875"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=4856"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=4856"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=4856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}