Pluggable Databases - Expert Consolidation in Oracle Database 12c - page 238

The typical options are the ones you see on the screen—they can help you to get started quickly. When opting
for the advanced options, you are guided through a few more wizard steps, which are explained in Table 7-1 .

Table 7-1. Wizard Steps and Options

Step Action to take for database creation

1) Database Operation Create a database

2) Creation Mode Typical or Advanced-select advanced

3) Database Template Select which template to use for the new database. This has primarily an effect on

the database initialization parameters. In the default database software installation
you get templates including data files and a custom option. The existence of data
files means that dbca will perform an RMAN restore of the data files associated with
the template whereas the custom option will create the database based on scripts
which takes longer. You can create your own database templates and use them for a
standard compliant database creation, possibly the best way to deploy databases at a
larger scale.

4) Database Identification Select a global database name and an Oracle SID. Please remember that the Oracle SID

has a maximum length on most platforms. You should also select “Create As Container
Database here”. You can either create the CDB empty or with a number of PDBs.

5) Management Options Specify if you want to register the new CDB with Enterprise Manager Cloud Control.

If you check that box then you need to have an agent already installed on the host.
Alternatively you can configure Enterprise Manager Express, or none of the above.
EM Express replaces the DB Console that existed between Oracle 10.1 and 11.2.

6) Database Credentials On this screen you enter the passwords for the SYS and SYSTEM accounts. They can

either be separate or identical, the separate option offering more security of course.

7) Network Configuration On this screen you define which listener the database should be registered with. If

you do not see a listener although it is started you should check if a listener.ora file
exists.
You can also create a new listener in this screen if you like.

8) Storage Location It is possible to use different storage options for database files and the Fast Recovery

Area. In most cases you'd keep to one storage option, either file system or ASM.
If you are using a file system location you have the further option to use Oracle
Managed Files. You can optionally multiplex redo logs and control files if you choose
to use OMF.
Finally you can decide to enable archivelog mode straight away.

9) Database Options In this screen you can configure Database Vault and Oracle Label Security. Both of

these are out of scope of the chapter.

10) Initialization Parameters You can set the memory parameters, block size, character sets and connection mode

on this part of the wizard. It has not changed from the 11.2 wizard page and is fairly
self-explanatory.

11) Creation Options Again a screen which has not changed from a previous release, here you can choose

to create the database and/or to create the database scripts. It is a good idea to create
the scripts as well to become more familiar with the database creation process in
Oracle 12c.

( continued )