Solaris10下完全卸载Oracle1106RAC环境

上一篇 / 下一篇 2008-07-19 23:37:14 / 个人分类：ORACLE

写了几篇关于Oracle RAC环境的安装，还从来没有写过卸载Oracle RAC环境的文章，前两天在测试的时候发现，如果Rac环境无法卸载干净，很可能再次安装RAC环境时会碰到错误，因此这里简单描述一下Oracle RAC环境的卸载。

首先卸载Oracle数据库，为了更好的卸载数据库，最好是保证数据库处于打开状态，这样DBCA就可以根据读取Oracle数据文件的信息并进行删除。

启动DBCA图形界面，选择Oracle Real Application Cluster database选择。

选择Delete a Databasese。

然后选择FINISH，删除整个数据库文件。

利用NETCA工具删除监听设置。

下面运行建立数据库的图形界面runInstaller，开始数据库软件的卸载：

进入WELCOME界面后，直接点击Installed Products，这时会弹出一个对话框，在Oracle Homes中有两个对象：OraCrs11g_home和OraDb11g_home。

在删除的时候一定要先选择卸载OraDb11g_home，因为还需要运行Cluster目录下的shell脚本来清除CLUSTER对操作系统进行的修改，所以OraCrs11g_home的卸载放到后面的步骤中进行。

选中OraDb11g_home点击REMOVE即可进行卸载。

下面利用CLUSTER目录下提供的shell来清除CLUSTER系统的所有修改：

在节点2执行：

