Oracle RAC Installation Step 6 - Perform cluster database creation

$ cd /u01/app/oracle/product/10.2.0/db_1/bin

$ . /dbca

Database Configuration Assistant: Welcome
---------------------------------------------
check - Oracle Real Application Cluster database

--> Next

Step 1 of 15: Operations
-------------------------
Select the operation that you want to perform
check - Create a Database

Step 2 of 15: Node Selection
-----------------------------
Select the nodes for which you want to manage ASM diskgroups.
click Select All --on right hand side.

Step 3 of 15: Database Templates
-----------------------------------
check - General Purpose

Step 4 of 15: Database Identification
-------------------------------------
Global Database Name: RDBA --upto 30 char length , must begin with an Alphabet
SID Prefix : RDBA --System Identifier --used to generate unique SID names for the two
instances that make up the cluster database eg. RDBA1 and RDBA2

Step 5 of 15: Management Options
------------------------------------
Check - Configure the Database with Enterprise Manager

Click - Use Grid Control for Database Management -- if you have Grid Control installed somewhere on network
-- if you have to manage databases in large enterprise deployment.

Management Service https://node1.us.oracle.com:1159/em

Click - Use Database Control for Database Management
-- if you have to Enable Email Notifications when alerts occur -- Outgoing Mail (SMTP) Server and email
address required.
-- if you have to Enable Daily Backup --supply Backup start time and OS user credentials

Step 6 of 15: Database Credentials
-----------------------------------
You must supply passwords for the user accounts created by the DBCA when configuring your database.

Click - Use Same Password for All Accounts
OR
Click - Use Different Passwords

Step 7 of 15: Storage Options
------------------------------
Cluster File System
Automatic Storage Management (ASM) --Requires ASM Instance on any of the Cluster nodes
(can be created using dbca)
Raw Devices--provide fully qualified mapping file name or set DBCA_RAW_CONFIG environment variable to point it.

Step 8 of 15: ASM Disk Group
-------------------------------
Select one or more disk groups to be used as storage fo the database. You can also create new disk group to be used by your cluster database.
select check box corresponding to the disk.

Step 9 of 15: Database file locations
------------------------------------
Specify locations for the Database files to be created.

Click - Use Oracle-Managed Files
Database Area : +DATA -- group name in database area field.

Step 10 of 15: Recovery Configuration
---------------------------------------
Choose the recovery options for the database.
Check - Specify Flash Recovery Area
Flash Recovery Area: +FLASH --Req. for all backup and recovery opeartions, automatic backups using EM
Flash Recovery Area Size: 2048 MB
Check - Enable Archiving -if you need

Step 11 of 15: Database Content
--------------------------------------
Check - Sample Schemas --only if needed

Step 12 of 15: Database Services
---------------------------------
You can add database services to be configured during database creation.
TAF Policy -- Transparent Application Failover
None : Do not use TAF
Basic : Establish connections at failover time
Pre-connect : Establish one connection to a preferred instance and another connection to backup instance that you have selected to be available.

Step 13 of 15: Initialization Parameters
----------------------------------------
You can set important database parameters -- grouped under four tabs.

Memory -- shared pool, buffer cacahe, java pool, large pool ,PGA
Sizing -- database block size (default 8kb)
Character Sets -- default language, date format
Connection Mode-- dedicated or shared server mode

Step 14 of 15: Database Storage
--------------------------------
You can specify storage parameter for database creation
-- control files
-- tablespaces
-- datafiles
-- rollback segments
-- redo log groups
Size, location and all aspects of extent management are under your control here.
Note : If you select database template including datafiles, you will not be able to add or remove datafiles,
tablespaces, or rollback segments.But you can change the destination of datafiles, controlfiles or log groups.


Step 15 of 15: Creation Options
--------------------------------
Review all options, parameters and so on that have been chosen for your database creation.

By clicking the Password Management button, you can manage the database accounts created by the DBCA.