oracle版本:11.2.0.4
RAC两个节点RAC1和RAC2,分别对应实例为racdb1和racdb2,将实例名
修改为racdb_1,racdb_2
--1.停止实例名
[oracle@rac2 ~]$ srvctl status database -d racdb
Instance racdb1 is not running on node rac1
Instance racdb2 is not running on node rac2
[oracle@rac1~]$ srvctl stop instance -d racdb -i racdb1
[oracle@rac1 ~]$ srvctl stop instance -d racdb -i racdb2
--2.杀死oracle进程
在两个节点的系统检查oracle进程是否被正常枪毙 ps aux | grep ora
--3.删除再添加
[oracle@rac1 ~]$ srvctl status database -d racdb
Instance racdb1 is not running on node rac1
Instance racdb2 is not running on node rac2
--删除
srvctl remove instance -d racdb -i racdb1
srvctl remove instance -d racdb -i racdb2
--添加
srvctl add instance -d racdb -i racdb_1 -n rac1
srvctl add instance -d racdb -i racdb_2 -n rac2
--4.启动2个实例
srvctl start instance -d racdb -i racdb_1
srvctl start instance -d racdb -i racdb_2
[oracle@rac2 ~]$ srvctl status database -d racdb
Instance racdb_1 is running on node rac1
Instance racdb_2 is running on node rac2
SQL> select instance_number,instance_name from gv$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
2 racdb_2