Afrikaans
Akan
Albanian
Amharic
Armenian
Azerbaijani
Basque
Belarusian
Bemba
Bengali
Bihari
Bosnian
Breton
Bulgarian
Cambodian
Catalan
Cebuano
Cherokee
Chichewa
Chinese (Simplified)
Chinese (Traditional)
Corsican
Croatian
Czech
Danish
Dutch
English
Esperanto
Estonian
Ewe
Faroese
Filipino
Finnish
French
Frisian
Ga
Galician
Georgian
German
Greek
Guarani
Gujarati
Haitian Creole
Hausa
Hawaiian
Hebrew
Hindi
Hmong
Hungarian
Icelandic
Igbo
Indonesian
Interlingua
Irish
Italian
Japanese
Javanese
Kannada
Kazakh
Kinyarwanda
Kirundi
Kongo
Korean
Krio (Sierra Leone)
Kurdish
Kurdish (Soranรฎ)
Kyrgyz
Laothian
Latin
Latvian
Lingala
Lithuanian
Lozi
Luganda
Luo
Luxembourgish
Macedonian
Malagasy
Malay
Malayalam
Maltese
Maori
Marathi
Mauritian Creole
Moldavian
Mongolian
Myanmar (Burmese)
Montenegrin
Nepali
Nigerian Pidgin
Northern Sotho
Norwegian
Norwegian (Nynorsk)
Occitan
Oriya
Oromo
Pashto
Persian
Polish
Portuguese (Brazil)
Portuguese (Portugal)
Punjabi
Quechua
Romanian
Romansh
Runyakitara
Russian
Samoan
Scots Gaelic
Serbian
Serbo-Croatian
Sesotho
Setswana
Seychellois Creole
Shona
Sindhi
Sinhalese
Slovak
Slovenian
Somali
Spanish
Spanish (Latin American)
Sundanese
Swahili
Swedish
Tajik
Tamil
Tatar
Telugu
Thai
Tigrinya
Tonga
Tshiluba
Tumbuka
Turkish
Turkmen
Twi
Uighur
Ukrainian
Urdu
Uzbek
Vietnamese
Welsh
Wolof
Xhosa
Yiddish
Yoruba
Zulu
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.
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.