How to fix the Oracle error ORA-15293: operation disallowed by ASM_POWER_LIMIT?

In this post, you’ll learn more about the Oracle ErrorORA-15293: operation disallowed by ASM_POWER_LIMIT with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-15293: operation disallowed by ASM_POWER_LIMIT

Reason for the Error ORA-15293: operation disallowed by ASM_POWER_LIMIT

This operation required data movement in order to complete successfully. However, ASM_POWER_LIMIT was set to zero, thereby preventing this operation.

How to fix the Error ORA-15293: operation disallowed by ASM_POWER_LIMIT ?

You can fix this error in Oracle by following the below steps

Repeat the operation after setting ASM_POWER_LIMIT to a non-zero value.