Having error in SQLT installation in 19c PDB(ORA-06512: at "SYS.UTL_FILE", line 41)
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.