"The object of
war is not to die for your country but to make the other bastard
die for his." - General George Patton (1885-1945)
first then play the video:
a new database
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
Creating a new database
Specifying the database and
system identifier name
Changing the SGA memory
Changing the database mode
to the ARCHIVELOG mode
Starting automatic archival
Changing the archive log
Changing the database block
Changing the sort area size
Changing the database
Change the location of the
Parameters and trace file
Changing user passwords
The Oracle Database
Configuration Assistant enables you to create a database, configure
database, delete a database, and manage database templates.
In the Welcome Oracle Database Configuration Assistant, click
Select the Operation
On its first step, you
should select the operation you want to perform. These operations are:
Create a database, Configure Database, Delete Database, and Manage
Template. Since we are going to create a database, select create
option to create a new database.
Select a Template
In the template screen,
select a template from the list to create a database. Your template
can be: Data Warehouse, General Purpose, New Database, and Transaction
Use the Transaction
Processing template, if your database will be used for only online
transaction process such as data entry.
Use the Data Warehouse
template, if your database will be used for big and long batch
Use the General Purpose, if
your database will be used for online and big batch transactions.
Use the New Database
option, if you want to use your own configuration and the same time
create the template. For this hands-on, checkmark the New Database
option and then click OK.
Define the database
In the screen to define the
database information, in the ‘Global Database Name’ box, type
dbs4man. Remember that an Oracle database can be uniquely identified
by Global Database Name. In the ‘SID’ box, type dbs4man. Remember
that a database will be referenced by at least one Oracle instance
which is uniquely identified from any other instance on the server.
Then click OK.
Define Database Feature
In the Database Feature,
you can leave all the feature on or deselect them by un-checkmark
them. Some example of these features are Oracle Spatial, Oracle Ultra
Search, Oracle Label Security, Oracle OLAP services, Example Schemas,
etc. Note that when you deselect a database option, you may get a
message in regards to that there is a tablespace associated with this
database option. Do you also want to delete that tablespace? Say ‘Yes.’
For this hands-on, de-select them all and response ‘Yes’ to delete
In the database Feature
tab, click on the ‘Additional database configuration’ push button
and deselect the Oracle JVM, Oracle Intermedia features and click OK.
And when you are back to your Database Feature tab, click Next.
In the connection window,
select the mode in which you want your database to operate by default.
It can be either Dedicate Server mode or Shared Server Mode. Use
dedicate server mode, if the number of total client connecting to your
server is expected to be small otherwise use the Share Server Mode.
Then click OK.
In the Initialization
Parameter window, open the Memory tab, to change memory size; open the
Archive tab to change the archive mode; open the DB Sizing tab to
change the database Block sizes such as 4k, 8k, and 16k; and click on
the file Location tab to change your database file location. For this
hands-on use the default parameters except change your database mode
to run in an archive log mode. And then click Next.
In the Database Storage
window, you can change the location of your datafiles and then click
In the Creation Options
window, once you create your database, you can create a template for
later use and click Finish.
In the Summary window,
browse through your configurations and datafiles location. Then click
Depends on your selection
option, windows may prompt to acknowledge the generation of the
script. Click yes to confirm it.
In the Password Change
window, make sure to change the password of the SYSTEM and SYS Oracle
Now, we should have our