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 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.