Installing SQLT fails with ORA-29283: invalid file operation (Doc ID 1362270.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Application Object Library - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

When running the install program for SQLT, as described in <Note 215187.1> "SQLT (SQLTXPLAIN) - Tool That Helps To Diagnose SQL Statements Performing Poorly" the script fails with the following error stack:

SQLT$STAGE: write test file tasqdirset.txt
tasqdirset.open_write_close: ORA-29283: invalid file operation
ORA-06512: at
"SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
SQLT$STAGE: created
SQLT$STAGE: READ,WRITE access granted to SQLTXPLAIN
SQLT$STAGE: READ,WRITE access granted to SQLT_USER_ROLE
SQLT$STAGE: write test file tasqdirset.txt
tasqdirset.open_write_close: ORA-29283: invalid file operation
ORA-06512: at
"SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
BEGIN tasqdirset; END;

*
ERROR at line 1:
ORA-20102: SQLT$STAGE: not capable of reading or writing.
ORA-06512: at "SYS.TASQDIRSET", line 236
ORA-06512: at "SYS.TASQDIRSET", line 251
ORA-06512: at "SYS.TASQDIRSET", line 309
ORA-06512: at line 1

 

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms