Thanks Tamil.

db_files is set to 1500 and temp tablespace has 10 temp files and it is trying to write to file number 9.