Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Create Oracle RAC and Oracle RAC ONE Node Database using dbca in Oracle 11g R2 (11.2.0.2)

Create Oracle RAC and Oracle RAC ONE Node Database using dbca in Oracle 11g R2 (11.2.0.2)
  

In this article we will look at creating Oracle RAC and RAC ONE Node database using dbca. For install/upgrade to Oracle 11.2.0.2 look here.
  

Create Oracle RAC ONE Node database using dbca
  

Start dbca and select Oracle RAC One Node database and press Next to continue.
  


  

Select ‘Create a Database’ and press Next to continue.
  


  

Select Custom Database and press Next to continue.
  


  

Select Admin-Managed, enter database global name, SID prefix and service name and press Next to continue. DBCA will create one database with one instance which can be migrated across the nodes selected.
  


  

Enter and confirm the password(s) and press Next to continue.
  


  

Specify storage type and storage location and press Next to continue.
  


  

Specify the Fast recovery area (formerly flash recovery area) and press Next to continue.
  


  

Select the database components and component location and press Next to continue.
  


  

Select the init parameters. In this case use AMM is selected and the memory size is specified. Press Next to continue.
  


  

Keep the defaults and press Next to continue.
  


  

Select the options for dbca to generate a template and generation scripts and press Next to continue.
  


  

Review the summary and press OK to continue.
  


  

Wait for the dbca to complete.
  


  

Optionally choose the password management to change the passwords and unlock the accounts and once done press Exit to exit from dbca.
  


  

Create Oracle RAC database using dbca
  

Start dbca and select Oracle RAC database and press Next to continue.
  


  

Select ‘Create a Database’ and press Next to continue.
  


  

Select General Purpose or Transaction Processing Database and press Next to continue.
  


  

Select Admin-Managed, enter database global name, SID prefix and press Next to continue. DBCA will create one database with two instances on each node respectively.
  


  

Select Configure Enterprise Manager and select Automatic Maintenance Tasks Tab.
  


  

Select Enable automatic maintenance tasks and press Next to continue.
  


  

Enter and confirm the password(s) and press Next to continue.
  


  

Specify storage type and storage location and press Next to continue.
  


  

Specify the Fast recovery area (formerly flash recovery area) and press Next to continue.
  


  

Select the database components and component location and press Next to continue.
  


  

Select the init parameters. In this case use AMM is selected and the memory size is specified. Press Next to continue.
  


  

Keep the defaults and press Next to continue.
  


  

Select the options for dbca to generate a template and generation scripts and press Next to continue.
  


  

Review the summary and press OK to continue.
  


  

Wait for the dbca to complete.
  


  

Wait for the dbca to complete.
  


  

Wait for the dbca to complete. Optionally choose the password management to change the passwords and unlock the accounts and once done press Exit to exit from dbca.
  


  

Verify RACDB installation
  

 

 [oracle@raclinux1 ~]$ srvctl status database -d RACDB
 

Instance RACDB1 is not running on node raclinux1
 

Instance RACDB2 is not running on node raclinux2
 

[oracle@raclinux1 ~]$ srvctl start database -d RACDB
 

[oracle@raclinux1 ~]$ srvctl status database -d RACDB
 

Instance RACDB1 is running on node raclinux1
 

Instance RACDB2 is running on node raclinux2
 

[oracle@raclinux1 ~]$ srvctl config database -d RACDB
 

Database unique name: RACDB
 

Database name: RACDB
 

Oracle home: /u01/app/oracle/product/11.2.0/db_10
 

Oracle user: oracle
 

Spfile: +DGDUP/RACDB/spfileRACDB.ora
 

Domain:
 

Start options: open
 

Stop options: immediate
 

Database role: PRIMARY
 

Management policy: AUTOMATIC
 

Server pools: RACDB
 

Database instances: RACDB1,RACDB2
 

Disk Groups: DGDUP,DATA
 

Mount point paths:
 

Services:
 

Type: RAC
 

Database is administrator managed
 

[oracle@raclinux1 ~]$
 

 
 

[oracle@raclinux1 ~]$ sqlplus system/sys1@racdb
 

 
 

SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 5 14:26:32 2010
 

 
 

Copyright (c) 1982, 2010, Oracle.  All rights reserved.
 

 
 

 
 

Connected to:
 

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
 

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
 

Data Mining and Real Application Testing options
 

 
 

SQL> select * from gv$instance;
 

 
 

   INST_ID INSTANCE_NUMBER INSTANCE_NAME
 

---------- --------------- ----------------
 

HOST_NAME
 

----------------------------------------------------------------
 

VERSION           STARTUP_T STATUS       PAR    THREAD# ARCHIVE LOG_SWITCH_WAIT
 

----------------- --------- ------------ --- ---------- ------- ---------------
 

LOGINS     SHU DATABASE_STATUS   INSTANCE_ROLE      ACTIVE_ST BLO
 

