This ORA happens allways a lob segement cannot extended itself to fit the new data being inserted.
Tipical solution is extending the data file and adding a datafile, but sometimes, not often, error only apears in alert log (no client side) when space taken by the lob segment is allocated for reuse, before the undo retention period is expired.
Many times like all Oracle DBAs have face with this problem sometimes is easy avoid sometimes you discover for example that table have LOBS and this LOBs dont use the UNDO tablespace and datbase UNDO_RETENTION parameter and have his own paramter and stores undo on data tablespace.
This problem can cause a lot of waste time because it is more likely to occur when you are running long queries so the return to process them again will be a big waste of time.
Today in a multiple instance server i configured a new instance on Windows platform and i encounter next problem when i try connect from my laptop:
sqlplus / as sysdba
SQL*Plus: Release 220.127.116.11.0 – Production on Sun Aug 26 09:21:56 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ORA-12518: TNS:listener could not hand off client connection.