Create Oracle RAC Database Using DBCA

Run DBCA utility from oracle user. You have to set ORACLE_HOME AND ORACLE_SID

[oracle@exadb01 dbhome]$ . oraenv
ORACLE_SID = [oracle] ? ORCL
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/11.2.0/dbhome/
The Oracle base has been set to /u01/app/oracle
[oracle@exadb01 dbhome]$ dbca

Select Database Type and Click Next..

Click Next..

Select Template based on your requirement. Click Next…

Provide Configuration Type and Database Name. For RAC database, must select all available Nodes and Click Next…

Deselect the Configure Enterprise Manager option (better to install agent for OEM later). Click Next…

Click on ‘Automatic Maintenance Tasks and Choose ‘Enable automatic Maintenance tasks’ option. Click Next..

Provide the password for sys and system users. Click Next.

Enter DiskGroup Name for Database Datafile. Click Next..

Click ‘Multiplex Redo Logs and Control Files’ Button and provide DiskGroup name for multiplexing. This is highly recommended to multiplex the Redo Logs and Control Files as these are mission critical files in database.

Select ASM Diskgroup for Fast Recovery Area where archive file will be saved. Choose Enable Archiving option based on your requirement. Click Next.

For real life DB (company’s Database), not recommended to create sample schemas. But your personal use, you may choose sample Schemas. Click Next.

From Memory Tab, Set memory for SGA and PGA. Check “Use Automatic Memory Management” and Click Next.

Click on Character Sets Tab and Choose right Character Set for your database. Click Next..

Recheck all database file configuration and Click Next

Select Create Database Option and Click Finish.

Database configuration progressing.

Click Exit. You can change password for default schema later. Installation completed successfully.

[grid@exadb01 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       exadb01
               ONLINE  ONLINE       exadb02
ora.FRA.dg
               ONLINE  ONLINE       exadb01
               ONLINE  ONLINE       exadb02
ora.LISTENER.lsnr
               ONLINE  ONLINE       exadb01
               ONLINE  ONLINE       exadb02
ora.OCR.dg
               ONLINE  ONLINE       exadb01
               ONLINE  ONLINE       exadb02
ora.asm
               ONLINE  ONLINE       exadb01                  Started
               ONLINE  ONLINE       exadb02                  Started
ora.gsd
               OFFLINE OFFLINE      exadb01
               OFFLINE OFFLINE      exadb02
ora.net1.network
               ONLINE  ONLINE       exadb01
               ONLINE  ONLINE       exadb02
ora.ons
               ONLINE  ONLINE       exadb01
               ONLINE  ONLINE       exadb02
ora.registry.acfs
               ONLINE  ONLINE       exadb01
               ONLINE  ONLINE       exadb02
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       exadb01
ora.cvu
      1        ONLINE  ONLINE       exadb01
ora.exadb01.vip
      1        ONLINE  ONLINE       exadb01
ora.exadb02.vip
      1        ONLINE  ONLINE       exadb02
ora.oc4j
      1        ONLINE  ONLINE       exadb01
ora.orcl.db
      1        ONLINE  ONLINE       exadb01                  Open
      2        ONLINE  ONLINE       exadb02                  Open
ora.scan1.vip
      1        ONLINE  ONLINE       exadb01

Leave a Reply