All language subtitles for [SubtitleTools.com] Stepping Through Database Creation - Part 3 - Learning Oracle 12c [Video]

In this lesson, we continue
our database creation

through the use of the DBCA,
or Database Configuration

Assistant.

We've selected
all of our options

for initialization
parameters and click Next.

So now we have our
options for how

we want to create the database.

Certainly, if we're going
to create a database,

we want to leave the
Create Database selected.

We could save it as a
template and call it

whatever name we wish,
give it a description,

and we can also click this box.

This is going to generate
database creation scripts.

So when we create
a database, there's

a number of ways to do it.

We can use the DBCA,
but we don't have to.

It can also be done
entirely scripted.

And so, as we step
through this installation,

here in the last
step, we can just

allow Oracle to generate
those creation scripts.

So we'll do that, so we
can take a look at them.

The customized
storage location is

going to give us the storage
locations for various table

spaces, so this is the
system table space.

We notice that the file name
is OMF_SYSTEM_DATAFILE_1.

It has a size of 700 megs.

And the reason it says
OMF here is because we've

selected Oracle Managed
Files for Oracle

to control the sizing and
location of our data files.

Here, we have the
individual files themselves.

If for any reason we want
to change their sizes,

we can do so here.

And we have redo logs as well.

So we'll have three
redo log groups.

Click close, then click Next.

So it does the
prerequisite checks,

and it didn't find any problems.

Notice that we have kind
of the history of the steps

that we've gone through,
and now we're on 13 of 14.

And the only one that it flagged
us on was database credentials,

and again, that's because I
put in a password that didn't

meet their security standards.

We can see a summary here of
all the choices that we've made,

parameters, character sets,
table spaces, and data files,

so on and so forth.

And now we'll click Finish.

It created the template,
and it generated the scripts

in this location.

And now it goes
through the process

of building the database.

And this can take
several minutes.

While this is running,
we could say a few things

about the steps that
it's going through.

The first is to create and
start the Oracle instance.

So that's going to
allocate the memory

necessary for the database,
configure all the parameters

that are involved, really take
all the choices that we've

made in the DBCA and use them.

Then it's going to create
the files themselves on disk.

Then it's going to build
the data dictionary views.

When Oracle creates the
data dictionary views,

it's building all of those
base tables and views

that Oracle uses to maintain
the data dictionary,

so the data dictionary
pulls all of the information

about the database.

And we will use this frequently
as a database administrator

because it's the kind of
sum total of knowledge

about the database.

So the actual creation
of the database

can take quite a while,
even up to 20 or 30 minutes,

depending on the
speed of your disk.

So now the steps have completed.

And it gives us the information
about what we've just created.

So this is a good screen to
maybe screenshot and save.

It gives you
information about where

the Database Express
for Enterprise Manager

is, the name of the
database, some things that

are kind of important to keep.

At this point, we can also
do some password management.

But for our purposes, we'll
just click Exit and close.

Now the final thing that
we wanted to look at

was the scripts that were
generated at the last step

of the Oracle installation.

So we instructed the DBCA
to create a database,

but we also said that we
wanted the scripts generated.

So let's take a look at those.

So those were in
the Admin Directory

inside the Oracle
based directory, so

Oracle Base, Admin, ORCL--

the name of our database--

and then the scripts directory.

All of these scripts are steps
that the DBCA goes through.

The DBCA is just a GUI front
end to create these scripts

and run them basically.

So we can also go through
them and make alterations

if we wish.

If we want to, we can just
generate the scripts themselves

and do our own creation.

In fact, we could create
the ORCL database simply

by clicking the orcl.bat.

But, for our purposes, I'm
going to right click on

it and edit it.

And this gives you some example
of the command line commands

that will be used during
the database creation.

So there is mkdir commands that
make all of these directories.

There are these steps
with this oradim.exe.

And those are steps that you'll
see in a Windows database

creation that you'll not ever
see in a Unix or Linux database

creation because these
create the necessary Windows

services to run Oracle.

And then the last step is simply
to start the SQL*Plus tool

and run the next
script in the list,

which is orcl.sql right here.

The orcl.sql sets a
couple of variables.

And then each one
of these is just

another script that
it runs, so a script

to create the database,
create the database files,

to create the database
catalog, so on and so forth,

down to the last step.