Lokeshaggarwal's DBA

Live the life you love. Love the life you live

Node addition in 11gR2 RAC

Here, we will see a demonstration of adding a node in 11gR2.

[root@rac2 ~]# export DISPLAY=:0.0

[root@rac2 ~]# xhost +

access control disabled, clients can connect from any host

[root@rac2 ~]# su – oracle

[oracle@rac2 ~]$ cd /raczone/db_home1/oui/bin/

[oracle@rac2 bin]$ ./addNode.sh “CLUSTER_NEW_NODES={rac3}”

Starting Oracle Universal Installer…

Checking swap space: must be greater than 500 MB.   Actual 1599 MB    Passed

Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed

Oracle Universal Installer, Version Production

Copyright (C) 1999, 2009, Oracle. All rights reserved.

Performing tests to see whether nodes rac1,rac3 are available

……………………………………………………… 100% Done.



Cluster Node Addition Summary

Global Settings

Source: /raczone/db_home1

New Nodes

Space Requirements

New Nodes


/: Required 3.60GB : Available 28.41GB

Installed Products

Product Names

Oracle Database 11g


Installer SDK Component

Oracle One-Off Patch Installer

Oracle Universal Installer

Oracle Configuration Manager Deconfiguration

Oracle DBCA Deconfiguration

Oracle RAC Deconfiguration

Oracle Database Deconfiguration

Oracle Configuration Manager

Oracle ODBC Driverfor Instant Client

LDAP Required Support Files

SSL Required Support Files for InstantClient

Bali Share

Oracle Extended Windowing Toolkit

Oracle JFC Extended Windowing Toolkit

Oracle Real Application Testing

Oracle Database Vault J2EE Application

Oracle Label Security

Oracle Data Mining RDBMS Files

Oracle OLAP RDBMS Files


Platform Required Support Files

Oracle Database Vault option

Oracle RAC Required Support Files-HAS

SQL*Plus Required Support Files

Oracle Display Fonts

Oracle Ice Browser

Oracle JDBC Server Support Package

Oracle SQL Developer

Oracle Application Express

XDK Required Support Files

RDBMS Required Support Files for Instant Client

SQLJ Runtime

Database Workspace Manager

RDBMS Required Support Files

Oracle Globalization Support

Exadata Storage Server

Provisioning Advisor Framework

Enterprise Manager Database Plugin — Repository Support

Enterprise Manager Repository Core Files

Enterprise Manager Database Plugin — Agent Support

Enterprise Manager Grid Control Core Files

Enterprise Manager Common Core Files

Enterprise Manager Agent Core Files

Agent Required Support Files


Parser Generator Required Support Files

Oracle 11g Warehouse Builder Required Files

Oracle Notification Service (eONS)

Oracle Text Required Support Files

Precompiler Required Support Files

Oracle Database 11g Multimedia Files

Oracle Multimedia Java Advanced Imaging

Oracle Multimedia Annotator

Oracle JDBC/OCI Instant Client

Oracle Multimedia Locator RDBMS Files

Oracle Core Required Support Files

Oracle Help For Java

Sample Schema Data

Oracle Starter Database

Oracle Message Gateway Common Files

Oracle XML Query

XML Parser for Oracle JVM

Expat libraries

Installation Plugin Files

Enterprise Manager Common Files

Perl Modules

Deinstallation Tool

Oracle Quality of Service Management (Client)

Perl Interpreter

JAccelerator (COMPANION)

Oracle Containers for Java

Oracle Code Editor

Oracle Net Required Support Files

Secure Socket Layer

Oracle Universal Connection Pool

Oracle JDBC/THIN Interfaces

Oracle Multimedia Client Option

Oracle Java Client

Character Set Migration Utility

Oracle Locale Builder

PL/SQL Embedded Gateway

OLAP SQL Scripts

Database SQL Scripts

Oracle Globalization Support

Required Support Files

SQL*Plus Files for Instant Client

Oracle ODBC Driver

Oracle Database User Interface

Oracle Notification Service

Enterprise Manager Minimal Integration

XML Parser for Java

Oracle Security Developer Tools

Oracle Wallet Manager

Cluster Verification Utility Common Files

Oracle Clusterware RDBMS Files

Oracle UIX

Enterprise Manager plugin Common Files

HAS Common Files

Precompiler Common Files

Installation Common Files

Oracle Help for the  Web

Oracle LDAP administration

Buildtools Common Files

Assistant Common Files

Oracle Recovery Manager


Generic Connectivity Common Files

Oracle Database Gateway for ODBC

Oracle Programmer

Oracle Database Utilities

Enterprise Manager Agent

Oracle Netca Client


Oracle Call Interface (OCI)

Oracle Multimedia Locator

Oracle Multimedia

Oracle Net

Database Configuration and Upgrade Assistants

Oracle XML Development Kit

Oracle JVM

Oracle Advanced Security

Oracle Internet Directory Client

HAS Files for DB

Oracle Enterprise Manager Console DB

Oracle Net Listener

Oracle Text

Oracle Net Services

Oracle Database 11g

Oracle OLAP

Oracle Spatial

Oracle Partitioning

Enterprise Edition Options


Instantiating scripts for add node (Thursday, June 28, 2012 1:58:45 PM IST)

.                                                                 1% Done.

Instantiation of add node scripts complete

Copying to remote nodes (Thursday, June 28, 2012 1:58:55 PM IST)

…………………………………………………………………………………..                                 96% Done.

Home copied to new nodes

Saving inventory on nodes (Thursday, June 28, 2012 2:24:28 PM IST)

.                                                               100% Done.

Save inventory complete


The following configuration scripts need to be executed as the “root” user in each cluster node.

/raczone/db_home1/root.sh #On nodes rac3

To execute the configuration scripts:

1. Open a terminal window

2. Log in as “root”

3. Run the scripts in each cluster node

The Cluster Node Addition of /raczone/db_home1 was successful.

Please check ‘/tmp/silentInstall.log’ for more details.

[oracle@rac2 bin]$

Now, add an instance in a rac enviornment

srvctl add instance -d dev -i dev3 -n rac3

So, after successfully adding node, you can check the status of your database

[grid@rac3 ~]$ srvctl status database -d dev

Instance dev1 is running on node rac1

Instance dev2 is running on node rac2

Instance dev3 is running on node rac3


July 3, 2012 Posted by | RAC | Leave a comment