Adding a RAC NODE
First Perform all pre installation configurations
Ie Installing Linux, Creating groups and users, User equivalency and
Extending shared storage and configuring network etc.
After performing all the pre installation configurations from node1 as
oracle user execute the following command.
Here /cluster/ora10g is CRS HOME.
Extend clusterware to node to be added. In our case it is second node
(node2)
[oracle@node1 ~]$ cd /cluster/ora10g/oui/bin/
[oracle@node1 bin]$ ls
[Link] lsnodes resource runInstaller
[Link] [Link] [Link] [Link]
[oracle@node1 bin]$ ./[Link]
Give the node to be added details is second node (node2)
DB EXPERTS Basavraju 1
And Click Next, Then Click Install
DB EXPERTS Basavraju 2
DB EXPERTS Basavraju 3
Now as root user execute the above scripts as shown
[root@node2 ~]# /orasoft/oraInventory/[Link]
Changing permissions of /orasoft/oraInventory to 770.
Changing groupname of /orasoft/oraInventory to dba.
The execution of the script is complete
[root@node2 ~]#
Execute the following command from first node as root
[root@node1 ~]# cd /cluster/ora10g/install
[root@node1 install]# ./[Link]
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Attempting to add 1 new nodes to the configuration
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name>
<hostname>
DB EXPERTS Basavraju 4
node 2: node2 node2-priv node2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
/cluster/ora10g/bin/srvctl add nodeapps -n node2 -A node2-
vip/[Link]/eth0 -o /cluster/ora10g
[root@node1 install]#
Execute the following command from second node as root user
[root@node2 ~]# /cluster/ora10g/[Link]
WARNING: directory '/cluster' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.
OCR LOCATIONS = /crs1/ocr1
OCR backup directory '/cluster/ora10g/cdata/crs' does not exist. Creating
now
Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/cluster' is not owned by root
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
assigning default hostname node1 for node 1.
assigning default hostname node2 for node 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name>
<hostname>
node 1: node1 node1-priv node1
node 2: node2 node2-priv node2
clscfg: Arguments check out successfully.
NO KEYS WERE WRITTEN. Supply -force parameter to override.
-force is destructive and will destroy any previous cluster
configuration.
Oracle Cluster Registry for cluster has already been initialized
Startup will be queued to init within 90 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
node1
node2
CSS is active on all nodes.
Waiting for the Oracle CRSD and EVMD to start
Oracle CRS stack installed and running under init(1M)
DB EXPERTS Basavraju 5
Running vipca(silent) for configuring nodeapps
IP address "node1-vip" has already been used. Enter an unused IP
address.
[root@node2 ~]#
Return to the Main installation screen click ok
DB EXPERTS Basavraju 6
Now Extend the Oracle Home to the second Node
[oracle@node1 bin]$ cd /orasoft/ora10g/oui/bin/
[oracle@node1 bin]$ ls
[Link] lsnodes resource runInstaller
[Link] [Link] [Link] [Link]
[oracle@node1 bin]$
[oracle@node1 bin]$ ./[Link]
DB EXPERTS Basavraju 7
Select the Node to be added, click Next
DB EXPERTS Basavraju 8
Click Install
DB EXPERTS Basavraju 9
Now execute [Link] as root user from node2
[root@node2 ~]# /orasoft/ora10g/[Link]
Running Oracle10 [Link] script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /orasoft/ora10g
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying coraenv to /usr/local/bin ...
DB EXPERTS Basavraju 10
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of [Link] script.
Now product-specific root actions will be performed.
[root@node2 ~]#
Return to the main installation screen Click Ok and then Click Exit
Now using netca configure Listener on Node2
DB EXPERTS Basavraju 11
[oracle@node1 ~]$ netca
Oracle Net Services Configuration:
Configuring Listener:LISTENER
ServiceAliasException: Could not save Service Alias: TNS-04406:
Object already exists
Default local naming configuration complete.
node2...
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
[oracle@node1 ~]$
Extend ASM instance to Node2
Copy spfile from node1 to node2
[oracle@node1 dbs]$ scp init+[Link]
oracle@node2:/orasoft/ora10g/dbs/init+[Link]
init+[Link] 100% 30 0.0KB/s 00:00
[oracle@node1 dbs]$
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....[Link] application ONLINE ONLINE node1
ora....[Link] application ONLINE ONLINE node1
[Link] application ONLINE ONLINE node1
[Link] application ONLINE ONLINE node1
[Link] application ONLINE ONLINE node1
ora....[Link] application ONLINE ONLINE node2
[Link] application ONLINE ONLINE node2
[Link] application ONLINE ONLINE node2
[Link] application ONLINE ONLINE node2
[Link] application ONLINE ONLINE node1
ora....[Link] application ONLINE ONLINE node1
[oracle@node1 ~]$
[oracle@node1 ~]$ srvctl add asm -n node2 -i +ASM2 -o /orasoft/ora10g
[oracle@node1 ~]$
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....[Link] application ONLINE ONLINE node1
DB EXPERTS Basavraju 12
ora....[Link] application ONLINE ONLINE node1
[Link] application ONLINE ONLINE node1
[Link] application ONLINE ONLINE node1
[Link] application ONLINE ONLINE node1
ora....[Link] application OFFLINE OFFLINE
ora....[Link] application ONLINE ONLINE node2
[Link] application ONLINE ONLINE node2
[Link] application ONLINE ONLINE node2
[Link] application ONLINE ONLINE node2
[Link] application ONLINE ONLINE node1
ora....[Link] application ONLINE ONLINE node1
[oracle@node1 ~]$
Create the directories for ASM log and trace files
[oracle@node2 ~]$ mkdir /orasoft/admin
[oracle@node2 ~]$ mkdir /orasoft/admin/+ASM
[oracle@node2 ~]$ mkdir /orasoft/admin/+ASM/cdump
[oracle@node2 ~]$ mkdir /orasoft/admin/+ASM/udump
[oracle@node2 ~]$ mkdir /orasoft/admin/+ASM/bdump
[oracle@node2 ~]$
[oracle@node1 ~]$ srvctl start asm -n node2 -i +ASM2
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....[Link] application ONLINE ONLINE node1
ora....[Link] application ONLINE ONLINE node1
[Link] application ONLINE ONLINE node1
[Link] application ONLINE ONLINE node1
[Link] application ONLINE ONLINE node1
ora....[Link] application ONLINE ONLINE node2
ora....[Link] application ONLINE ONLINE node2
[Link] application ONLINE ONLINE node2
[Link] application ONLINE ONLINE node2
[Link] application ONLINE ONLINE node2
[Link] application ONLINE ONLINE node1
ora....[Link] application ONLINE ONLINE node1
[oracle@node1 ~]$
[oracle@node2 ~]$ export ORACLE_SID=+ASM2
[oracle@node2 ~]$ sqlplus / as sysdba
SQL*Plus: Release [Link].0 - Production on Thu Aug 5 11:06:48 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
DB EXPERTS Basavraju 13
Connected to:
Oracle Database 10g Enterprise Edition Release [Link].0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining
options
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
ASM_DISKGROUP1 MOUNTED
SQL>
Now use dbca and extend the Instance to Node2
Select oracle real application cluster database, Click Next
DB EXPERTS Basavraju 14
Select Instance Management , Click Next
Select add an Instance , Click Next
DB EXPERTS Basavraju 15
Select database name, Give Sys User name and password, Click Next
DB EXPERTS Basavraju 16
Click Next to add an instance
DB EXPERTS Basavraju 17
Click Next
DB EXPERTS Basavraju 18
DB EXPERTS Basavraju 19
Click Finish
Click Ok
DB EXPERTS Basavraju 20
DB EXPERTS Basavraju 21
[oracle@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....[Link] application ONLINE ONLINE node1
ora....[Link] application ONLINE ONLINE node1
[Link] application ONLINE ONLINE node1
[Link] application ONLINE ONLINE node1
[Link] application ONLINE ONLINE node1
ora....[Link] application ONLINE ONLINE node2
ora....[Link] application ONLINE ONLINE node2
[Link] application ONLINE ONLINE node2
[Link] application ONLINE ONLINE node2
[Link] application ONLINE ONLINE node2
[Link] application ONLINE ONLINE node1
ora....[Link] application ONLINE ONLINE node1
ora....[Link] application ONLINE ONLINE node2
[oracle@node1 ~]$
DB EXPERTS Basavraju 22