Creating an Oracle Database

Posted: April 25, 2010 in Database
Tags: ,

What we want to learn here is creating a database using Database Configuration Assistant. I created this tutorial as simple as possible :]

A standard installation can be completed on a computer with 1 GB of RAM and 1.5 GB of swap space or larger. Depending on the activity level of the machine on which you are installing the Oracle database software, the standard installation can complete in 20 minutes or less.

Oh yeah… i’m using Oracle 10g and Windows XP for installation

Database Configuration Window

Operation

Choose “Create Database”

Database Templates

Different types of databases have their own specific instance and storage requirement. Characteristic of these examples are the following :

  • Data Warehouse : store data for long periods and retrieve them in read operation
  • Transaction Processing : Accomodate many, but usually small, transaction
  • General Purpose : Work with many transactions and store them for a medium length of time
  • Custom Database : For complex environment

Database Identification

Global Database Name : for network use

SID : Instance name of your database

in this case, my SID and my Global Database Name is “dbAzer”

Management Options

Grid Control : For Parallel Databases

Database Control : Email notification or daily backup

Database Credentials

You can use same password for all cccount, or use different password

Storage Options

File System : Using your OS Filesystem

ASM : Automatic storage, include its size

Raw Devices : Usually for mirroring/Cluster database

Database File Locations

Choose according your needs. Oracle Management Files (OMF) eliminate the need for you to directly manage the operating system files comprising an Oracle Database. You specify operations in terms of database objects rather than file names.

Recovery Configuration

If required, specify a flash recovery area and enable archiving

Database Content – Sample Schemas

Database Content – Custom Scripts

Automatically run custom scripts after the database created

Initialization Parameters – Memory

Use this page to set the initialization parameters that control memory usage

Initialization Parameters – Sizing

To specify block size, enter the size in bytes or accept the default

Initialization Parameters – Character Sets

Initialization Parameters – Connection Mode

Database Storage

Create Option

You have opinions of creating your database at this time, saving the database ans a template, and generating scripts.

Confirmation Window

Installing…

Database Creation Finished

Check your new Database in Start Menu

Ensure all services started

Check your database status using command prompt

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Student>set oracle_sid=dbAzer
C:\Documents and Settings\Student>emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://Dba122:5501/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory C:\oracle\product\10.2.0\db_1/Dba122_dbAzer/sysm
an/log
C:\Documents and Settings\Student>

Finish !!!

Note : Some parts of this article were taken from Oracle Workforce Development Program, Oracle Database 10g: Administration Workshop I

Comments
  1. kiki says:

    like dis :D/
    *padahal g ngerti*

  2. Wonderful screen shots have been provided for understanding creation of Oracle database. Thanks buddy. Great job.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s