Oracle Error ORA-32029: resetting with SCOPE=MEMORY or SCOPE=BOTH is currently not supported

Oracle Error Message

ORA-32029: resetting with SCOPE=MEMORY or SCOPE=BOTH is currently not supported

Reason for the Error

An attempt was made to reset an in-memory parameter value

Solution

Specify SCOPE=SPFILE if applicable, or explicitly set the parameter to the desired value