The Lazy DBA's Way to Create Real Application Cluster (RAC) Database using DBCA

Database creation is day to day task for a Database Administrator and DBCA is easiest way to create a Database but when talk about Create Real Application Cluster (RAC) Database then complications automatically comes into mind. So to make Database Creation easy We used to Create Real Application Cluster (RAC) Database using DBCA. DBA can use same tool to create RAC or Non RAC database for which he has to choose appropriate option only.

Oracle recommends that you use the DBCA to create your RAC database because the DBCA's pre configured databases optimize your environment for features such as ASM, the server parameter file, and automatic undo management. The DBCA also provides pages to create new ASM disk groups if they are needed and configures recovery and backup disk space if you are using ASM or cluster file system storage.

Create Real Application Cluster (RAC) Database using DBCA

In this Post I will create a RAC database using DBCA by considering following as prerequisite.

1. Real Application Cluster is up and running on Oracle Version.
2. We will use ASM instance for database storage and ASM disks are already created.
3. Oracle S/W version is also Oracle
4. Database Server is a Linux Server.

1. Launch DBCA and Choose Database Operation: Launch DBCA by executing dbca command on unix prompt. If DBCA is not executing, Set appropriate Environment variables.

[oracle@database ~]$ dbca

In the above screen shot Oracle Real Application Cluster (RAC) Database is default chosen. So no input required from DBA side. Just click "Next". In this Next Database Administrator has to choose, which operation he wants to do. 

Since we are going to create a database which is default as well. So just click on "Next".

2. Choose Type of Database: Here, DBA has to choose which type of database he wants to create. There are not so much differences. I am going with default option "General Purpose or Transaction purpose".

Click on "Next" after choosing the database type.

3. Choose Instances for Database: This is important step in creating RAC database using DBCA. Here, DBA has to choose database nodes on which database instances will be created. There are two configuration types Default is "Admin-Managed" which means DBA has to chose nodes on which database instance will start and second is "Policy-Managed" which means pool of servers policy. I am moving forward with default option Admin-Managed.

Here, I have chosen all nodes for creating database. Now, Click "Next"

4. Grid Control Configuration: This step give you detail about configuring database with grid control.

Let it be with default option and move forward by clicking "Next".

5. Password for Sys and System user: Provide password for sys, system and DBSNMP user. Make sure you follow Oracle password policy otherwise you will see warning, though you can move forward by bypassing that warning.

Click "Next" button.

6. Choose Database File Location: Since we are using ASM for database file storage so storage type should be "Automatic Storage Management (ASM)" (default). Next option to choose is storage location. Choose "Use Oracle Managed Files", Oracle-managed files eliminate the need for DBA, to directly manage the operating system files that make up an Oracle Database. With Oracle-managed files, you specify file system directories in which the database automatically creates, names, and manages files at the database object level.

For example, you need only specify that you want to create a tablespace; you do not need to specify the name and path of the tablespace's datafile with the DATAFILE clause.

Here, I have chosen "+DATA" as storage location, which is an ASM disk group.

Click on "Mulitplex Redo logs and Control Files" and provide location for multiplexing of redo and control file.

Multiplexing of redo or control file is an optional command.

7. Provide Recovery Configuration: Database administrator has to provide Database recovery path details in this step. Choose ASM disk using browse in which you want backup and archivelog files. DBA can also enable archive log by clicking "Enable Archiving".

Click "Next" button to move forward.

8. Database Content Setting: If you wants to configure or de configure Oracle Text, Oracle OLTP etc. Use this page I am moving forward with default options by clicking "Next".

Anytime, DBA can go back to see or change previous configurations using "Back" button.

9. Initialization Parameter Inputs: If you wants to change some initialization parameter like SGA Size, PGA size, Database block size, Number of process, Character set and Connection mode use this GUI to do so. DBA can also change these value after database creation.

Change required parameters or go with default setting and click "Next".

10 Database Storage Summary: This page will show DBA database storage summary, You can expend a tree in the left panel of this Screen. This page doesn't need any input for DBA.

Click "Next" to move forward.

11. Database Creation Options: Here you will find three options Create Database (default), Save as a database Template and Generate Database Creation Scripts.

Create database will create a database only for this time.

Save database template will save this template for future use, In future DBA can use same template for database creation and this template will have all customizations done by Database Administrator. 

Generate Database Creation Scripts will create a script for database creation which can can execute manually as well.

Database administrator can chose multiple options at one time or all options as well. Here, I am just creating a database.

Click "Finish" to move forward. This will show you a summary of database going to create.

Click on "OK" button. Next database creation will start automatically. see below screen

Database creation will take around 15 to 20 Minutes, Database Administrator can also see the Percentage of work done using above screen. One this process is done you will see a password management screen like below.

If you want's to unlock few uses Click "Password Management" and provide password for user or you can do this manually after database creation. DBA can also see log files for database creation at location given in this screen "/u01/app/oracle/cfgtoollogs/dbca/newdb". Here You are done with RAC database creation with DBCA.

Login to database server and check if database is working on both nodes by this command.

[oracle@ ~]$ srvctl status database -d newdb
Instance newdb1 is running on node node1
Instance newdb2 is running on node node2

Please share if this post helps you in creating a RAC database.

No comments:

Post a Comment