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. 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 gjilevski | oracle

5 Comments »

[…] 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
[…] 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
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
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

About

Guenadi Jilevski is a Senior Oracle Professional (OCP 7, 8, 8i, 9i, 10g, 11g, 12c OCE 10gR2 RAC, OCE Oracle RAC 11gR2 and Grid Infrastructure Administrator, Oracle Exadata 11g Certified Implementation Specialist,Oracle GoldenGate 10g/11g Certified Implementation Specialist and OCM 9i, OCM 11g) with more than 20 years of industrial experience in high end Oracle technology starting with Oracle RDBMS version 6 up to 11g. He has been involved with multi platform High Availability Solutions starting with OPS and Veritas and Sun cluster as well as complex multiple node RAC 9i, 10g and 11g implementations on AIX, Linux, Solaris and HP. He has experience in deploying disaster recovery solutions with standby databases compliant to Oracle MAA and third party solutions such as Shareplex and Goldengate. As a former employee of Oracle Corporation Advanced Technology Solutions Consulting Practice in Americas, Guenadi has been involved in multiple visible high end projects for RAC enabling EBS, Peoplesoft, Siebel ERP applications, end to end performance tuning, architectured High Availability and Disaster Recovery solutions to name a few. Presently he is working as A Senior Oracle Consultant in EMEA.

Guenadi Jilevski is Oracle OCP 7, 8, 8i, 9i, 10g, 11g, 12c OCE 10gR2 RAC, OCE Oracle RAC 11gR2 and Grid Infrastructure Administrator, Oracle Exadata 11g Certified Implementation Specialist,Oracle GoldenGate 10g/11g Certified Implementation Specialist and Oracle OCM9i , OCM 11g, Teradata Certified DBA, Informix Certified DBA.

The views expressed on this blog are my own and do not necessarily reflect the views of Current/Past/Future Employers. The views and opinions expressed by visitors on this blog are theirs solely and may not reflect mine.

Archives
Archives
Blog Stats
- 1,157,657 hits
Top Rated
Blogroll
- WordPress.com 0
- WordPress.org 0
Calendar

October 2010

M T W T F S S

1 2 3

4 5 6 7 8 9 10

11 12 13 14 15 16 17

18 19 20 21 22 23 24

25 26 27 28 29 30 31

« Sep Dec »
Search

Search for:
Email Subscription

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1,114 other followers

Email Address:
OraNA

Guenadi N Jilevski's Oracle BLOG

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