虚拟机下删除oracle,虚拟机环境下RAC删除节点(Final)-CSDN博客

备注：以下是虚拟机环境下的配置，某些配置可能不同与实际的RAC环境。

1. 环境 Linux AS5.3 64bit, Oracle10.2.0.4, 3个节点1，2，3，现在需要删除节点2 。

2. 注意，下列操作均是在确实要保留的实例上进行，不要选择在要被删除的节点上进

行操作；作业请做好备份工作。

3. 刪除數據庫實例：在節點1上dbca 刪除節點2的實例 (所有节点都是open状态)。

选择RAC database,选择Instance Management,Delete Instance,

选择要操作的数据库，并输入一个具有sysdba权限的用户及密码

选择一个要删除的实例，这里是orcl2

确定删除点击OK，接下来可能會跳出一些窗口，如果非報錯，同样直接点击OK即可

开始进行删除操作

4. 在節點1上 $ crs_stat -t 查看一下，節點2上實例已經不存在。

5. 刪除節點信息：刪除節點2的監聽服務，在節點1上執行netca .

在節點1上 $ crs_stat -t 查看一下，節點2上的监听已經不存在。

6. 停止目标节点(要删除的节点2)的apps, 可以在任意节点(这里在节点1上)执行：

$ srvctl stop nodeapps -n rac02

$crs_stat -t 可以看到相关服务已经关闭。

7. 刪除目標節點2數據庫軟件, 更新Oracle Inventory ，在节点1上：

rac01$/u01/product/oracle/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_

NODES=rac01,rac03"

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.

The inventory pointer is located at /etc/oraInst.loc

The inventory is located at /u01/product/oraInventory

'UpdateNodeList' was successful.

接下来要在准备被删除的节点2上执行，同样是更新Oracle Inventory。

rac02$/u01/product/oracle/oui/bin/runInstaller -updateNodeList ORACLE_

HOME=$ORACLE_HOME "CLUSTER_NODES=rac02" -local

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.

The inventory pointer is located at /etc/oraInst.loc

The inventory is located at /u01/product/oraInventory

'UpdateNodeList' was successful.

8. 然后就可以在節點2删除该节点上的数据库软件了(注意選擇ORACLE軟件，不是crs)，

如果節點2本身是损坏的，是關閉的，就不需要執行刪除。这里RAC02是正常的，所以需要执行。

rac02$ $ORACLE_HOME/oui/bin/runInstaller -deinstall

我在这里碰到一个java错误，估计是libXp包没有安装。

[root@rac02 packages]# rpm -ivh libXp-1.0.0-8.1.el5.i386.rpm

warning: libXp-1.0.0-8.1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186

Preparing... ########################################### [100%]

1:libXp ########################################### [100%]

9. 删除ONS配置: 在保留節點1上執行

rac01$/u01/product/crs/bin/racgons remove_config rac02:6200

racgons: Existing key value on rac02 = 6200.

racgons: rac02:6200 removed from OCR.

10. 删除节点2 CRS 服务，进入/u01/product/crs/install 目录，执行rootdelete.sh，在将要被删除的

节点上运行。

[root@rac02 packages]# cd /u01/product/crs/install

[root@rac02 install]# pwd

/u01/product/crs/install

[root@rac02 install]# ./rootdelete.sh

CRS-0210: Could not find resource 'ora.rac02.LISTENER_RAC02.lsnr'.

CRS-0216: Could not stop resource 'ora.rac02.ons'.

CRS-0216: Could not stop resource 'ora.rac02.vip'.

CRS-0216: Could not stop resource 'ora.rac02.gsd'.

Shutting down Oracle Cluster Ready Services (CRS):

/etc/init.d/init.cssd: line 319: /tmp/oratz.1556: No such file or directory

/etc/init.d/init.crsd: line 83: /tmp/oratz.1619: No such file or directory

Jan 05 02:47:06.646 | INF | daemon shutting down

Stopping resources. This could take several minutes.

Successfully stopped CRS resources.

Stopping CSSD.

Shutting down CSS daemon.

Shutdown request successfully issued.

