##########################
## Error
##########################
ORA-15032: not all alterations performed
### Full Error
ASMCMD [+data] > rm RACDB01
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)
##########################
# Error Occurred
##########################
Error occured while removing a database directory in ASMCMD Prompt of 11.2.0.3.0 version
##########################
## Command Executed
##########################
rm RACDB01
**************************************** Step By Step Analysis ******************************************************
#########################################
# 1) Folder Overview
#########################################
We have created new database with name RACDB01. But later on we need to create the same database with Different name. So We have used DBCA in silent mode to remove the database.
RAC Database and its instances was removed from OCR, but the database file which are present in ASM didn't get removed. so we are manually removing the directories as its not needed anymore.
=====================================================================================================================
#########################################
# 2) Before Dropping
#########################################
ASMCMD [+data] > ls -l
Type Redund Striped Time Sys Name
Y DB_UNKNOWN/
Y RACDB02/
Y RACDB01/
Y RACDB07/
ASMCMD [+data] >
=====================================================================================================================
#########################################
# 3) Reproduce the Error
#########################################
Removing RACDB01 directory with rm command produces the error.
ASMCMD [+data] > rm RACDB01
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)
=====================================================================================================================
#########################################
# Solution
#########################################
Just use Force option while removing.
rm -rf RACDB01
ASMCMD [+data] > rm -rf RACDB01
ASMCMD [+data] > ls -l
Type Redund Striped Time Sys Name
Y DB_UNKNOWN/
Y RACDB02/
Y RACDB07/
ASMCMD [+data] >
=====================================================================================================================
RACDB01 folder is removed now.
=====================================================================================================================
=====================================================================================================================
Comments Are Always welcome
=====================================================================================================================
No comments:
Post a Comment