Oracle RAC 10g for Solaris環境卸載(一)資料庫的刪除和資料庫軟體的卸載

這是一個三節點的RAC環境，資料庫版本是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

首先關閉資料庫和監聽：

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

確認沒有資料庫服務啟動：

bash-2.03$ srvctl status service -d testrac

Service PRE_TESTRAC is not running.

Service mytest is not running.

根據需要，可以選擇是否使用DBCA刪除資料庫。使用圖形方式刪除Oracle資料庫非常簡單。

本欄目更多精彩內容：http://www.bianceng.cn/database/Oracle/

下面關閉ASM執行個體：

bash-2.03$ srvctl stop asm -n racnode1

bash-2.03$ srvctl stop asm -n racnode2

bash-2.03$ srvctl stop asm -n racnode3

然後可以利用runInstaller來卸載Oracle資料庫軟體：

$ cd $ORACLE_HOME/oui/bin

$ ./runInstaller

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will 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.

在圖形介面上選擇Deinstall Products。

選擇當時安裝的Oracle的Software的路徑名稱，這裡是OraDb10g_home1，然後點擊Remove。

Oracle會彈出所有卸載的組件，點擊確認後開始刪除。

Oracle軟體的刪除過程出了一個錯誤，似乎是刪除遠端節點的軟體時的報錯，檢查$ORACLE_BASE/oraInventory/log目錄，找到對應的trace檔案，發現了下面的資訊：

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.