ORA-06598: insufficient INHERIT PRIVILEGES privilege

Sql Extract failed with below error

BEGIN SQLTXADMIN.sqlt$i.xtract(p_statement_id => :v_statement_id, p_sql_id_or_hash_value => '1avsfmn7dd549', p_password => 'Y'); END;

*
ERROR at line 1:
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "SQLTXADMIN.SQLT$I", line 1
ORA-06512: at line 1

Solution:

To address this change SQLTXADMIN and SQLTXPLAIN needs to be granted INHERIT PRIVILEGES on SYS.

Connect AS SYSDBA and run the following sql statement to add the necessary grant:

GRANT INHERIT PRIVILEGES ON USER SYS TO SQLTXADMIN;
GRANT INHERIT PRIVILEGES ON USER SYS TO SQLTXPLAIN;