oracle 删除asm,删除ASM实例

1、删除磁盘组

C:\Users\Administrator>set

oracle_sid=+asm

C:\Users\Administrator>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production

on Tue Apr 24 10:42:53 2012

Copyright (c) 1982, 2006, Oracle.All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition

Release 10.2.0.3.0 - Production

With the Partitioning, OLAP and Data Mining

options

--查看是否有数据库实例正在使用自动存储管理实例+ASM

SQL>select instance_name from

v$asm_client;

该命令列出所有正在运行并使用+ASM实例的数据库实例。如果有正在使用+ASM的实例，则不能删除该+ASM实例。必须先对相应的数据库实例SHUTDOWN，然后从asmcmd进入磁盘所在目录，删掉对应的数据库目录和文件。

SYS@ +asm > select name from

v$asm_diskgroup;--查看磁盘组

NAME

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

DG1

DG2

SYS@ +asm > drop diskgroup dg1 including

contents;--删除磁盘组

Diskgroup dropped.

SYS@ +asm > drop diskgroup dg2 including

contents;--一次只能删除一个磁盘组。

Diskgroup dropped.

SYS@ +asm > shutdown--关闭ASM实例

ORA-15100: invalid or missing diskgroup

name

ASM instance shutdown

SYS@ +asm > exit

Disconnected from Oracle Database 10g

Enterprise Edition Release 10.2.0.3.0 - Production

With the Partitioning, OLAP and Data Mining

options

2、从CSS中删除ASM实例信息

C:\Users\Administrator>oradim -delete

-asmsid +asm

Instance deleted.

3、删除ASM相关的参数文件

E:\oracle\product\10.2.0\db_1\database目录下的：SPFILE+ASM.ORA、PWD+ASM.ora、hc_+asm.dat、init.ora

E:\oracle\product\10.2.0\admin目录下的：+ASM

4、删除listener.ora和tnsnames.ora相关的信息