Setting log_archive_trace=0 As SYS User Error With ORA-1031: Insufficient Privileges In 12.2 DB with Database Vault Enabled

(Doc ID 2329553.1)

Last updated on NOVEMBER 20, 2017

Applies to:

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

Symptoms

In 12.2.0.2 DB with database vault enabled. Modifying parameter log_archive_trace as sys users results in ora-01031.  Even with dvowner the parameter setting fails.

 

The same change of parameter works in 11g DB with Database vault as sys user.

 


Error message in DB:


SQL> alter system set log_archive_trace=0 scope=spfile sid='*';
alter system set log_archive_trace=0 scope=spfile sid='*'
*
ERROR at line 1:
ORA-01031: insufficient privileges

Changes

 No changes. The database is currently 12.2.0.2 with database vault enabled.

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