Oracle RAC 10g for Solaris Environment Uninstall (i) database deletion and database software uninstall

This is a three-node RAC environment with a database version of 10.2.0.3:

Sql> SELECT * from V$version;

BANNER

----------------------------------------------------------------

Oracle database10genterpriseedition Release10.2.0.3.0-64bi

Pl/sql Release 10.2.0.3.0-production

CORE??? 10.2.0.3.0????? Production

TNS for Solaris:version 10.2.0.3.0-production

Nlsrtl Version 10.2.0.3.0-production

Sql> SELECT Instance_number, instance_name, host_name, STATUS

? 2? From Gv$instance;

Instance_number instance_name??? Host_name? STATUS

--------------- ---------------- ---------- ------------

????????????? 1 Testrac1???????? Racnode1?? OPEN

????????????? 3 TESTRAC3???????? Racnode3?? OPEN

????????????? 2 TESTRAC2???????? Racnode2?? OPEN

Sql> SELECT NAME from V$database;

NAME

---------

Testrac

First shut down the database and listen:

bash-2.03$ srvctl Stop db-d Testrac

bash-2.03$ srvctl Stop Listener-n racnode1

bash-2.03$ srvctl Stop Listener-n Racnode2

bash-2.03$ srvctl Stop Listener-n racnode3

Verify that no database service is started:

bash-2.03$ srvctl Status service-d Testrac

Service Pre_testrac is not running.

Service MyTest is not running.

Optionally, you can choose whether to delete the database using DBCA. The graphical way to delete an Oracle database is simple.

This column more highlights: http://www.bianceng.cn/database/Oracle/

Close the ASM instance below:

bash-2.03$ srvctl Stop Asm-n racnode1

bash-2.03$ srvctl Stop Asm-n Racnode2

bash-2.03$ srvctl Stop Asm-n racnode3

You can then use Runinstaller to uninstall Oracle database software:

$ cd $ORACLE _home/oui/bin

$./runinstaller

Starting Oracle Universal Installer ...

No pre-requisite checks found in Oraparam.ini, no system pre-requisite checks would be executed.

Preparing to launch Oracle Universal Installer from/tmp/orainstall2010-04-22_05-00-41pm. Please wait ... $ Oracle Universal Installer, Version10.2.0.3.0 Production

Copyright (C) 1999, 2006, Oracle. All rights reserved.

Select Deinstall products on the graphical interface.

Select the path name of the software Oracle that was installed, here is oradb10g_home1, and then click Remove.

Oracle will eject all uninstalled components, click Confirm and start deleting.

An error occurred in the removal process of ORACLE software, which appears to be a bug when removing software from the remote node, checking the $oracle_base/orainventory/log directory, finding the corresponding trace file, and discovering the following information:

info:running command '/tmp/orainstall2010-04-22_05-00-41pm/oui/bin/runinstaller-jreloc. /.. /jre-paramfile/tmp/orainstall2010-04

-22_05-00-41pm/oui/clusterparam.ini? -silent-ignoresysprereqs-removehome-noclusterenabled oracle_home=/data/oracle/product/10.2/d

Atabase local_node=racnode3-remoteinvocation-invokingnodename Racnode2-logfilepath "/data/oracle/oraInventory/ Logs "-timestamp 20

10-04-22_05-00-41pm ' On the nodes ' Racnode3 '.

Info:invoking OUI on cluster nodes Racnode3

INFO:/tmp/orainstall2010-04-22_05-00-41pm/oui/bin/runinstaller-jreloc. /.. /jre-paramfile/tmp/orainstall2010-04-22_05-00-41pm/ou

I/clusterparam.ini? -silent-ignoresysprereqs-removehome-noclusterenabled Oracle_home=/data/oracle/product/10.2/database LOCAL_NOD

E=racnode3-remoteinvocation-invokingnodename Racnode2-logfilepath "/data/oracle/orainventory/logs"- timestamp2010-04-22_05-00-41

Pm

Severe:remote ' Removehome ' failed on nodes: ' Racnode1 '. Refer to '/data/oracle/orainventory/logs/installactions2010-04-22_05-00-41p

M.log ' for details.