I get the below error while generating sqltxtract and sqltxplain analysis with sqltxadmin user and my session got disconnected and kicked me out !
BEGIN SQLTXADMIN.sqlt$i.xtract(p_statement_id => :v_statement_id, p_sql_id_or_hash_value => '1rzgj3atcc8vd', 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
In case of a disconnect review log file in current directory If running as SYS in 12c make sure to review sqlt_instructions.html first Disconnected from Oracle Database 12c Enterprise Edition Release 22.214.171.124.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Solution: Ensure that you have connected to sqltxplain user and the sqlt users have following privileges to access the sqltx packages.
SQL>grant INHERIT ANY PRIVILEGES to sqltxadmin; Grant succeeded. SQL>grant INHERIT ANY PRIVILEGES to sqltxplain; Grant succeeded. SQL>grant SQLT_USER_ROLE to sqltxplain; Grant succeeded. SQL>grant SQLT_USER_ROLE to sqltxadmin; Grant succeeded. SQL> conn sqltxplain; Enter password: Connected. SQL> START sqltxtract.sql 1rzgj3atcc8vd