Oracle DBA, How To, Error, Cause and Action

ORA-15320: cannot drop user 'string' that has been assigned as the owner of one or more open files

ORA-15320: cannot drop user 'string' that has been assigned as the owner of one or more open files


Cause:


A SET OWNERSHIP command assigned this user as the owner of one or more files which were open at the time of assignment, and hence this user cannot be dropped due to possible inconsistencies in file ownerships.



Action:


Restart all ASM client instances of the cluster in a rolling manner.

No comments:

Post a Comment

Thanks for your comment.