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

In this lesson, we're going to
actually build our database.

I already have the software
installation complete.

In this case,
that's a requirement

before you can
build the database.

And we're going to
start the DBCA--

Database Configuration
Assistant--

and step through this process.

So there is a lot
here because we're

going to actually do the most
manual customized version

of the install that we possibly
can for learning purposes.

So we'll take these
steps one at a time

and we'll look at
each aspect as we go.

So to invoke or start the
DBCA from a command line,

I simply type DBCA.

And this starts the Database
Configuration Assistant,

which is Oracle's Java-based
wizard to create a database.

There are many ways
to create a database.

We could also do it manually.

It can be done entirely
through scripting

and that is the choice of many
senior DBAs, is if you will--

do it hands on with
a scripting method.

But the Database
Configuration Assistant

has evolved a lot over time
to a really useful tool.

And so, when you need to
do a single installation

of a database, then this can
often be the tool of choice.

So the first
question we have here

is what do we
actually want to do?

So this looks at the
installation of Oracle

that's already on here and
comes up with the options--

highlights them, grays
out other options--

based on what it already
sees on the machine.

So it gives us the option of
creating a database or managing

templates.

When we manage templates,
we're really managing a file

that Oracle stores--

or, really the
installer stores--

that can have
templates of databases.

So we could create a database,
save it as a template,

and then use it later.

If we had an existing
database on here already,

we could configure the
options for it or delete it.

With the features of 12c and
the Multitenant Architecture,

we can also manage our pluggable
databases from this point.

But for our purposes, we
want to create the database.

So we click Next.

Now, notice here that
we're at step two of five.

So we're really moving along
quickly, we're almost half

done.

Right?

Well, not necessarily.

If we want to do the quickest,
most straightforward creation

of a database that
accepts the defaults,

we can do it that way.

And we basically fill out all
the information in the top

and click Next.

And it will pretty well
do the prerequisite checks

and then create the database.

But for our purposes, we
want to click Advanced Mode.

Now, notice that goes from
step two of five to two of 13.

So there's a lot of steps
involved here in an Advanced

Mode installation.

But that's the one
where we're going

to get the greatest
amount of control

and learn the most about
what's actually happening.

So Advanced Mode and click Next.

So we were talking
about templates

and this is where
templates are listed.

It has a couple here by
default, so we've not

created any templates.

It has the general purpose
or transaction processing

database, a custom database,
or a data warehouse.

So you can use these
at your discretion.

We can also learn a
little more about them

by selecting and
clicking Show Details.

So these are the components
that would be installed

during a transaction processing
or general purpose database;

these are initialization
parameters

that control the configuration
of the database; character

sets; data files
and their location,

and so on and so forth.

So you can learn more
about these templates

by clicking Show Details.

For our purposes, we want
to click Custom Database

because we want to step
through the process of doing it

in a custom fashion.

Click Next.

Now, we need to give
our database a name.

So we have the
global database name,

which is the way it
appears on a network,

and then what's called the
SID, or System Identifier.

And the SID is the
database name as it

pertains to the database
itself internally.

In this case,
we're going to take

these standard name for a test
Oracle database, if you will,

which is orcl.

Notice that the SID fills
in the bottom, as well.

This is the step where
we also have the option

to create this as a
container database,

using the Multitenant
Architecture.

And then we can specify
the number of PDBs,

plugin databases, their
name, so on and so forth.

But for our purposes, we'll
stick with the standard Oracle

Database and click Next.

Now, at this point we have
our Enterprise Manager option.

Enterprise Manager is going to
be Oracle's tool for managing

an Oracle Database, at
least from the database

administration perspective.

And we have a couple
of options here.

We can choose not to use
Enterprise Manager at all;

we can select Configure
Enterprise Manager Database

Express, which is
going to be kind

of a light version of
Enterprise Manager;

or we could do both and register
this with Enterprise Manager

Cloud Control.

And this would
require an environment

where a Cloud Control server,
so an Oracle Enterprise Manager

12c management server,
has already been setup.

We'd put in the host name, the
port, and an admin user name

and password.

And when we create the
database, it would automatically

register with Cloud Control.

In our case, we don't have any
of this set up for our purposes

so we'll deselect
that but we'll leave

Configure Enterprise Manager
Database Express selected.

Click Next.

Now we have credentials.

So we need to give passwords
to the administrative users

that Oracle includes.

So those are SIS and SYSTEM,
the highest administrative users

in an Oracle database.

We can give our passwords
here, then give confirmation.

Going to click down
here where it says

Use The Same
Administrative Password.

Now, we're doing this
for simplicity's sake.

This is certainly
not recommended

in a true database
that's going to be

used by a company, particularly
a production database.

We're going to
type in a password

here, confirm the
password, and it

says the password
does not conform

to Oracle recommended standards,
and then gives those standards.

It's your choice how complex
the password that you

want to type in but, at this
point, do keep track of it

because we will use these
passwords throughout the rest

of this installation.