Hands-On 22 (Creating a new database)

As a DBA, you are responsible for creating a new database. It is very healthy and normal that an organization has three different databases for one single application, such as testing, development, and production environments. Your job’s responsibilities dictate that you should at least be informed of the following basic fundamental subjects:

Using the Oracle Database Configuration Assistant

Creating a new database

Specifying the database and system identifier name

Changing the SGA memory allocation

Changing the database mode to the ARCHIVELOG mode

Starting automatic archival

Changing the archive log format

Changing the database block size

Changing the sort area size

Changing the database character set

Change the location of the Parameters and trace file

Changing user passwords

Hands-On 22 (Creating a new database)

Description:

In this exercise you will learn how to create a new database using the 
Oracle Database Configuration Assistant.

--Start

The Oracle Database Configuration Assistant enables you to create a
database, configure database, delete a database, and manage database
templates.

Now, to create a new database click NEXT.

==
Select the "Create a Database" option and click NEXT.

==
Select the "New Database" template and click NEXT.

==
Specify the database and system identifier name and click NEXT.

==
De-select the features that you do not want.

==
Reply "YES" to delete the tablespace associated with this database option.

==
Reply "YES" again to delete the tablespace.

==
Click on the "Additional Database Configurations" button and de-select 
the options.

==
Reply "YES" again to delete the tablespace.

==
Then, click NEXT to continue.

==
Choose the Dedicate Server Mode and click NEXT.

==
Use the default SGA memory allocation.

== 
On the Archive tab, change the database mode to the archivelog mode, 
start the automatic archival, and change the archive log format.

==
On the DB Sizing tab, change the database block size, sort area size,
and the database character set.

==
On the file location, change the location of the Parameters and trace file
if it's needed, and click NEXT.

==
In the Database Storage window, expand the "Tablespaces", "Datafiles,"
and "Redo Log Groups" items. This shows where the datafiles are located.

Notice that there are no rollback segments at this time. Click NEXT.
==
On the "Creation Options" window, select the database creation options 
with generating the database scripts and click FINISH.

==
verify the database configuration by checking:
"COMMON OPTIONS,"
"INITIALIZATION PARAMETERS,"
"CONTROL FILES,"
"TABLESPACES,"
"DATA FILES,"
"ROLLBACK SEGMENTS," and 
"REDO LOG GROUPS."

Close the window.

==
The database creation script was completed.

==
Now, the creation of the database is started.

The duration of the database installation depends on the database
components that were selected at the time of the installation and the speed
of the server.

Please wait.
=========================================

second movie
=========================================
The database creation was successfully completed.

Verify the database information, such as the "Global Database Name,"
"System Identifier," "SYS Password," and "SYSTEM password."

Click on the "Change Password" button to change the database password.

==
Change the SYS password to a new password and click Okay.

==
Notice that the SYS password was changed. Then click "EXIT" and 
Good Luck!