没有跨不过的坎,没有过不去的河;没有必胜的秘籍,只有拼命的努力.

关于RAC下如何卸载数据库

上一篇 / 下一篇  2008-07-04 09:30:05 / 个人分类:ORACLE数据库

配置RAC数据库运行平台:

数据库版本: 10.2.0.1 ;   操作系统版本: 2.6.9-55.0.0.0.2.ELhugemem; 数据库的CRS安装在/u01/oracle/product/10.2.0/crs_1目录下 ;我把database 安装在 /u01/oracle/product/10.2.0/db_1目录下。ITPUB个人空间~SDY&cJu

出现的问题:

在配置RAC的时候,数据库软件安装完毕,创建数据库的时候,出现中断。

解决办法:

1、尝试将数据库软件和数据库删除掉(其实傻了,直接把数据库删掉重建可以了)。当时没想太多。。。。   这个是我失误的一个地方。

2、手动删除/u01/oracle/product/10.2.0/db_1目录下所有文件,重新运行./runInstaller,结果在检测环境的时候,出现严重错误。

3、我尝试将数据库软件安装在另外一个目录下oradb10g_home2,默认是oradb10g_home1。结果还是没成功。

4、最后,删除操作系统,重新配置(这样多可以熟悉熟悉配置过程)

随后有一个网友给我提供了一个卸载的办法:虽然没有测试过,但是觉得有一定道理,收藏日后可是试试。

附录:

Subject:         10g RAC: How to Clean Up After a Failed CRS InstallITPUB个人空间!OK M6yEvU2Kr
          Doc ID:         Note:239998.1         Type:         BULLETINITPUB个人空间u-`8i-v s QWNI
          Last Revision Date:         01-JUN-2007         Status:         PUBLISHEDITPUB个人空间 ~VX_6n

zgUk:J V"V,E0
)vz"t1HX/D9sR0PURPOSEITPUB个人空间W3y2[lQ"MCT6j
-------
6s8e6t? kDE7f{0ITPUB个人空间 L%`%t7O#vD
The purpose of this document is to help DBA's and support analysts understand how
%M;R4d _ hy0to clean up a failed CRS (Cluster Ready Services) install for 10g RAC.ITPUB个人空间6s"va1^2i

'NHU7x!WA+O0ITPUB个人空间 I0v(FJ3LAf mkm
SCOPE & APPLICATION
1XFL3~;gdT6h:W0-------------------
zn1| qD;I4GF0ITPUB个人空间2a/f4No,zD Ws%\n
DBA's and Support Analysts
B5Gc$`^j0ITPUB个人空间 sgdFx1K fAw

.d%@C8Ya010g RAC: How to Clean Up After a Failed CRS Install
V W6z#o5C\7E _py0---------------------------------------------------
R[)`X+r-A0ITPUB个人空间~^-[8pTb
Not cleaning up a failed CRS install can cause problems like node reboots.ITPUB个人空间9bJ_l FP-~
Follow these steps to clean up a failed CRS install:
]%V6F0u.{#zGn0ITPUB个人空间 h,[lG oXC$b5am
1. Run the rootdelete.sh script. then the rootdeinstall.sh script. from the
P:][};rZd0G0$ORA_CRS_HOME/install directory on any nodes you are removing CRS from.  Running
y6]fAee$_r0these scripts should be sufficent to clean up your CRS install.  If you have
c)e:rQc+Ti)i0any problems with these scripts please open a service request.  ITPUB个人空间Lr?]x;IbK
ITPUB个人空间/k P_D Vp0L7l:nO
If for some reason you have to manually remove the install due to problems
1f!F{$C~r0with the scripts, continue to step 2:ITPUB个人空间 K'BC-c%Y#o-Og/| H;G

%s;d~!CE\#U02. Stop the Nodeapps on all nodes:
6X~ p$q/q S0
,E-mp*D2N_0        srvctl stop nodeapps -n <node name>
s/k2Do'Q)_0
ep0z1rA"La7r03. Prevent CRS from starting when the node boots.  To do this issue the followingITPUB个人空间 EZ2@(R QK
as root:
pG1~K k0
Oa_ }/cT0Sun:
B[*lP6C.C9i0ITPUB个人空间4pZ.Y8}U'B#z s
        rm /etc/init.d/init.cssd
C%kU_"c5K0        rm /etc/init.d/init.crsITPUB个人空间{2[E8o?&f
        rm /etc/init.d/init.crsd
