Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Monday, June 03, 2013

ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)

Environment: 11gR2 ( , 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

Create a new database with the DBCA having the same name as the old directory and subsequently drop the database with the DBCA.
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.


The Human Fly said...

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.

DBMentor said...

Database was not running, system generated directories are not deleted manually