Resolved General error: 1 Can't create/write to file '/var/tmp/#sql_677_0.MAI' (Errcode: 28), query was: DESCRIBE `sessions`I’m

[bonar]

I have some problems General error: 1 Can't create/write to file '/var/tmp/#sql_677_0.MAI' (Errcode: 28), query was: DESCRIBE `sessions`

 

[Peter Debik]

Could you please show the output of
# ls -lad /var/tmp
?

 

[bonar]

drwxrwxrwt. 67 root root 12288 Oct 3 20:10 /var/tmp

and then size 30 GB

 

[Peter Debik]

Permissions are correct, so I am not sure what causes this issue. Do you have enough space in /var/tmp to accomodate all temporary files?

 

[bonar]

Resolved my Inode full, after clear log on oradiag its work