All language subtitles for [SubtitleTools.com] Stepping Through Database Creation - Part 3 - 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 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.

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