ORA-1031 Executing ALTER SYSTEM On Logical Standby

(Doc ID 1432914.1)

Last updated on MAY 27, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

On a logical standby database, the 'ALTER SYSTEM' commands executed by non-sysdba users fail with ORA-1031 error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms