iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.

DBAs - Fundamentals

 

Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 | Lesson 17 | Lesson 18 | Lesson 19 | Lesson 20 | Lesson 21 | Lesson 22 | Lesson 23 | Lesson 24 | Lesson 25 | Lesson 26 |

 

Lesson 26

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

 

Password Change

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.