Create Database Instances

Introduction:

Having installed the database engine software and designed the database infrastructure, it is time to create the instances.

Aim:

Two instances will be created (this is why):

• sta: The Staging instance contains all staging schemas and components.
• whs: The Warehouse instance contains the Data Warehouse target schema.

Requirements:

Oracle is installed.

Procedure:

This procedure should be run twice, once for sta, and once for whs.

• Log in as oracle.
• Open Terminal.
• Open an xterm window:
• $ xterm &
• In the xterm window, run the DataBase Configuration Assistant:
• dbca &
• Welcome:
• [Next]
• Operations:
• Create a Database
• [Next]
  
• Database Templates:
• For sta:
• General Purpose
• For whs:
• Data Warehouse
  
• [Next]
• Database Identification:
• For sta:
  
• GlobalDatabase Name: sta
• SID: sta
• For whs:
• GlobalDatabase Name: whs
• SID: whs
• [Next]
• Management Options:
• Configure the Database with Enterprise Manager
• Use Database Control for Database Management
• Enable Email Notifications
• Outgoing Mail (SMPT)Server: lisa.steveroach.org (the fully qualified local host name)
• Email Address: Whatever you like - an email that you regularly monitor.
  
• Enable Daily Backup
• Pick whatever time you like - preferably one when you are asleep.
• OS Username: oracle
• Password: oracle's password
• [Next]
• Database Credentials:
• Use the Same Password for All Accounts
• Password: try this.
• Confirm Password: *********
• [Next]
  
• Storage Options:
• File System
• [Next]
• Database File Locations:
• Use Database File Locations from Template
• [Next]
• Recovery Configuration:
• Specify Flash Recovery Area
• Leave othe fields as is.
• [Next]
• Database Content:
• For sta:
• Sample Schemas
• For whs:
• Sample Schemas
• [Next]
• Initialisation Parameters:
• Leave everything as is.
• [Next]
• Database Storage:
• Leave everything as is.
• [Next]
• Creation Options:
• Create Database
• [Finish]
• Confirmation:
• [OK]
• Wait while instance is built.
  
• Configuration Assistant:
• This bit is important. A URLs is listed. Note this down. Mine is listed on my Server Specification.
• [Exit]

If you've just done this for sta, go back to the top and do it again for whs.