oracle12cR2增加节点删除节点挽救集群（实战亲测）

数据库版本：

[oracle@jsbp242305 ~]$ sqlplus -V

 

SQL*Plus: Release 12.2.0.1.0 Production

 

12.2数据库目前有一个bug，sql*plus改sys用户口令会hang住，因为12.2内部行为有了变化，更改密码去更新一张基表的时候有问题，之前做过hanganalyze，我记得好像更改密码的会话在等待raw cache lock。oracle官方建议sys用户口令要用orapwd命令去修改，或者打one-offpatch（16002385）。而one-offpatch又依赖于一个最新的RU（27105253），我在打RU的时候直接报错，节点1崩溃无法挽救，节点2存活，只好采用增删节点的方式挽回集群。

12.2的数据库全是坑，打补丁的时候千万记得从节点2开始打！！

个人经验，仅供参考。

 

##################删除节点##############

IP信息，要删除的是节点1： jsbp242305

[grid@jsbp242306 ~]$ more /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

#10.10.129.41 jsbp242306

 

#Public IP

10.11.176.75 jsbp242305

10.11.176.76 jsbp242306

 

#VIP

10.11.176.77 jsbp242305-vip

10.11.176.78 jsbp242306-vip

 

#SCAN

10.11.176.79 jqhwccdb-scan

 

#Private IP

2.1.176.75 jsbp242305-priv

2.1.176.76 jsbp242306-priv

 

查看是否是unpinned：

[grid@jsbp242306 ~]$ olsnodes -s -t

jsbp242305 Inactive Unpinned

jsbp242306 Active Unpinned

 

都是unpinned，不用运行crsctl unpin css命令。

 

软件的home目录是local的，不是共享的，所以在要删除的节点执行下面命令：

[grid@jsbp242305 ~]$ /oracle/app/12.2.0/grid/deinstall/deinstall -local

Checking for required files and bootstrapping ...

Please wait ...

Location of logs /oracle/app/oraInventory/logs/

 

############ ORACLE DECONFIG TOOL START ############

 

 

######################### DECONFIG CHECK OPERATION START #########################

## [START] Install check configuration ##

 

 

Checking for existence of the Oracle home location /oracle/app/12.2.0/grid

Oracle Home type selected for deinstall is: Oracle Grid Infrastructure for a Cluster

Oracle Base selected for deinstall is: /oracle/app/grid

Checking for existence of central inventory location /oracle/app/oraInventory

Checking for existence of the Oracle Grid Infrastructure home /oracle/app/12.2.0/grid

The following nodes are part of this cluster: jsbp242305

Checking for sufficient temp space availability on node(s) : 'jsbp242305'

 

## [END] Install check configuration ##

 

Traces log file: /oracle/app/oraInventory/logs//crsdc_2018-04-16_10-26-36-AM.log

 

Network Configuration check config START

 

Network de-configuration trace file location: /oracle/app/oraInventory/logs/netdc_check2018-04-16_10-26-44-AM.log

 

Network Configuration check config END

 

Asm Check Configuration START

 

ASM de-configuration trace file location: /oracle/app/oraInventory/logs/asmcadc_check2018-04-16_10-26-44-AM.log

 

Database Check Configuration START

 

Database de-configuration trace file location: /oracle/app/oraInventory/logs/databasedc_check2018-04-16_10-26-44-AM.log

 

Oracle Grid Management database was not found in this Grid Infrastructure home

 

Database Check Configuration END

 

################ DECONFIG CHECK OPERATION END #########################

 

 

########### DECONFIG CHECK OPERATION SUMMARY #######################

Oracle Grid Infrastructure Home is: /oracle/app/12.2.0/grid

The following nodes are part of this cluster: jsbp242305

The cluster node(s) on which the Oracle home deinstallation will be performed are:jsbp242305

Oracle Home selected for deinstall is: /oracle/app/12.2.0/grid

Inventory Location where the Oracle home registered is: /oracle/app/oraInventory

Option -local will not modify any ASM configuration.

Oracle Grid Management database was not found in this Grid Infrastructure home

Do you want to continue (y - yes, n - no)? [n]: y

A log of this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2018-04-16_10-26-34-AM.out'

Any error messages from this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2018-04-16_10-26-34-AM.err'

 

############ DECONFIG CLEAN OPERATION START ########################

Database de-configuration trace file location: /oracle/app/oraInventory/logs/databasedc_clean2018-04-16_10-27-15-AM.log

ASM de-configuration trace file location: /oracle/app/oraInventory/logs/asmcadc_clean2018-04-16_10-27-15-AM.log

ASM Clean Configuration END

 

Network Configuration clean config START

 

Network de-configuration trace file location: /oracle/app/oraInventory/logs/netdc_clean2018-04-16_10-27-15-AM.log

 

Network Configuration clean config END

 

 

Run the following command as the root user or the administrator on node "jsbp242305".

 

/oracle/app/12.2.0/grid/crs/install/rootcrs.sh -force -deconfig -paramfile "/tmp/deinstall2018-04-16_10-26-05AM/response/deinstall_OraGI12Home1.rsp"

 

Press Enter after you finish running the above commands

 

<----------------------------------------

 

按照提示去执行：

[root@jsbp242305 ~]# /oracle/app/12.2.0/grid/crs/install/rootcrs.sh -force -deconfig -paramfile "/tmp/deinstall2018-04-16_10-26-05AM/response/deinstall_OraGI12Home1.rsp"

 

Using configuration parameter file: /tmp/deinstall2018-04-16_10-26-05AM/response/deinstall_OraGI12Home1.rsp

The log of current session can be found at:

/oracle/app/oraInventory/logs/crsdeconfig_jsbp242305_2018-04-16_10-27-36AM.log

PRCR-1070 : Failed to check if resource ora.net1.network is registered

CRS-0184 : Cannot communicate with the CRS daemon.

PRCR-1070 : Failed to check if resource ora.helper is registered

CRS-0184 : Cannot communicate with the CRS daemon.

PRCR-1070 : Failed to check if resource ora.ons is registered

CRS-0184 : Cannot communicate with the CRS daemon.

2018/04/16 10:27:48 CLSRSC-180: An error occurred while executing the command '/oracle/app/12.2.0/grid/bin/srvctl config nodeapps'

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'jsbp242305'

CRS-2679: Attempting to clean 'ora.gipcd' on 'jsbp242305'

CRS-2681: Clean of 'ora.gipcd' on 'jsbp242305' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'jsbp242305' has completed

CRS-4133: Oracle High Availability Services has been stopped.

2018/04/16 10:28:11 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector.

2018/04/16 10:28:42 CLSRSC-4007: Successfully removed Oracle Trace