SQL Performance (MOSC)

MOSC Banner

Having error in SQLT installation in 19c PDB(ORA-06512: at "SYS.UTL_FILE", line 41)

edited Feb 24, 2021 3:45PM in SQL Performance (MOSC) 3 commentsAnswered ✓

All About the SQLT Diagnostic Tool ( Doc ID 215187.1 )

sqlt_instructions.html

Tried installing SQLT disanostic tools:

# sqlplus / as sysdba

SQL> START sqcreate.sql


I have uploaded the installation errror logs with the same.

We are seeing following error:

Test WRITING into file "tautltest.txt" in directory "TRCA$STAGE" started.

DECLARE

*

ERROR at line 1:

ORA-29280: invalid directory object

ORA-06512: at "SYS.UTL_FILE", line 41

ORA-06512: at "SYS.UTL_FILE", line 478

==================


On running sqltxtract:

SQL> START sqltxtract.sql 95qytwnh6z89x daTm45Rimt

BEGIN

*

ERROR at line 1:

ORA-20110: User "APPS" lacks required "SQLT_USER_ROLE" role or SQLT is not properly installed.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center