Removing a System Created Directory Fails With ORA-15177: Cannot Operate On System Aliases (Doc ID 1513896.1)

Last updated on NOVEMBER 26, 2024

Applies to:

Symptoms

ASMCMD> rm -rf <Database Name>/
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)

ASMCMD> rmalias -r <Database Name>/
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)

The affected directory (here <Database Name>) is a system created directory with a system alias.
It contains neither sub-directories nor any files whilst we try to remove it. It is empty.

$ asmcmd
ASMCMD> ls -l
State    Type    Rebal  Name
MOUNTED  EXTERN  N      DATA/

ASMCMD> cd DATA/
ASMCMD> ls -l
Type             Redund  Striped  Time             Sys  Name
                                                  Y    <Database Name>/

ASMCMD> cd <Database Name>/
ASMCMD> ls -l
ASMCMD> cd ..

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.