root@newtrade2 # cd /data/oracle/product/11.1/crs/
3dYP-b#F_7hs0root@newtrade2 # . ./install/rootdelete.sh remote nosharedhome -forceITPUB个人空间,pPEu6d _6~w
Getting local node name
)G(`%z;\yb0NODE = newtrade2
8{3WuQ[1p|Ut-x0CRS resources for listeners are still configured.ITPUB个人空间A(KL,ub;u&`as
Getting local node name
1L Y5D/jXB4F!H0NODE = newtrade2ITPUB个人空间't3@9y!T oY1t;~E
Stopping VIPs that are still upITPUB个人空间(dM[vh1Ce4z
Getting cluster node namesITPUB个人空间K6U P2z-R7cw
Cluster Nodes = newtrade1ITPUB个人空间q6z)yka+c jz
newtrade2ITPUB个人空间6a"Xv!ZYZA
Stopping vipITPUB个人空间O v%GG ei'R"@l
Stopping vipITPUB个人空间it)dgf
Stopping resources.
)R*O["Udx9p2H'd0This could take several minutes.ITPUB个人空间0x mMKon$p:W P!m%|&`
Successfully stopped Oracle Clusterware resources
T@u]*Z%RI0Stopping Cluster Synchronization Services.
YTey7e.fE6h0Shutting down the Cluster Synchronization Services daemon.
9[UC9~i,@ao0Shutdown request successfully issued.ITPUB个人空间:y5R I.O2I!u3K
Waiting for Cluster Synchronization Services daemon to stop
:E1R~Ji)dB8Y u}0Cluster Synchronization Services daemon has stoppedITPUB个人空间tbk Zg,qV@M:W
Oracle CRS stack is not running.ITPUB个人空间T2`I%G6c5Ir
Oracle CRS stack is down now.
_2r:z o ~T_VJ0Removing script. for Oracle Cluster Ready servicesITPUB个人空间"o*Sf_)Z0p;p5m
Updating ocr file for downgradeITPUB个人空间2q hs(V'}v-~.rh
Cleaning up SCR settings in '/var/opt/oracle/scls_scr'ITPUB个人空间+I_GdJ[
Cleaning up Network socket directories

在节点1执行：

root@newtrade1 # cd /data/oracle/product/11.1/crs/
oU9_7wo `e9BC0root@newtrade1 # . ./install/rootdelete.sh remote nosharedhome -force
qe9O@~r7pV0Getting local node name
t l@-^(Vh]4q%i0NODE = newtrade1
3tn s2\!OP]0CRS resources for listeners are still configured.ITPUB个人空间{)Ah^e6n.{
Getting local node name
A){i*e6~:G[V0NODE = newtrade1
^ l2Z_ f8NYbS-T0Stopping VIPs that are still up
g:D!Qc{y0Getting cluster node names
Y0V9Zr~0Cluster Nodes = newtrade1ITPUB个人空间\~-`5l+Z E{
newtrade2ITPUB个人空间/J1i.|:O4Wv;Ii
Stopping vipITPUB个人空间+uV#nHyZ a
Stopping vipITPUB个人空间^O&N2[xN:dP[$M,T
Stopping resources.ITPUB个人空间f*eWH/x'~.V&W
This could take several minutes.ITPUB个人空间&y6h3PJ"iP*em!M4|
Successfully stopped Oracle Clusterware resources
:C(x#wj-wh$[W+eP0Stopping Cluster Synchronization Services.
(f0F Uwf0Shutting down the Cluster Synchronization Services daemon.
Shutdown request successfully issued.ITPUB个人空间4g1qlkg$c!_E
Waiting for Cluster Synchronization Services daemon to stopITPUB个人空间 m.fH%`.h-x"I~
Cluster Synchronization Services daemon has stopped
]4wE5QbJ&t0Oracle CRS stack is not running.
J CU"uU2r0Oracle CRS stack is down now.ITPUB个人空间n?c7aRp
Removing script. for Oracle Cluster Ready services
7R"oiD:K#kx'@R0Updating ocr file for downgrade
D0sv6`%RK0Cleaning up SCR settings in '/var/opt/oracle/scls_scr'
Cleaning up Network socket directories

在节点1执行：

root@newtrade1 # ./install/rootdeinstall.sh
#@6n%T;vF/NM-F!|0Verifying existence of ocr.loc file

Removing contents from OCR device
}zU~(y5[02560+0 records inITPUB个人空间2TW D_%]9E
2560+0 records out

下面可以利用CLUSTER的安装程序runInstaller来卸载CLUSTER软件：

进入WELCOME界面后，点击Installed Products，在弹出的对话框中选择OraCrs11g_home，然后点击REMOVE。

最后删除/var/opt目录下的Oracle信息和ORACLE_BASE目录，在两个节点分别执行下面的SQL：

root@newtrade1 # rm -rf /data/oracle
,m#g~0?;D,n!G g,da0root@newtrade1 # rm -rf /var/opt/oracle

删除/usr/local/bin目录下的设置：

root@newtrade2 # rm /usr/local/bin/dbhomeITPUB个人空间w6w%g_N]K&P`+M~
root@newtrade2 # rm /usr/local/bin/oraenv
](U+CQ/Y:Jsv5ol0root@newtrade2 # rm /usr/local/bin/coraenv

最后利用操作系统命令检查一下，系统中是否还残留一些Oracle的设置：

root@newtrade1 # find / -name oracleITPUB个人空间2S P3|i{Yc
/opt/VRTSvcs/wizards/bin/oracleITPUB个人空间j`1Rpg,Y(]M
/opt/openv/netbackup/ext/db_ext/oracleITPUB个人空间%k7l(v?I;E%B-@
/usr/appserver/samples/blueprints/petstore1.4/src/sql/oracle
:C'NE6d;L0/usr/appserver/samples/jdbc/apps/simple/setup/sql/oracle
kqSX._|G UW0/usr/appserver/samples/security/realms/apps/rdbms/setup/sql/oracleITPUB个人空间W;iB3_r;O%?l
/export/CFS/MP1/cluster_server_agents/oracle_agent/patches/123670-01/VRTScsocw/reloc/opt/VRTSvcs/wizards/bin/oracleITPUB个人空间e!ZU4d5gdH&T x
/export/CFS/veritas/cluster_server_agents/oracle_agent/pkgs/VRTScsocw/reloc/opt/VRTSvcs/wizards/bin/oracle
`@m#Zzk0/export/home/oracle
O*XQ4o/vlT)D0/data/oracle