Environment: 11gR2 (11.2.0.3) , Windows 2008R2
Using ASMCDM , dropping a folder/directory gives below error.
ASMCMD> rm moherac
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)
System generated directories should be removed automatically as soon as all it's files are removed.
Sometimes it can happen that the ASM contains empty system directories which cannot be removed.
in such case
Either
Using ASMCDM , dropping a folder/directory gives below error.
ASMCMD> rm moherac
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)
System generated directories should be removed automatically as soon as all it's files are removed.
Sometimes it can happen that the ASM contains empty system directories which cannot be removed.
in such case
Either
Create a new database with the DBCA having the same name as the old directory and subsequently drop the database with the DBCA.
OR:
Create a dummy tablespace having a datafile within the directory to be dropped, drop the tablespace and then remove the datafile using the ASMCMD tool. The old directory will be removed automatically.
2 comments:
This is was expected. Perhaps the database is still active. You need to stop the database with srvctl stop before you could remove the files.
Database was not running, system generated directories are not deleted manually
Post a Comment