Saturday 11 February 2017

RAC DB creation on Exadata Machine using DBCA.

Overview:
In this article we explain the process of  how to create RAC DB on Exadata Machine using DBCA

DBCA is the oracle utility which provide the easy and fast way to create the DB.
Environment Details

Hostname
Node1 : db01
Node 2: db02
Database version
11.2.0.4
Database Environment
OMFDB 

Login to Exadata Machine node1 and initate DB creation using DBCA.

$export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db
$dbca


DBCA launched db creation window.
select oracle Real appliction clusters(RAC) database option than next




























Select create database option then Next



























Select General purpose and click next


Select Admin-Managed and give the DB Name and SID and select nodes in Exadata Machine.Then Next

Un-check Register with Grid crontrol and slect configuration Database control for Local Management.Then Next


Provide the SYS and SYS and all the other password.Then Next

Provide the Database files location.Then Next


Click on Multiplex Redo logs and Control Files if you want.Then Next

 Provide ASMSNMP Password.Then Next


Provide the Flash Recovery Area Diskgroup. Then Next

 Provide the Archive log format.Then Next


Next



Provide SGA and PGA and all the sizing and character set ,Then Next

































Provide the Redo log size and Next.

 Create Database and Finish.



Read Summary and Click OK


Progress


Database Creation completion Summary, Click Exit.



Check the Database status it should run on both nodes.

$ srvctl status database -d omfdb
Instance omfdb1 is running on node dm01
Instance omfdb2 is running on node dm02

Conclusion:
We learnt the process of  how to create RAC DB on Exadata Machine using DBCA

No comments:

Post a Comment

Comparing Oracle Database Appliance X8-2 Model Family

September 2019 Oracle announced Oracle Database Appliance X8-2 (Small, Medium and HA). ODA X8-2 comes with more computing resources com...