Check current RAC nodes
root@grac41 Desktop]# olsnodes -n -i -s -t
grac42 1 192.168.1.187 Active Unpinned
grac43 2 192.168.1.253 Active Unpinned
grac41 3 192.168.1.183 Active Unpinned
Remove an instance
[oracle@grac41 ~]$ srvctl stop instance -d grac4 -i grac42
[oracle@grac41 ~]$ srvctl disable instance -d grac4 -i grac42
[oracle@grac41 ~]$ srvctl remove instance -d grac4 -i grac42
Remove instance from the database grac4? (y/[n]) y
Verify status
[oracle@grac41 ~]$ srvctl config database -d grac4
Database unique name: grac4
Database name: grac4
Oracle home: /u01/app/oracle/product/11204/racdb
Oracle user: oracle
Spfile: +DATA/grac4/spfilegrac4.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: grac4
Database instances: grac41,grac43
Disk Groups: DATA
Mount point paths:
Services: grac41,grac43,my_rac_svc
Type: RAC
Database is administrator managed
--> Instance grac42 successfully removed
Add the instance:
[oracle@grac41 ~]$ srvctl add instance -d grac4 -i grac42 -n grac42
[oracle@grac41 ~]$ srvctl enable instance -d grac4 -i grac42
[oracle@grac41 ~]$ srvctl start instance -d grac4 -i grac42
[oracle@grac41 ~]$ srvctl status instance -d grac4 -i grac42
Instance grac42 is running on node grac42
[oracle@grac41 ~]$ srvctl config database -d grac4
Database unique name: grac4
..
Database instances: grac41,grac42,grac43