22 May, 2012

ORA-01691: unable to extend lob segment in Oracle UCM

Today every user complains from unable to upload files in Oracle Universal Content Management server.
After checking log file, I find below exception

Event generated by user 'sysadmin' at host '10.32.209.196'. Unable to save the file <undefined>. Unable to execute query 'IfileStorage'. ORA-01691: unable to extend lob segment UCM.SYS_LOB0000071911C00006$$ by 14 in tablespace UCM_TBS
java.sql.SQLException: ORA-01691: unable to extend lob segment UCM.SYS_LOB0000071911C00006$$ by 14 in tablespace UCM_TBS
 



From logging file the problems exists in database not application server, because table space of UCM repository is full space and can't be extended automatically by DBMS.

So I checked table space in database from dba_tablespaces data dictionary view, I find the empty size of table space data files is only one megabyte  and Auto Extend option of table space data files is disabled.
So I executed the below script and it solves the problem.

 ALTER DATABASE DATAFILE '/u01/app/oracle/oradata/TEST/UCM_TBS01.dbf'  
 AUTOEXTEND ON  
 NEXT 2048M  
 MAXSIZE UNLIMITED;  

Thanks
Mahmoud A. El-Sayed
Recommended Post Slide Out For Blogger