Log in to the asm instance as Oracle User $ export ORACLE_SID=+ASM $ sqlplus / as sysdba Enter the following command to determine whether any Oracle database instance is using the ASM instance: SQL> select instance_name from v$asm_client; #Do not remove if any database is using this asm instance. List all the diskgroups. SQL> select name from v$asm_diskgroup; NAME ------------------------------ DATA FLASH Drop Them. SQL> drop diskgroup DATA including contents; Diskgroup dropped. SQL> drop diskgroup FLASH including contents; Diskgroup dropped. SQL>shutdown immediate Remove the asm entry from the oratab file.
Search This Blog
Saturday, April 21, 2012
How to Delete ASM ?
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment