ORA-20110 WHILE EXECUTING SQLT

While execution SQLT - 

SQL> START sqcreate.sql

INVALID PACKAGE BODY 12.2.171004 OSQLT$A

ERROR at line 1:
ORA-20110: Invalid libraries: 1. Review sqcpkg.log.
ORA-06512: at line 11

sqcpkg.log shows below error:

 LINE/COL ERROR

——– —————————————————————–
6941/5   PL/SQL: Statement ignored
6941/5   PLS-00201: identifier ‘SYS.DBMS_ADVISOR’ must be declared
6944/5   PL/SQL: Statement ignored
6944/5   PLS-00201: identifier ‘SYS.DBMS_ADVISOR’ must be declared
6945/5   PL/SQL: Statement ignored
6945/5   PLS-00201: identifier ‘SYS.DBMS_ADVISOR’ must be declared
6948/5   PL/SQL: Statement ignored
6948/5   PLS-00201: identifier ‘SYS.DBMS_ADVISOR’ must be declared
6951/5   PL/SQL: Statement ignored
6951/5   PLS-00201: identifier ‘SYS.DBMS_ADVISOR’ must be declared
6954/5   PL/SQL: Statement ignored
6954/5   PLS-00201: identifier ‘SYS.DBMS_ADVISOR’ must be declared
SQL> —
SQL> SET TERM ON ECHO OFF;
… creating package body for SQLT$C
SQL> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$c;
No errors.
SQL> —
SQL> SET TERM ON ECHO OFF;
… creating package body for SQLT$D

Solution:

1.    Grant execute privilege on DBMS_ADVISOR

grant execute on SYS.DBMS_ADVISOR to SQLTXPLAIN;

2. Recompile invalid objects of SQLTXADMIN

alter package SQLTXADMIN.SQLT$A compile body ;