Creating Oracle Database

Creating the Oracle Database

Scenario/Summary |

|

Although Oracle provides a very nice graphical interface tool called Enterprise Manager to aid the DBA in working with the database, it is not always the tool of choice. Many DBAs find it preferable to use command-line execution of scripts and procedures to do administrative work. One such case is in the creation of a new database within the management system.

Although the creation of a new database requires the editing of several support files for the database (the listener.ora and tnsnames.ora files in particular), the CREATE DATABASE script is the essential file that would need to be run to accomplish this process. In this lab, you will be responsible for writing a CREATE DATABASE script that would create a new database named LABII, based on a specific set of requirements that will be listed later. The basic configuration for the server the database instance will use is:

Disk Drives: There are three disk drives you will be using: – C:\ - E:\ - F:\

OFA directory paths: The OFA path for each drive that you will use to place the described files in is:

\ORACLE\ORADATA\ORACLE

VERY IMPORTANT – DO NOT ATTEMPT TO RUN YOUR SCRIPT FILE OR TEST IT! Doing so could cause unforeseen problems and that is not the objective of the lab. You will be furnished with a solution later that you can compare your example against.

| L A B   S T E P S | |

Create an SQL database | |

You are being asked to create the CREATE DATABASE script for a new database instance. The name of the new database should be LABII. Create a script file using Notepad that would create this database:

* The following parameters need to be defined and settings assigned: 

* Maxlogfiles to allow up to 5 groups

* Maxlogmembers to allow up to 4

* Maxdatafiles to allow up to 100

* Maxinstances to allow only 2

* A system datafile should be based on the following guidelines:

* Named SYSTEM01.DBF...