All language subtitles for [SubtitleTools.com] Running NETCA And DBCA - Learning Oracle 12c [Video]

In this lesson, we're
going to take a look

at a couple of
tools that will be

used during the course of
an Oracle database creation.

They really are a part of
the installation process,

but they come between
an installation

of the software and the
actual database creation.

So they are part of the
installation process.

The first that we'll look at
is NetCA, which is the Network

Configuration Assistant.

So NetCA Is?

Going to provide the
network framework

for our Oracle database.

So that's going to
include something called

a listener, which is
a process that listens

for incoming connections.

Then we'll take an
introductory look

at DBCA, which is the Database
Configuration Assistant.

That is the primary tool that
we'll use to build a database.

So what I'm going to do
is open a command prompt

here and type netca, which opens
the Oracle Net Configuration

Assistant.

So the Net
Configuration Assistant

can actually allow us to do
several different things.

We're going to talk about
listener configuration.

That's the primary thing that
we want to do in this lesson.

We can also change
our naming methods--

so how Oracle will resolve
various database names--

our local net service
name configuration

to configure network services,
and our directory usage

configuration, which would allow
us to use things like an LDAP--

a Lightweight Directory
Access Protocol server.

We, however, want to look
at listener configuration.

And there's actually a
reason that we're doing this

before the database creation.

In the process of the
database creation,

we want to install
some components that

will allow us to use
Oracle Enterprise Manager.

And in order for those to
function and install properly,

the listener already has to
be set up and configured.

So we select Listener
Configuration, click Next.

We have options to Add,
Reconfigure, Delete, or Rename.

We don't have any listener
on here at this point,

so we're only given
the option to Add.

If we did have a listener
running on this server,

we could do things like
changing its configuration,

deleting it, or renaming it.

So we click Next.

Here we can choose our
name for our listener.

The default is LISTENER, and
that is most commonly used.

You could suffix
the listener name

with the machine name,
a port number, something

of that nature.

If you wish.

Click Next.

Next we have to
select the protocols

we want Oracle to use.

Typically, we use the Transfer
Control Protocol, which is TCP.

We do have other protocols
available as well.

Click Next.

Now we have to select the port
number that we wish to use.

The standard port for an Oracle
database listens on port 1521.

We can click here and choose
a different port number

if we wish.

We will leave 1521
as our standard.

This is a subject of
some controversy today--

at least as it
pertains to security.

Because the standard port 1521
is so known and associated

with the Oracle database,
some security experts

consider this an open
invitation to an attack.

But they do have to breach it.

Just knowing the
port is not enough.

So you can generally feel
safe using port 1521.

If you work in an environment
that has other concerns,

then you may be required to
use a different port number.

Click Next.

And it's pretty
well-configured at this point.

Do we want to configure
another listener?

We say-- leave No selected.

Click Next.

And the configuration
is complete.

We see a little bit of output,
here, from our command prompt.

And we click Next.

Takes us back to
the original screen.

We can click Cancel here.

All right, the Database
Configuration Assistant--

so to launch that, we type dbca.

Now, the DBCA is
Oracle's standardized way

of creating a database.

So it's going to step us
through all of the options

that we need, give us
a lot of different ways

that we can create the database.

We can do automatic
types of creation

where we just
accept the defaults,

and then we can do more
hands-on, manual type

of database creations as well.