Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-31997

APPEND option only valid with scope=memory or scope=spfile

Cause

The ALTER SYSTEM SET command was issued with an invalid combination of options.


Action

If the parameter needs to be set in both spfile and memory, then reissue ALTER SYSTEM SET ... APPEND with scope=spfile and scope=memory specified separately. In order to use the APPEND option, the scope must be specified, and scope=both is invalid. For example: ALTER SYSTEM SET '_fix_control'='33423456:1' APPEND scope=memory;