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
Bir Cevap Yazın