My Oracle Support Banner

FAQ: Common SQLT (SQLTXPLAIN) Runtime/Installation Errors (Doc ID 1670677.1)

Last updated on OCTOBER 30, 2019

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This document answers some of the frequently encountered Runtime/Installation Errors that you may receive when setting up SQLTXPLAIN (SQLT) .
For other frequently asked questions, see the SQLT FAQ document:

<Document 1454160.1> FAQ: SQLT (SQLTXPLAIN) Frequently Asked Questions


You can download the latest version of SQLT here:

<Document 215187.1> SQLT (SQLTXPLAIN) - Tool That Helps To Diagnose SQL Statements Performing Poorly

 

NOTE: To simply perform a Health Check on your SQL environment that leaves no database footprint,  see:

<Document 1366133.1> SQL Tuning Health-Check Script (SQLHC)

Ask Questions, Get Help, And Share Your Experiences With SQLT

Would you like to explore SQLT further with other Oracle Customers, Oracle Employees, and Industry Experts?

We have various threads available where you can ask questions, get help from others, and share your experiences with SQLTXPLAIN:

SQLTXPLAIN: SQLT Installation Issues
SQLTXPLAIN: Dealing with Long Execution Times
SQLTXPLAIN: Dealing with Errors reported in SQLT MAIN report
SQLTXPLAIN: Using SQLT on a Stand-by or Dataguard
SQLTXPLAIN: Interpreting and Understanding SQLT Output

SQLTXPLAIN (SQLT): General Discussion

Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Tuning.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
 Ask Questions, Get Help, And Share Your Experiences With SQLT
Questions and Answers
 SQLT Runtime/Installation Errors
 I am receiving unexpected SQLT Installation errors, what should I do?
 I am receiving unexpected SQLT Runtime errors, what should I do?
 SQLT Runtime gives: "ORA-04063: package body "SQLTXADMIN.SQLT$T" has errors" / "ORA-06508: PL/SQL: could not find program unit being called: "SQLTXADMIN.SQLT$T"
 I receive "ORA-01924: role 'SQLT_USER_ROLE' not granted or does not exist"
 Sqltxtract.sql fails with "ORA-20110: User lacks required "SQLT_USER_ROLE" role or SQLT is not properly installed".
 I receive "ORA-00942: table or view does not exist" during SQLT install
 I see PLS-00201 and ORA-00904 errors in the Log
 Receive INVALID PACKAGE BODY and ORA-20110 (Invalid libraries) Error during SQLT Installation".
 During a 10g install, I receive "PLS-00920: parameter plsql_native_library_dir is not set" during SQLT install
 During SQLT Installation, I see "PL/SQL: ORA-00904: "NOTES": invalid identifier" Error
 During SQLT Installation, I receive ora-3113/3114 errors, what should I do?
 While Executing SQLT, Installation, I receive export errors EXP-00006 and EXP-00000
 While Executing SQLT, Installation, I receive ORA-20110: Invalid libraries: 4. Review sqcpkg.log

 How to Generate a SQLT of a SQL Statement That Hangs or Raises an Error
 Discuss SQLT!
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.