How to cleanup ASM installation (RAC and non-RAC) [ID 311350.1]

Source: Internet
Author: User


The outline of the steps involved are:
A) backup all the ASM client database files stored on the diskgroups.
B) dropping all the diskgroups.
C) Removing ASM resource from CRS (* RAC specific)
D) Removing ASM disk signature (in case of asmlib)
E) Remove the ASM pfile/spfile.
F) Removing ASM entry in the file oratab
G) wipe out the disks header using dd


Following are the steps to be followed:
1) log into the ASM instance and do 'select * from V $ asm_client ;'
2) for each instance listed above, stop the respective databases.
3) backup all the datafiles, logfiles, controlfiles, archive logs, etc. that are currently using ASM storage, to tape or to filesystem (using RMAN ). this needs to be done for every database (ASM client) Using ASM.

** Note: Please make sure you have the data secure before continuing to the next step.

4) Find all the diskgroups: 'select * from V $ asm_diskgroup'
5) for each diskgroup listed above:
'Drop diskgroup <Name> including CONTENTS'
6) shutdown all (RAC nodes) ASM instances.

7) on RAC install verify that all ASM instances are stopped
$ Ora_crs_home/bin/crst_stat | more <-look for ASM resources and make sure the target = offline

8) for Single Instance install run the following script:
$ ORACLE_HOME/bin/localconfig Delete

* This cleans up the cssd configuration.

9) invoke oui, And now de-install the ASM Oracle Home.

10) For RAC install, remove the ASM related resource.
Srvctl remove ASM-n <nodename> <-peform for all nodes of a RAC cluster
Crs_stat | more <-make sure no ASM resources exists

11) If using asmlib (on Linux only), then
A. oracleasm listdisks
B. oracleasm deletedisks (do this for every disk listed above)
C. oracleasm listdisks (to verify they have been deleted)
D. On other RAC nodes: oracleasm listdisks (to verify they have been deleted too)
E. On all nodes (RAC ):

As root run:
#/Etc/init. d/oracleasm stop
#/Etc/init. d/oracleasm disable

12) Delete the ASM pfile or spfile

13) in the file oratab, remove the line relative to the ASM instance

14) clean out the disks headers using the DD command:

For example: dd if =/dev/zero of =/dev/<asm_disk_name> bs = 1024 k count = 50

15) Finally clean out the possible remaining socket files as explained in the following note:

Listener Fails To Start With IPC Permission Errors (TNS-12546 TNS-12555 TNS-00516 TNS-00525) (Doc ID 434062.1)





From Oracle

Bytes -------------------------------------------------------------------------------------------------------



DBA1 group: 62697716 (full); DBA2 group: 62697977 (full) DBA3 group: 62697850 (full)

Super DBA group: 63306533 (full); DBA4 group: 83829929 DBA5 group: 142216823

Chat group: 40132017 chat 2 group: 69087192

-- Add the group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, the application is rejected.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.