"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) |
Read
first then play the video:
DBA022(VIDEO)-Creating
a new database
Creating a New database
Introduction
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
Database Configuration
Assistant
The Oracle Database
Configuration Assistant enables you to create a database, configure
database, delete a database, and manage database templates.
Welcome Screen
In the Welcome Oracle Database Configuration Assistant, click
Next.
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
Processing.
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
transactions.
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
information
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
their tablespaces.
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.
Database Connection
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.
Initialization Parameter
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.
Database Storage
In the Database Storage
window, you can change the location of your datafiles and then click
OK.
Database creation
In the Creation Options
window, once you create your database, you can create a template for
later use and click Finish.
Summary configuration
In the Summary window,
browse through your configurations and datafiles location. Then click
OK.
Acknowledgement
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
users.
Now, we should have our
database created.
|