---------- --- ----------------- ------------------ --------- ---
 

         1               1 RACDB1
 

raclinux1.gj.com
 

11.2.0.2.0        05-OCT-10 OPEN         YES          1 STOPPED
 

ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO
 

 
 

 
 

   INST_ID INSTANCE_NUMBER INSTANCE_NAME
 

---------- --------------- ----------------
 

HOST_NAME
 

----------------------------------------------------------------
 

VERSION           STARTUP_T STATUS       PAR    THREAD# ARCHIVE LOG_SWITCH_WAIT
 

----------------- --------- ------------ --- ---------- ------- ---------------
 

LOGINS     SHU DATABASE_STATUS   INSTANCE_ROLE      ACTIVE_ST BLO
 

---------- --- ----------------- ------------------ --------- ---
 

         2               2 RACDB2
 

raclinux2.gj.com
 

11.2.0.2.0        05-OCT-10 OPEN         YES          2 STOPPED
 

ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO
 

 
 

 
 

SQL>
 

 

 

 

  

   

   

   

   

   

Verify RONE installation
  

   

 

 [oracle@raclinux2 admin]$ srvctl status database -d rone 

Instance RONE_1 is running on node raclinux2 

Online relocation: INACTIVE 

[oracle@raclinux2 admin]$ srvctl config database -d rone 

Database unique name: RONE 

Database name: RONE 

Oracle home: /u01/app/oracle/product/11.2.0/db_20 

Oracle user: oracle 

Spfile: +DATA/RONE/spfileRONE.ora 

Domain: 

Start options: open 

Stop options: immediate 

Database role: PRIMARY 

Management policy: AUTOMATIC 

Server pools: RONE 

Database instances: 

Disk Groups: DATA 

Mount point paths: 

Services: RACONE 

Type: RACOneNode 

Online relocation timeout: 30 

Instance name prefix: RONE 

Candidate servers: raclinux2,raclinux1 

Database is administrator managed 

[oracle@raclinux2 admin]$ 

[oracle@raclinux2 admin]$ sqlplus system/sys1@ronetaf 

SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 5 14:21:50 2010 

Copyright (c) 1982, 2010, Oracle.  All rights reserved. 

Connected to: 

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production 

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, 

Data Mining and Real Application Testing options 

SQL> select * from gv$instance; 

   INST_ID INSTANCE_NUMBER INSTANCE_NAME 

---------- --------------- ---------------- 

HOST_NAME 

---------------------------------------------------------------- 

VERSION           STARTUP_T STATUS       PAR    THREAD# ARCHIVE LOG_SWITCH_WAIT 

----------------- --------- ------------ --- ---------- ------- --------------- 

LOGINS     SHU DATABASE_STATUS   INSTANCE_ROLE      ACTIVE_ST BLO 

---------- --- ----------------- ------------------ --------- --- 

         1               1 RONE_1 

raclinux2.gj.com 

11.2.0.2.0        05-OCT-10 OPEN         YES          1 STOPPED 

ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO 

SQL> 

 

 

Summary
  

We looked at creating RAC and RAC ONE Node databases using dbca in Oracle 11gR2 11.2.0.2. We verified that the databases was successfully created. 

October 5, 2010 - Posted by | oracle

5 Comments »

  1. […] in 11.2.0.2 is the ability to easy create RAC One Node database using dbca utility as specified here. To recount, prior to Oracle 11gR2 11.2.0.2 patch 994114 had to be applied to provide the […]

    Pingback by Oracle 11g R2 (11.2.0.2) RAC One Node management « Guenadi N Jilevski's Oracle BLOG | October 7, 2010 | Reply

  2. […] Create Oracle RAC and Oracle RAC ONE Node Database using dbca in Oracle 11g R2 (11.2.0.2)    In this article we will look at creating Oracle RAC and RAC ONE Node database using dbca. For install/upgrade to Oracle 11.2.0.2 look here.    Create Oracle RAC ONE Node database using dbca    Start dbca and select Oracle RAC One Node database and press Next to continue.       Select 'Create a Database' and press Next to continue.       Select Custom Data … Read More […]

    Pingback by Create Oracle RAC and Oracle RAC ONE Node Database using dbca in Oracle 11g R2 (11.2.0.2) (via Guenadi N Jilevski’s Oracle BLOG) « Levi Pereira's | December 9, 2010 | Reply

  3. Does RAC One Node work on Solaris?

    Thank you

    Comment by Mario | August 18, 2011 | Reply

    • Hello Mario,

      11.2.0.2 was released later for Solaris after the release of 11.2.0.2 for Linux. The concept is the same. Should work as dbca/oui gives you the tools to build it .

      Regards

      Comment by gjilevski | August 18, 2011 | Reply

  4. Very well step by step process. I have also documented step for creating RAC database using DBCA at

    http://www.dbas-oracle.com/2013/07/Create-RAC-Real-Application-Cluster-Database-using-DBCA.html

    Comment by Umesh | August 1, 2013 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: