ORA-15032: not all alterations performed, ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)

If you want to remove some folder in asm via using asmcmd utulity, than you may hit this error message.

Here the steps:

1. Let us see overview of current diskgroups and sizes:

[grid@myserver] asmcmd -p

ASMCMD [+] > lsdg
MOUNTED EXTERN N 512 4096 1048576 11534336 11009776 0 11009776 0 N ORADATA/
MOUNTED EXTERN N 512 4096 1048576   921600   921532 0   921532 0 N ORAFRA/
MOUNTED EXTERN N 512 4096 1048576    40960    40700 0    40700 0 N ORAREDO/

2. Let us see what we have under diskgroup before dropping:
ASMCMD [+] > cd ORADATA

ASMCMD [+ORADATA] > ls -l
Type Redund Striped Time Sys Name
Y ASM/
Y MYDBSID/
ASMCMD [+ORADATA] > rm MYDBSID/
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)

3. Here is the solution, its simply use the force option

ASMCMD [+ORADATA] > rm -rf MYDBSID

Advertisements