In sweet memories of my ever loving brother "kutty thambi " ARUN KUMAR

Friday, July 23, 2010

ORA-15302, 0RA-15177 in ASMCMD 10gR2


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

remove command gives error in ASMCMD , while tried to remove the database file folder.
Solution:

I have searched in metalink and forum, i found the solution in OTN forum, i documented it for future reference,

hope, it will be helpful to all.

from metalink:
bug 6110998
metalink note 444812.1
No fix as of yet.

from OTN forum:

normally, if we give rm command we have to get message like below, but in some cases,

ASMCMD> rm *
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD>

ASMCMD> rm RACDB
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)


ASMCMD> rm -rf RACDB
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)
ASMCMD> ls
DEMO/
JAY/
RACDB/

to overcome this bug,

The issue seems to be that the max size of an alias is 48, but the actual length can be more, so you need to delete the file, by file number + file incarnation.

Query this and find the files not removed by rm command:
SELECT 'alter diskgroup bk_group drop file ' --change as needed
|| '''+bk_group.' --change as needed
|| a.file_number
|| '.'
|| file_incarnation
|| ''';'
FROM v$asm_alias a, v$asm_file b
WHERE a.group_number = b.group_number
AND a.file_number = b.file_number
AND b.type = 'BACKUPSET'
AND a.name like 'backupname%' --change as needed
AND a.group_number = 3 --change as needed
ORDER by a.name
/

hope, this will helps you

from the web page:http://forums.oracle.com/forums/thread.jspa?messageID=4339641

No comments:

 
Share/Bookmark