Shulou(Shulou.com)06/01 Report--

I. Planning

Second, clear thinking

Step1: deleting an instance

Step2: removing oracle software

Step3: removing GI software

Step4: verify after deleting a node

Third, delete node process 1. Delete an instance

The instance is created by policy-managed or administrator-managed, and the steps for deleting the instance are different.

Case 1. Policy-managed

Execute the following command

$srvctl stop instance-d ORCL-n rac3

$srvctl relocate server-n rac3-g Free

The first command stops the Instance, and the second command removes the node from the current server pool and migrates to the free server pool.

Case 2. Administrator-managed

1) stop Instance

Execute the following command

$srvctl status database-d ORCL

$srvctl stop instance-d ORCL-n rac3

2) DBCA delete instance (rac1 execution)

(oracle users)

Method 1: silent mode

Execute the following command:

$dbca-silent-deleteInstance-nodeList rac3-gdbName ORCL-instanceName ORCL3-sysDBAUserName sys-sysDBAPassword oracle

Command reference:

$dbca-silent-deleteInstance-nodeList node_name-gdbName gdb_name-instanceName instance_name-sysDBAUserName sysdba-sysDBAPassword password

Parameter description:

Node_name: the node name you want to add to

Gdb_name: global database name

Instance_name: specify the instance name

Sysdba: a user with sysdba permission

Password: password

Method 2: DBCA graphical interface

two。 Remove the oracle software

1) stop and remove monitoring (rac1)

$srvctl disable listener-n rac3

$srvctl stop listener-n rac3

2) Update inventory (rac3)

$cd $ORACLE_HOME/oui/bin

$. / runInstaller-updateNodeList ORACLE_HOME= $ORACLE_HOME "CLUSTER_NODES= {rac3}"-local

3) Uninstall oracle software (rac3)

$cd $ORACLE_HOME/deinstall

. / deinstall-local

4) Update inventory (rac1)

$cd $ORACLE_HOME/oui/bin

$. / runInstaller-updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES= {rac1,rac2}"

Note: rac1 and rac2 retain node names

3. Remove the GI software

1) View cluster node information

(grid users)

$olsnodes-s-t

Rac1 Active Unpinned

Rac2 Active Unpinned

Rac3 Active Unpinned

The previous command shows whether the node is in the active state and whether it is in the pin state.

If pinned, you need to set it to unpinned.

# crsctl unpin css-n rac3

2) disable cluster programs and daemons (rac3)

(root users)

# export ORACLE_HOME=/u01/app/11.2.0/grid

# cd $ORACLE_HOME/crs/install

# perl rootcrs.pl-deconfig-force

If you encounter the following problems

Can't locate Env.pm in @ INC (@ INC contains: / usr/local/lib64/perl5 / usr/local/share/perl5 / usr/lib64/perl5/vendor_perl / usr/share/perl5/vendor_perl / usr/lib64/perl5/ usr/share/perl5. (.) At crsconfig_lib.pm line 703.

BEGIN failed--compilation aborted at crsconfig_lib.pm line 703.

Compilation failed in require at. / rootcrs.pl line 305.

BEGIN failed--compilation aborted at. / rootcrs.pl line 305.

The execution of the following command is resolved

# cp / u01/app/11.2.0/grid/perl/lib/5.10.0/Env.pm / usr/lib64/perl5/vendor_perl/

3) Delete node information (rac1)

# cd / u01/app/11.2.0/grid/bin

#. / crsctl delete node-n rac3

4) Update inventory (rac3)

(grid users)

$cd $ORACLE_HOME/oui/bin

$. / runInstaller-updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES= {rac3}" CRS=TRUE-silent-local

5) Uninstall GI software (rac3)

(grid users)

$cd $ORACLE_HOME/deinstall

. / deinstall-local

During that time, run a long command at the prompt (root user)

# / tmp/deinstall2020-08-07 / 02-21-51PM/perl/bin/perl-I/tmp/deinstall2020-08-07 / 02-21-51PM/perl/lib-I/tmp/deinstall2020-08-07 / 02-21-51PM/crs/install/ tmp/deinstall2020-08-07 / 02-21-51PM/crs/install/rootcrs.pl-force-deconfig-paramfile "/ tmp/deinstall2020-08-07 / 02-21-51PM/response/deinstall_Ora11g_gridinfrahome1.rsp"

Finally, run three cleanup commands (root user)

# rm-rf / etc/oraInst.loc

# rm-rf / opt/ORCLfmap

# rm-rf / etc/oratab

6) Update inventory (rac1) again

$cd $ORACLE_HOME/oui/bin

$. / runInstaller-updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES= {rac1,rac2}" CRS=TRUE-silent

7) check whether the node is deleted clean (rac1)

(grid users)

$cluvfy stage-post nodedel-n rac3-verbose

8) backup OCR

# cd / u01/app/11.2.0/grid/bin

#. / ocrconfig-manualbackup

4. Verify after deleting a node

1) verify the status of the resource

2) verify database instance information

SQL > select instance_number,instance_name,host_name from gv$instance

INSTANCE_NUMBER INSTANCE_NAME HOST_NAME

1 ORCL1 rac1

2 ORCL2 rac2

-end

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.