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.
Thanks
Mahmoud A. El-Sayed
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
To solve this problem I increased size of data file used in table space.
ReplyDeleteYou can also add new data file to table space and it will solve the problem too.
Hi Mahmoud,
ReplyDeletePersonally, I don't think it is a good idea to do MAXSIZE unlimited. It's a matter of choice I guess ...