How to fix the Oracle error ORA-15117: command only operates on one diskgroup?

In this post, you’ll learn more about the Oracle ErrorORA-15117: command only operates on one diskgroup with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-15117: command only operates on one diskgroup

Reason for the Error ORA-15117: command only operates on one diskgroup

An ALTER DISKGROUP, CREATE DISKGROUP, or DROP DISKGROUP command specified a list of diskgroups or the keyword ALL in a context where only a single diskgroup was permitted.

How to fix the Error ORA-15117: command only operates on one diskgroup ?

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

Issue separate ALTER DISKGROUP, CREATE DISKGROUP, or DROP DISKGROUP commands to accomplish the desired action.