My Oracle Support Banner

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 AUGUST 04, 2018

Applies to:

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


In 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


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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.