How to Add to an existin 2-node Cluster
Hi,
Consider the Following environment.
Nodenames : node1.us.oracle.com node1
node2.us.oracle.com node2
node3.us.oracle.com node3
Node to be removed : node3.us.oracle.com node3.
Database name : racdb
Instance names : racdb1, racdb2, racdb3
Do this on node1
Login as the Oracle user and set the CRS_HOME to the Oracle clusterware home
Cd $CRS_HOME/oui/bin
./addNode.sh
It will recognise the existing nodes and ask you to enter the new node name. Enter the “short†node names for public, private and VIP nodename
e.g node3, node3-priv, node3-vip
The installer will copy the software to node3 and at the end will ask you to run a few scripts as the root user on node1 and node3. Make sure that you run the correct script on the correct node as specified. Run the scripts one after the other.
Run this on node1
Login as the oracle user
Cat $CRS_HOME/opmn/conf/ons.config
Look at the remote port entry e.g 6200
Run $CRS_HOME/bin/racgons add_config node3:6200
2. Adding Oracle database software on node3.
Do this on node1
Login as the oracle user
Set the environment variables
Cd $ORACLE_HOME/oui/bin
./addNode.sh
Select node3 from the first screen
The installer will copy the software to node3 and ask you to run root.sh at the end. Run it on the correct node as specified.
Do this node3
Login as the oracle user and set the environment to the DBHOME
$ORACLE_HOME/bin/netca
Choose Cluster management
Choose Listener
Choose ADD
Choose the name as LISTENER
This will add a listener on node3 with the name LISTENER_node3.
3. Creating a database instance on node3
Do this on node1
Login as the oracle user and set the environment to DBHOME
$ORACLE_HOME/bin/dbca
Choose RAC
Choose Instance Management
Choose Add Instance
Select racdb as the database and enter the sys username and password at the bottom of the screen.
It will display the existing instances. Click next and on the following screen enter racdb3 as the instance name and choose node3.
This will create a database instance (racdb3 on node3). During creation it will ask if the ASM instance should be extended to node3. Choose Yes.
This finishes the node addition procedure. To verify do the following:
On node1 : srvctl status nodeapps –n node3
There should be 4 services running
Srvctl status instance –d racdb –I racdb3
It should show the instance racdb3 running on node3.