Installing SQLT fails with ORA-29283: invalid file operation
(Doc ID 1362270.1)
Last updated on FEBRUARY 22, 2023
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;
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
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
| Symptoms |
| Cause |
| Solution |
| References |