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

2 comments:

  1. To solve this problem I increased size of data file used in table space.
    You can also add new data file to table space and it will solve the problem too.

    ReplyDelete
  2. Hi Mahmoud,

    Personally, I don't think it is a good idea to do MAXSIZE unlimited. It's a matter of choice I guess ...

    ReplyDelete

ADF : Scope Variables

Oracle ADF uses many variables and each variable has a scope. There are five scopes in ADF (Application, Request, Session, View and PageFl...