Thursday, January 30, 2014

ORA-15032: not all alterations performed, ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)


##########################
## 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: