Monday, May 30, 2011

Delete instance from Node1 for Node 2 in RAC 11g R1

Step 1 : Delete instance from Node1 for Node 2
using dbca on VNC Viewer
Step 2 : Clean UP your ASM Instance
srvctl stop asm -n eg8238
srvctl remove asm -n eg8238
remove the Pfile used by ASM
rm $ASM_HOME/dbs/*ASM*
change ASM home to your ASM Software home
remove the OFA of ASM
rm -Rf /u01/app/oracle/admin/+ASM
> /etc/oratab

step 3 : Clean Up Listener
shutdown listener before removal
use netca from Node2 and remove the Node Listener

step 4 : remove the Database Software by first updating the
local inventory for software removal

cd $ORACLE_HOME/oui/bin


./runInstaller
-updateNodeList
ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
"CLUSTER_NODES=eg8238" -local

this updates local inventory for Removal of DAtabase Software
./runInstaller

and once this is done then run the script on all remaining nodes


login to remaining node and run

./runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
CLUSTER_NODES=eg8228



step 5 :
remove the ASM Software by first updating the
local inventory for software removal

ensure that ASM_HOME has a value by
echo $ASM_HOME

cd $ASM_HOME/oui/bin

./runInstaller
-updateNodeList
ORACLE_HOME=$ASM_HOME
"CLUSTER_NODES=eg8238" -local

this updates local inventory for Removal of DAtabase Software
./runInstaller

and once this is done then run the script on all remaining nodes


login to remaining node and run

./runInstaller -updateNodeList ORACLE_HOME=$ASM_HOME
CLUSTER_NODES=eg8228


step 6 :

Remove the Clusterware software
Remove ONS first
by

check the port by logging in $CRS_HOME/opmn/conf

$CRS_HOME/bin/racgons remove_config eg8238:6150

login through root user and run $CRS_HOME/install/rootdelete.sh

run it as root user from Node1
rootdeletenode.sh eg8238,2





step 7 : Remove software for CRS

cd $CRS_HOME/oui/bin

./runInstaller
-updateNodeList
ORACLE_HOME=$CRS_HOME
"CLUSTER_NODES=eg8238"
CRS=TRUE -local


./runInstaller


On remaining Node
./runInstaller -updateNodeList ORACLE_HOME=$CRS_HOME
CLUSTER_NODES=eg8228 CRS=TRUE

No comments: