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.
5 Comments »
Leave a Reply
-
Archives
- February 2017 (1)
- November 2016 (1)
- October 2016 (1)
- May 2016 (2)
- March 2016 (3)
- December 2014 (2)
- July 2014 (1)
- June 2014 (6)
- May 2014 (5)
- February 2014 (1)
- December 2012 (2)
- November 2012 (8)
-
Categories
-
RSS
Entries RSS
Comments RSS
[…] 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 […]
[…] 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 […]
Does RAC One Node work on Solaris?
Thank you
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
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