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

af Afrikaans
ak Akan
sq Albanian
am Amharic
hy Armenian
az Azerbaijani
eu Basque
be Belarusian
bem Bemba
bn Bengali
bh Bihari
bs Bosnian
br Breton
bg Bulgarian
km Cambodian
ca Catalan
ceb Cebuano
chr Cherokee
ny Chichewa
zh-CN Chinese (Simplified)
zh-TW Chinese (Traditional)
co Corsican
hr Croatian
cs Czech
da Danish
nl Dutch
en English
eo Esperanto
et Estonian
ee Ewe
fo Faroese
tl Filipino
fi Finnish
fr French
fy Frisian
gaa Ga
gl Galician
ka Georgian
de German
el Greek
gn Guarani
gu Gujarati
ht Haitian Creole
ha Hausa
haw Hawaiian
iw Hebrew
hi Hindi
hmn Hmong
hu Hungarian
is Icelandic
ig Igbo
id Indonesian
ia Interlingua
ga Irish
it Italian
ja Japanese
jw Javanese
kn Kannada
kk Kazakh
rw Kinyarwanda
rn Kirundi
kg Kongo
ko Korean
kri Krio (Sierra Leone)
ku Kurdish
ckb Kurdish (Soranรฎ)
ky Kyrgyz
lo Laothian
la Latin
lv Latvian
ln Lingala
lt Lithuanian
loz Lozi
lg Luganda
ach Luo
lb Luxembourgish
mk Macedonian
mg Malagasy
ms Malay
ml Malayalam
mt Maltese
mi Maori
mr Marathi
mfe Mauritian Creole
mo Moldavian
mn Mongolian
my Myanmar (Burmese)
sr-ME Montenegrin
ne Nepali
pcm Nigerian Pidgin
nso Northern Sotho
no Norwegian
nn Norwegian (Nynorsk)
oc Occitan
or Oriya
om Oromo
ps Pashto
fa Persian
pl Polish
pt-BR Portuguese (Brazil)
pt Portuguese (Portugal)
pa Punjabi
qu Quechua
ro Romanian
rm Romansh
nyn Runyakitara
ru Russian
sm Samoan
gd Scots Gaelic
sr Serbian
sh Serbo-Croatian
st Sesotho
tn Setswana
crs Seychellois Creole
sn Shona
sd Sindhi
si Sinhalese
sk Slovak
sl Slovenian
so Somali
es Spanish
es-419 Spanish (Latin American)
su Sundanese
sw Swahili
sv Swedish
tg Tajik
ta Tamil
tt Tatar
te Telugu
th Thai
ti Tigrinya
to Tonga
lua Tshiluba
tum Tumbuka
tr Turkish
tk Turkmen
tw Twi
ug Uighur
uk Ukrainian
ur Urdu
uz Uzbek
vi Vietnamese
cy Welsh
wo Wolof
xh Xhosa
yi Yiddish
yo Yoruba
zu Zulu

Original subtitles

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.

Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.