SQL Performance (MOSC)

MOSC Banner

sys.sqlt$_trca$_dir_set.open_write_close: ORA-29283: invalid file operation

edited Jul 26, 2016 5:02AM in SQL Performance (MOSC) 2 commentsAnswered

Hi Folks,

I have successfully installed sqlt, I am getting the below errors while running sqlt for a sql_id.

SQLT$STAGE: write test file tasqdirset.txt

sys.sqlt$_trca$_dir_set.open_write_close: ORA-29283: invalid file operation

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

ORA-29283: invalid file operation

SQLT$STAGE: created

-> ORA-01927: cannot REVOKE privileges you did not grant

-> SQLT$STAGE: READ,WRITE access not revoked from SQLTXPLAIN due to error above (ignore this error)

SQLT$STAGE: READ,WRITE access granted to SQLTXADMIN

SQLT$STAGE: READ,WRITE access granted to SQLT_USER_ROLE

SQLT$STAGE: write test file tasqdirset.txt

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