环境说明： 操作系统：centos 5 x86数据库：oracle 10.2.0.1 非rac环境asm实例名：+asm
环境说明：
操作系统：centos 5 x86
数据库：oracle 10.2.0.1 非rac环境
asm实例名：+asm
参考：metalink node:311350.1
1、检查asm实例进程
@oracle[/home/oracle]> ps -ef|grep asm|grep -v grep
oracle 4263 1 0 jan20 ? 00:00:02 asm_pmon_+asm
oracle 4265 1 0 jan20 ? 00:00:00 asm_psp0_+asm
oracle 4267 1 0 jan20 ? 00:00:00 asm_mman_+asm
oracle 4269 1 0 jan20 ? 00:00:00 asm_dbw0_+asm
oracle 4271 1 0 jan20 ? 00:00:00 asm_lgwr_+asm
oracle 4273 1 0 jan20 ? 00:00:00 asm_ckpt_+asm
oracle 4275 1 0 jan20 ? 00:00:00 asm_smon_+asm
oracle 4277 1 0 jan20 ? 00:00:00 asm_rbal_+asm
oracle 4279 1 0 jan20 ? 00:00:06 asm_gmon_+asm 
2、设置asm实例名
@oracle[/home/oracle]> export oracle_sid=+asm 
3、检查是否有实例在使用asm
@oracle[/home/oracle]> sqlplus / as sysdba
sql*plus: release 10.2.0.1.0 - production on thu jan 21 08:44:03 2010
copyright (c) 1982, 2005, oracle. all rights reserved.
connected to:
oracle database 10g enterprise edition release 10.2.0.1.0 - production
with the partitioning, olap and data mining options
idle> select instance_name from v$asm_client;
no rows selected
如果有实例在使用asm，，需要首先停止这些相关的实例，并备份相关的datafile、controlfile等
4、检查asm实例上的diskgroup
idle> select name from v$asm_diskgroup;
name
------------------------------
data 
5、删除检查到asm实例上的diskgroup
idle> drop diskgroup data including contents;
diskgroup dropped. 
6、关闭asm实例
idle> shutdown
ora-15100: invalid or missing diskgroup name
asm instance shutdown
idle> exit
disconnected from oracle database 10g enterprise edition release 10.2.0.1.0 - production
with the partitioning, olap and data mining options 
7、从css中删除asm实例信息
@oracle[/home/oracle]> oradism -delete -asmsid +asm 
8、删除asm实例相关的spfile、pfile等文件
@oracle[/home/oracle]> cd $oracle_home/dbs
@oracle[/oracle/app/10.1/dbs]> rm -f *+asm*
@oracle[/oracle/app/10.1/dbs]> cd $oracle_base/admin
@oracle[/oracle/admin]> rm -rf +asm 
9、删除/etc/oratab文件中的asm实例相关行
删除/etc/oratab文件中的如下行
其实删除oracle 实例同样要查出该文件的内容
+asm:/oracle/app/10.1:y 
10、用root用户删除cssd服务
@root[/oracle/app/10.1/bin]> ./localconfig delete
stopping cssd.
shutting down css daemon.
shutdown request successfully issued.
shutdown has begun. the daemons should exit soon. 
11、清除asm使用的设备的文件头信息
@oracle[/home/oracle]> cd /dev/raw/
@oracle[/dev/raw]> ls -l *
crw------- 1 oracle oinstall 162, 1 jan 21 08:45 raw1
crw------- 1 oracle oinstall 162, 2 jan 21 08:45 raw2
crw------- 1 oracle oinstall 162, 3 jan 21 08:45 raw3
@oracle[/dev/raw]> dd if=/dev/zero of=/dev/raw/raw1 bs=1024 count=10
10+0 records in
10+0 records out
10240 bytes (10 kb) copied, 0.00396028 seconds, 2.6 mb/s
@oracle[/dev/raw]> dd if=/dev/zero of=/dev/raw/raw2 bs=1024 count=10
10+0 records in
10+0 records out
10240 bytes (10 kb) copied, 0.00485093 seconds, 2.1 mb/s
@oracle[/dev/raw]> dd if=/dev/zero of=/dev/raw/raw3 bs=1024 count=10
10+0 records in
10+0 records out
10240 bytes (10 kb) copied, 0.00532261 seconds, 1.9 mb/s 
--end--