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