Oracle Solution for Error ora-29954

ORA-29954: domain index partition is marked LOADING/FAILED/UNUSABLE

What triggered the Error:

An attempt has been made to access a domain index that is being built or is marked failed by an unsuccessful DDL or is marked unusable by a DDL operation.

What should we do to fix it:

Wait if the specified index partition is marked LOADING Rebuild the specified index partition if it is marked FAILED or UNUSABLE.