.wn xSd/|m^:}0        rm /etc/init.d/init.evmd
,ZMBx$Q;Cz6t+D1Ct0        rm /etc/rc3.d/K96init.crs
7zI#t4\4f }@0        rm /etc/rc3.d/S96init.crsITPUB个人空间?2Z}_q-B)E
        rm -Rf /var/opt/oracle/scls_scrITPUB个人空间*{&J^2KD!B8q?
        rm -Rf /var/opt/oracle/oprocd
*W+g5T1c:C^+_8jI(Q0        rm /etc/inittab.crsITPUB个人空间2XNH;A{;SX(a
        cp /etc/inittab.orig /etc/inittab
? CsA!e s2v%T5L0
S8]UZBa0Linux:ITPUB个人空间,ZO8b!S0Y1|C/X;l

!F1y/`5`6G(O8v0        rm /etc/oracle/*
i+[%A5De6d;|0        rm -f /etc/init.d/init.cssd
eFW3Q/g-qXg0        rm -f /etc/init.d/init.crs
b%o#u[%_~z0        rm -f /etc/init.d/init.crsd
/bg|[W5L Mi:Z0        rm -f /etc/init.d/init.evmdITPUB个人空间n l+q+OZlw'q d
        rm -f /etc/rc2.d/K96init.crs
R@h1O7Z[0        rm -f /etc/rc2.d/S96init.crs
/cC'p)H1]w ]*@0        rm -f /etc/rc3.d/K96init.crsITPUB个人空间nTP3Q~/\"h(]S
        rm -f /etc/rc3.d/S96init.crsITPUB个人空间9n|-WFjGl
        rm -f /etc/rc5.d/K96init.crs
GpL6a:k,x!yu%@-z0        rm -f /etc/rc5.d/S96init.crsITPUB个人空间2OJq+CXh K{2a
        rm -Rf /etc/oracle/scls_scr
_!qR"N:h@0x0        rm -f /etc/inittab.crs
4Rz)MOtX\DBY0        cp /etc/inittab.orig /etc/inittab
sXD`/jf L%nM n0ITPUB个人空间1K/?'K OB3^tB:w
HP-UX:ITPUB个人空间 zNG Elzm

%V#B*I/_J0        rm /sbin/init.d/init.cssdITPUB个人空间 s+x C;|E
        rm /sbin/init.d/init.crsITPUB个人空间#W(uV`!O
        rm /sbin/init.d/init.crsd
] ],W a$wE*u/ro7o0        rm /sbin/init.d/init.evmd
T`V1Qw6B^_*u0        rm /sbin/rc2.d/K960init.crsITPUB个人空间}gB4V I
        rm /sbin/rc2.d/K001init.crs
d0J6F/D4H0        rm /sbin/rc3.d/K960init.crs
1y_4J']U/y7Z b-?3|9h0        rm /sbin/rc3.d/S960init.crsITPUB个人空间8v9x)fI P+[j'O3U^
        rm -Rf /var/opt/oracle/scls_scr
5q:tH a4pFN0        rm -Rf /var/opt/oracle/oprocd
)Hy Vd)B/cGn/Q.A#[0        rm /etc/inittab.crs
|I] yW n0        cp /etc/inittab.orig /etc/inittabITPUB个人空间8C.rT'r/tM7?/@:aeL

,vv4s j"[)m+o PE,u0HP Tru64:ITPUB个人空间$rN'r X-E

5k-KyVf;Op/N _#a0        rm /sbin/init.d/init.cssdITPUB个人空间Su`@'| p'Q }
        rm /sbin/init.d/init.crsITPUB个人空间 nA`,\d~ o
        rm /sbin/init.d/init.crsdITPUB个人空间Q'M zHqVW2P
        rm /sbin/init.d/init.evmdITPUB个人空间/kz8Rr9Gn/p y
        rm /sbin/rc3.d/K96init.crsITPUB个人空间5G D |VEIIA(_
        rm /sbin/rc3.d/S96init.crsITPUB个人空间#Mu;A!q!B
        rm -Rf /var/opt/oracle/scls_scrITPUB个人空间_:V&|^P.?QM}
        rm -Rf /var/opt/oracle/oprocd
A q*]^^-iP9_%TS9n0        rm /etc/inittab.crsITPUB个人空间q+s(_s Vpik3y
        cp /etc/inittab.orig /etc/inittab
imj8V8B,sG4Q.q0
P%}YWtm0IBM AIX:
~~i"j dB%d[9I(m~t0ITPUB个人空间 pdhZs
        rm /etc/init.cssd
#u aw W(H ?k$rF0        rm /etc/init.crs
4z]6fw p*a;x ^ORi9t0        rm /etc/init.crsd
M"Qh+I1R0        rm /etc/init.evmdITPUB个人空间0Rj;Hvx
        rm /etc/rc.d/rc2.d/K96init.crs
mo/D;IhDl @%M^0        rm /etc/rc.d/rc2.d/S96init.crs
cLmC Dm0        rm -Rf /etc/oracle/scls_scr
%e5X'Sea |$y0        rm -Rf /etc/oracle/oprocd
j b5W$tF~0        rm /etc/inittab.crs
![D!Aa:k `8c0        cp /etc/inittab.orig /etc/inittabITPUB个人空间6I)k g?.u C&it{:f

jQ1@;[G"Z04. If they are not already down, kill off EVM, CRS, and CSS processes or reboot
Tn Mh!~0   the node:
Ip#x4i%F4g0ITPUB个人空间&VF2u{ bWG
        ps -ef | grep crs       ITPUB个人空间+Oq YQ,tg
        kill <crs pid>
"Q,y_^4I6x5t+LT0        ps -ef | grep evm
\d ~l$OP'p0        kill <evm pid>
%b,^%el B0k0~ cSO8In0        ps -ef | grep css       
:q o ]$YZLQx0        kill <css pid>
Q5J]`sG9At0L0ITPUB个人空间 ]1H_t.Mw)T},@&A {
   Do not kill any OS processes, for example icssvr_daemon process !ITPUB个人空间EB@U+IW@
ITPUB个人空间@MXOI9N8G3[~-[8Z
5. If there is no other Oracle software running (like listeners, DB's, etc...),
j`'s[Ie8k0   you can remove the files in /var/tmp/.oracle or /tmp/.oracle.  Example:
:o1qv5iN5R ~}0
*`\V0F%y]O)oV0        rm -f /var/tmp/.oracleITPUB个人空间QL5`,W|j3nG
ITPUB个人空间tQ"_FT$f{(l{
        or
/Q'N${HD [0
x+e {VSiV0        rm -f /tmp/.oracleITPUB个人空间7Ha}QX@ f'n&@#i

%n:OG{0e5rzi06. Remove the ocr.loc
S x!{6y@gJ&b H0   Usually the ocr.loc can be found at /etc/oracle
f n;@BBq \A0ITPUB个人空间'h:t)u C-t4N)E6e5]N8K
7. De-install the CRS home in the Oracle Universal InstallerITPUB个人空间e|~5DO9e%f

WmM6E4Nl:{y8I08. Remove the CRS install location:ITPUB个人空间L$xd3v({h:f v&Y

fnXt i,Ae$G0          rm -Rf <CRS Install Location>/*
5W`h6Omh g1g0
.oG.I Ou8})@;[09. Clean out the OCR and Voting Files with dd commands.  Example:
_3e3b z G0ITPUB个人空间Q/VZ`.r`0IZh%m
        dd if=/dev/zero f=/dev/rdsk/V1064_vote_01_20m.dbf bs=8192 count=2560
+f.LM*U/i*o?0        dd if=/dev/zero f=/dev/rdsk/ocrV1064_100m.ora bs=8192 count=12800ITPUB个人空间*a ZP w i},M
ITPUB个人空间%f#|U9c'H.y7]
   If you placed the OCR and voting disk on a shared filesystem, remove them.ITPUB个人空间{8B'T"rq$B8ZR\
ITPUB个人空间LGUY)r3WQ9s#Z
   If you are removing the RDBMS installation, also clean out any ASM disks if
(Wlqj!Ky3M1j0   they have already been used.ITPUB个人空间&n(u$_f1t%t*xF

/X@ |W?x010.If you would like to re-install CRS, follow the steps in the RAC Installation manual

        


TAG:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-10-13  
   1234
567891011
12131415161718
19202122232425
262728293031 

数据统计

  • 访问量: 6641
  • 日志数: 132
  • 书签数: 11
  • 建立时间: 2008-06-24
  • 更新时间: 2008-10-12

RSS订阅

Open Toolbar