Shulou(Shulou.com)05/31 Report--

This article mainly introduces oracle12cR2 how to add nodes to delete nodes to save the cluster, which has a certain reference value. Interested friends can refer to it. I hope you will learn a lot after reading this article. Let's take a look at it.

Database version:

[oracle@jsbp242305] $sqlplus-V

SQL*Plus: Release 12.2.0.1.0 Production

12.2The database currently has a bug,sql*plus changed to sys user password will hang live, because 12.2 internal behavior has changed, there is a problem when changing the password to update a base table, I have done hanganalyze before, I remember as if the password change session was waiting for raw cache lock. Oracle officials suggest that sys users use the orapwd command to change their passwords, or type one-offpatch (16002385). And one-offpatch relies on the latest RU (27105253). When I hit RU, I report an error directly, node 1 crash can not be saved, node 2 survives, so I have to add and delete nodes to save the cluster.

12.2 the database is full of pits, please remember to start from Node 2 when patching!

Personal experience is for reference only.

# Delete a node #

IP information. Node 1: jsbp242305 is to be deleted

[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

Check to see if it is unpinned:

[grid@jsbp242306] $olsnodes-s-t

Jsbp242305 Inactive Unpinned

Jsbp242306 Active Unpinned

It's all unpinned, so you don't have to run the crsctl unpin css command.

The home directory of the software is local, not shared, so execute the following command on the node you want to delete:

[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-16010-26-36-AM.log

Network Configuration check config START

Network de-configuration trace file location: / oracle/app/oraInventory/logs/netdc_check2018-04-16010-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-16010-26-44-AM.log

Database Check Configuration START

Database de-configuration trace file location: / oracle/app/oraInventory/logs/databasedc_check2018-04-16010-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 million 10-26-34 AM.outout'

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

# DECONFIG CLEAN OPERATION START #

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

ASM de-configuration trace file location: / oracle/app/oraInventory/logs/asmcadc_clean2018-04-16 October 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 October 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-16010-26-05AM/response/deinstall_OraGI12Home1.rsp"

Press Enter after you finish running the above commands

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.