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

Last updated on JULY 02, 2022

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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
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

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

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

How to deal with invalid packages

How to deal with error attempting to install SQLT tool into a PDB

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