Shutdown has begun. The daemons should exit soon.

Checking to see if Oracle CRS stack is down...

Oracle CRS stack is not running.

Oracle CRS stack is down now.

Removing script. for Oracle Cluster Ready services

Updating ocr file for downgrade

Cleaning up SCR settings in '/etc/oracle/scls_scr'

[root@rac02 install]#

11. 在保留节点1上开启crs,

rac01$crs_start -all

[root@rac01 install]# /u01/product/crs/bin/srvctl remove nodeapps -n rac02

Please confirm that you intend to remove the node-level applications on node rac02 (y/[n]) y

CRS-0210: Could not find resource ora.rac02.vip.

12. 执行完上述命令后，返回oracle用户，执行crs_stat查看当前应用的状态，可以看到節點2的信息已經都不存在了。

13. 删除目标节点clusterware软件, 這裡就是選擇crs了,在存在的節點1上執行：

[oracle@rac01 bin]$ /u01/product/crs/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORA_CRS_HOME "CLUSTER_NODES=rac01,rac03" CRS=TRUE

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.

The inventory pointer is located at /etc/oraInst.loc

The inventory is located at /u01/product/oraInventory

'UpdateNodeList' was successful.

14. 然后切换至目标节点2，执行更新Oracle Inventory的操作, 如果節點2已經损坏關機，就不用執行。

rac02$/u01/product/crs/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORA_CRS_HOME

"CLUSTER_NODES=rac02" CRS=TRUE -local

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.

The inventory pointer is located at /etc/oraInst.loc

The inventory is located at /u01/product/oraInventory

'UpdateNodeList' was successful.

15. 接下来在目標節點2执行runInstaller -deinstall命令，执行clusterware软件的删除操作(注意是在界面操作)：

[oracle@rac02]$cd $ORA_CRS_HOME/oui/bin/

[oracle@rac02]$./runInstaller -deinstall ，如果節點2已經损坏關閉就不用執行。

16. 从OCR中删除节点信息(在存在的节点1上执行):

在节点1上查看一下节点信息

rac01$olsnodes

rac01

rac02

rac03

rac01$./olsnodes -n -i

rac01 1 vip01

rac02 2 rac03 3 vip03

儘管通过前面的操作，ORACLE软件以及集群件均已被删除，节点信息也更新过了，不过OCR中还是保留

有 rac02 节点的信息，因此这块也需要删除，执行脚本如下(切换到root用户):

[root@rac01 install]# cd /u01/product/crs/install

[root@rac01 install]# ./rootdeletenode.sh rac02,2

CRS-0210: Could not find resource 'ora.rac02.LISTENER_RAC02.lsnr'.

CRS-0210: Could not find resource 'ora.rac02.ons'.

CRS-0210: Could not find resource 'ora.rac02.vip'.

CRS-0210: Could not find resource 'ora.rac02.gsd'.

CRS-0210: Could not find resource ora.rac02.vip.

CRS nodeapps are deleted successfully

clscfg: EXISTING configuration version 3 detected.

clscfg: version 3 is 10G Release 2.

Successfully deleted 14 values from OCR.

Key SYSTEM.css.interfaces.noderac02 marked for deletion is not there. Ignoring.

Successfully deleted 5 keys from OCR.

Node deletion operation successful.

'rac02,2' deleted successfully

[root@rac01 ~]# su - oracle

rac01$

rac01$cd /u01/product/crs/bin/

rac01$./olsnodes -n -i

rac01 1 vip01

rac03 3 vip03

rac01$

到此，删除节点操作结束。

17. 如果愿意(或者确实需要)，可以考虑清除ORACLE留下的一些操作痕迹，包括但不限于下列：

删除$ORACLE_BASE/oraInventory目录

删除/etc/inittab文件

删除/var/tmp/.oracle目录

删除ORA相关的启动关闭脚本，比如/etc/init.d/init*，以及/etc/rc?.d/*init.crs等文件

删除/etc/oracle目录

清除crontab中关于ORACLE的相关任务；

清除oracle用户下profile中关于ORA的相关环境变量设置；

清除共享存储分配给RAC02的相关权限