Yesterday a colegue asked me about “enq: TT – contention” event on his session that is adding a a datafile in a tablespace wich run out of space in a 18.104.22.168 Database.
I’ve faced this situation another time and decided to document it.
Oracle refer Bug 8332021 : CANNOT ADD A DF WHEN SESSIONS ARE REPORTING ORA-1653 ON 22.214.171.124 for this situation.
The pointing solutions are:
– “Apply Patch 8332021”
– “Alternatively, you can upgrade to 126.96.36.199 or higher as the patch is included in the 188.8.131.52 patch set.”
The not documented workaround (just for you, by Matheus :D) is:
– Cancel session adding datafile.
– Extend any datafile to resume sessions waiting (in resumable state).
– Readd datafile.
This extend action relieves the blocks and will allow you to add the datafile.