Setting log_archive_trace=0 As SYS User Error With ORA-1031: Insufficient Privileges In 12.2 DB with Database Vault Enabled
Last updated on NOVEMBER 20, 2017
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
In 188.8.131.52 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 184.108.40.206 with database vault enabled.
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