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 220.127.116.11 and later
Information in this document applies to any platform.
In 18.104.22.168 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 22.214.171.124 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!