{"id":2246,"date":"2018-09-13T20:08:49","date_gmt":"2018-09-14T01:08:49","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=2246"},"modified":"2026-02-07T15:05:27","modified_gmt":"2026-02-07T21:05:27","slug":"create-oracle-database-18c-on-windows-advanced-configuration-for-the-pros","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2018\/2246\/","title":{"rendered":"Create Oracle Database 18c on Windows &#8211; Advanced Configuration for the pros"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p>Oracle Database 18c (18.3) is\u00a0available for download\u00a0for windows platform since August 22, 2018. If you are new to Oracle or if you are a developer and need a database to play with, you can install an Oracle 18c database quickly on your laptop with a few clicks. Read &#8220;<a href=\"https:\/\/bijoos.com\/oraclenotes\/2018\/2234\/\">Oracle18c Database on your Windows laptop in 6 clicks!<\/a>&#8220;. If you installed the Oracle Database 18c software, and want to create a new database swiftly, read &#8220;<a href=\"https:\/\/bijoos.com\/oraclenotes\/2018\/2248\/\">Create Oracle Database 18c in 3 clicks!<\/a>&#8220;<\/p>\n\n\n\n<p>If you are setting up a production system or a database for <g class=\"gr_ gr_32 gr-alert sel gr_gramm gr_replaced gr_inline_cards gr_disable_anim_appear Grammar only-del replaceWithoutSep\" id=\"32\" data-gr-id=\"32\"><\/g>enterprise applications, you will need to go through the advanced configuration. The best option is to choose &#8220;Set Up Software Only&#8221; in Oracle Universal Installer (OUI) to complete the Oracle software installation, then use Database Configuration Assistant (DBCA) to create a new database.<\/p>\n\n\n\n<p>OUI and DBCA have the advanced configuration. The OUI advanced configuration is not &#8220;advanced&#8221; enough, DBCA lets you customize the database configuration options even more &#8211; good for an experienced DBA. In my opinion, Oracle should remove the &#8220;Advanced Configuration&#8221; option from OUI, thus make DBAs to force use DBCA. Let&#8217;s see the &#8220;Advanced&#8221; options difference when using the OUI to create the database vs using DBCA to create the database.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Installation Type (OUI &amp; DBCA)<\/h4>\n\n\n\n<div class=\"wp-block-columns has-2-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-12.png?ssl=1\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-12.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2257\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-12.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-12.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>OUI: Choose Advanced Install<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-13.png?ssl=1\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-13.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2258\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-13.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-13.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA: Choose Advanced Configuration<\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Database Edition &amp; Software Owner (OUI only)<\/h4>\n\n\n\n<p>These screens are part of the Oracle Software install.\u00a0<\/p>\n\n\n\n<div class=\"wp-block-columns has-2-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-14.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-14.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2259\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-14.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-14.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>Choose if you want to install Oracle Enterprise Edition or Standard Edition 2<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-15.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-15.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2260\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-15.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-15.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>Choose the Windows user who will own the Oracle binaries software installation <\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Choosing Database Type<\/h4>\n\n\n\n<div class=\"wp-block-columns has-2-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i2.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-16.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i2.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-16.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2261\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-16.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-16.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>OUI gives only two options &#8211; both options include the data files from the template.\u00a0 <br\/>No custom database option. <\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-17.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-17.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2262\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-17.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-17.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA has more options. In addition to the two options with templates, you can create a custom database. Also, there is option to choose Single instance, or RAC or RAC one node.\u00a0<\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Database Identification<\/h4>\n\n\n\n<div class=\"wp-block-columns has-2-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-18.png?ssl=1\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-18.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2263\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-18.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-18.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>OUI options are limited. Only 1 pluggable database creation and a CDB must have one PDB. Local undo tablespace for PDB is the default.<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-19.png?ssl=1\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-19.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2264\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-19.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-19.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>In DBCA you can specify the number of PDBs required in CDB. If more than one, the PDB name becomes PDB prefix. You can also create CDB with no PDBs. Option to choose local undo tablespace or not for PDB.\u00a0<\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Database Storage<\/h4>\n\n\n\n<div class=\"wp-block-columns has-2-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-22.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-22.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2269\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-22.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-22.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>OUI lets you choose file system or ASM for storage.<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-21.png?ssl=1\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-21.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2268\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-21.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-21.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA has more options &#8211; use of OMF, redo and control file multiplexing.\u00a0<\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns has-2-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i2.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-32.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i2.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-32.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2280\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-32.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-32.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>OUI gives option to enable recovery, which includes configuring the fast recovery area location.<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-23.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-23.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2270\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-23.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-23.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA gives option to configure Fast Recovery Area including its size, and Archive log mode.\u00a0<\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Configuration Options<\/h4>\n\n\n\n<p>OUI has enough configuration options, but DBCA has a lot more.\u00a0<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Memory:\u00a0<ul><li>OUI: Automatic memory management and for shared memory management, you only specify the total memory, OUI allocates the PGA and SGA.\u00a0<\/li><li>DBCA: Automatic memory management, <g class=\"gr_ gr_59 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace\" id=\"59\" data-gr-id=\"59\">Automatic<\/g> shared memory management, and Manual shared memory management options.<\/li><\/ul><\/li><li>Sizing:<ul><li>OUI: No option to change block size (8k) or the number of processes.<\/li><li>DBCA: Option to change block size if the template used is &#8220;Custom Database&#8221;. Specify processes.<\/li><\/ul><\/li><li>Character Sets:<ul><li>OUI: Option to choose database character set.<\/li><li>DBCA: In addition to database character set, choose national character set, language, and territory.<\/li><\/ul><\/li><li>Connection mode:<ul><li>OUI: No option to change &#8211; dedicated server mode.\u00a0<\/li><li>DBCA: Option to configure a dedicated server or shared server mode.\u00a0<\/li><\/ul><\/li><li>Sample Schema:<ul><li>OUI and DBCA give the option to install the sample schema.<\/li><\/ul><\/li><\/ul>\n\n\n\n<p><strong>MEMORY:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-columns has-2-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-29.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-29.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2276\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-29.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-29.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>OUI: Automatic memory management and shared memory management <\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-24.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-24.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2271\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-24.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-24.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA: Automatic memory management,\u00a0Automatic<br\/>\u00a0shared memory management, and Manual shared memory management options. <\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p><strong>CHARACTER SETS:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-columns has-2-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i2.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-30.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i2.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-30.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2277\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-30.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-30.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>OUI: Option to choose database character set. <\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-26.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-26.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2273\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-26.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-26.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA: In addition to database character set, choose national character set, language, and territory. <\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p><strong>SIZING &amp; CONNECTION MODE (DBCA ONLY):<\/strong><br\/><\/p>\n\n\n\n<div class=\"wp-block-columns has-2-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-27.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-27.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2274\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-27.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-27.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA: Option to change block size if the template used is &#8220;Custom Database&#8221;. <\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i2.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-28.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i2.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-28.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2275\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-28.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-28.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA: Option to configure a dedicated server or shared server mode.\u00a0 <\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Management Options<\/h4>\n\n\n\n<div class=\"wp-block-columns has-2-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-31.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-31.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2279\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-31.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-31.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>OUI: Option to configure OEM Cloud Control. Database Express is automatically configured on port 5500.<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i2.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-39.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i2.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-39.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2288\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-39.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-39.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA: In addition to OEM Cloud Control configuration, option to specify port for Database Express.\u00a0<\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Schema Passwords<\/h4>\n\n\n\n<div class=\"wp-block-columns has-2-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i2.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-33.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i2.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-33.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2281\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-33.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-33.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>OUI and DBCA: Option to specify one password for admin accounts or different passwords. PDBADMIN is applicable only when PDBs are created.\u00a0<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-35.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-35.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2283\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-35.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-35.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>OUI and DBCA: Option to specify one password for admin accounts or different passwords. PDBADMIN is applicable only when PDBs are created.\u00a0 <\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Database Creation Option &#8211; DBCA Only<\/h4>\n\n\n\n<div class=\"wp-block-columns has-2-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-36.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-36.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2284\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-36.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-36.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA has option to save the DB create script, create a DB template and customize storage locations, as well as change initialization parameters. No such options in OUI.<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-37.png?fit=624%2C469\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"469\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-37.png?fit=624%2C469\" alt=\"\" class=\"wp-image-2285\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-37.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-37.png?resize=300%2C225&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>The Customize Storage option in DBCA gives flexibility to specify storage parameters.\u00a0<\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns has-2-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-41.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-41.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2293\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-41.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-41.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA gives option to configure a new listener or to register the database with an existing listener. OUI always creates a new listener and configures port 1521.\u00a0<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-42.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-42.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2294\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-42.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-42.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA gives option to configure Oracle Database Vault and Oracle Label Security. No such option in OUI.<\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Summary<\/h4>\n\n\n\n<div class=\"wp-block-columns has-2-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-40.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i1.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-40.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2291\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-40.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-40.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>OUI: Summary shows only Global Setting and Database Configuration.<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i2.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-38.png?fit=624%2C471\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i2.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-38.png?fit=624%2C471\" alt=\"\" class=\"wp-image-2286\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-38.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-38.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA: Summary shows much more.<\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p>If you plan on creating a database using a GUI tool for enterprise applications, always use DBCA. DBCA gives more flexibility and options. If you are installing the software and want a database with basic default options, use the OUI starter database option, desktop class.\u00a0\u00a0<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">DBCA Database Creation Screens<\/h3>\n\n\n\n<p>All the screens that belong to DBCA are in the gallery below. You can also see the options included with the OLTP and DW templates &#8211; both are very much similar, one difference is the parameter star_transformation_enabled=TRUE in DW template. Both DW and OLTP include the pre-created data files, so the database creation would be much faster. The custom template builds the database from scratch, thus takes longer.\u00a0<\/p>\n\n\n\n<ul class=\"wp-block-gallery columns-4 is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\"><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-8.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-8.png?resize=624%2C471&#038;ssl=1\" alt=\"\" data-id=\"2250\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/2018\/2248\/image-9\/\" class=\"wp-image-2250\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-8.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-8.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 1: Select Database Operation<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-13.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-13.png?resize=624%2C471&#038;ssl=1\" alt=\"\" data-id=\"2258\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2258\" class=\"wp-image-2258\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-13.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-13.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 2: Select Database Creation Mode<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-17.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-17.png?resize=624%2C471&#038;ssl=1\" alt=\"\" data-id=\"2262\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2262\" class=\"wp-image-2262\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-17.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-17.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 3: Select Database Deployment Type<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-43.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"615\" height=\"864\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-43.png?resize=615%2C864&#038;ssl=1\" alt=\"\" data-id=\"2295\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2295\" class=\"wp-image-2295\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-43.png?w=615&amp;ssl=1 615w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-43.png?resize=214%2C300&amp;ssl=1 214w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/a><figcaption>DBCA 3a: Data Warehouse Template Options<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-44.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"854\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-44.png?resize=624%2C854&#038;ssl=1\" alt=\"\" data-id=\"2296\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2296\" class=\"wp-image-2296\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-44.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-44.png?resize=219%2C300&amp;ssl=1 219w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 3b: General Purpose or Transaction Processing Template Options<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-46.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"584\" height=\"864\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-46.png?resize=584%2C864&#038;ssl=1\" alt=\"\" data-id=\"2298\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2298\" class=\"wp-image-2298\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-46.png?w=584&amp;ssl=1 584w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-46.png?resize=203%2C300&amp;ssl=1 203w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><\/a><figcaption>DBCA 3c: Custom Database Creation Template options<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-19.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-19.png?resize=624%2C471&#038;ssl=1\" alt=\"\" data-id=\"2264\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2264\" class=\"wp-image-2264\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-19.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-19.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 4: Specify Database Identification Details<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-21.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-21.png?resize=624%2C471&#038;ssl=1\" alt=\"\" data-id=\"2268\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2268\" class=\"wp-image-2268\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-21.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-21.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 5: Select Database Storage Option<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-23.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-23.png?resize=624%2C471&#038;ssl=1\" alt=\"\" data-id=\"2270\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2270\" class=\"wp-image-2270\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-23.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-23.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 6: Select Fast Recovery Option<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-41.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-41.png?resize=624%2C471&#038;ssl=1\" alt=\"\" data-id=\"2293\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2293\" class=\"wp-image-2293\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-41.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-41.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 7: Specify Network Configuration Details<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-45.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"512\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-45.png?resize=624%2C512&#038;ssl=1\" alt=\"\" data-id=\"2297\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2297\" class=\"wp-image-2297\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-45.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-45.png?resize=300%2C246&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 8: Select Database Options &#8211; Only available if Custom Database Creation template is chosen in Screen 3.<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-42.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-42.png?resize=624%2C471&#038;ssl=1\" alt=\"\" data-id=\"2294\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2294\" class=\"wp-image-2294\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-42.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-42.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 8: Select Oracle Data Vault Config Option<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-24.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-24.png?resize=624%2C471&#038;ssl=1\" alt=\"\" data-id=\"2271\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2271\" class=\"wp-image-2271\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-24.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-24.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 9a: Specify Configuration Options &#8211; Memory<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-27.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-27.png?resize=624%2C471&#038;ssl=1\" alt=\"\" data-id=\"2274\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2274\" class=\"wp-image-2274\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-27.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-27.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 9b: Specify Configuration Options &#8211; Sizing<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-26.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-26.png?resize=624%2C471&#038;ssl=1\" alt=\"\" data-id=\"2273\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2273\" class=\"wp-image-2273\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-26.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-26.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 9c: Specify Configuration Options &#8211; Character Sets<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-28.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-28.png?resize=624%2C471&#038;ssl=1\" alt=\"\" data-id=\"2275\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2275\" class=\"wp-image-2275\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-28.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-28.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 9d: Specify Configuration Options &#8211; Connection Mode<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-39.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-39.png?resize=624%2C471&#038;ssl=1\" alt=\"\" data-id=\"2288\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2288\" class=\"wp-image-2288\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-39.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-39.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 10: Specify Management Options<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-35.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-35.png?resize=624%2C471&#038;ssl=1\" alt=\"\" data-id=\"2283\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2283\" class=\"wp-image-2283\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-35.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-35.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 11: Specify Database User Credentials<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-36.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-36.png?resize=624%2C471&#038;ssl=1\" alt=\"\" data-id=\"2284\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2284\" class=\"wp-image-2284\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-36.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-36.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 12: Select Database Creation Option<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-38.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"471\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-38.png?resize=624%2C471&#038;ssl=1\" alt=\"\" data-id=\"2286\" data-link=\"https:\/\/bijoos.com\/oraclenotes\/?attachment_id=2286\" class=\"wp-image-2286\" srcset=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-38.png?w=624&amp;ssl=1 624w, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/image-38.png?resize=300%2C226&amp;ssl=1 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><figcaption>DBCA 13: Summary<\/figcaption><\/figure><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>If you are setting up a production system or similar, you will need to go through the advanced configuration. The best option is to choose &#8220;Set Up Software Only&#8221; in Oracle Universal Installer (OUI) to complete the Oracle software installation, then use Database Configuration Assistant (DBCA) to create a new database.<\/p>\n<p>OUI and DBCA have the advanced configuration. The OUI advanced configuration is not &#8220;advanced&#8221; enough, DBCA lets you customize the database configuration options &#8211; good for an experienced DBA. In my opinion, Oracle should remove the &#8220;Advanced Configuration&#8221; option from OUI, thus make DBAs to force use DBCA. Let&#8217;s see the &#8220;Advanced&#8221; options difference when using the OUI to create the database vs using DBCA to create the database.<\/p>\n","protected":false},"author":1,"featured_media":2243,"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":[133],"tags":[78,79],"class_list":["post-2246","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracledb","tag-dbca","tag-oui"],"acf":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/09\/Oracle18cdb.jpg?fit=280%2C280&ssl=1","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2246","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=2246"}],"version-history":[{"count":5,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2246\/revisions"}],"predecessor-version":[{"id":2302,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2246\/revisions\/2302"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media\/2243"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=2246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=2246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=2246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}