DBA Fundamentals

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

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.

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.

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.

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.

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.

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

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

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.