Tuesday, March 11, 2014

How to fix the error ORA-01691: unable to extend lob segment

For the error like this 
org.jboss.soa.esb.services.persistence.MessageStoreException: java.sql.SQLException: ORA-01691: unable to extend lob segment
SAO.SYS_LOB0000049247C00003$$ by 1024 in tablespace SYSTEM

        at org.jboss.internal.soa.esb.persistence.format.db.DBMessageStoreImpl.addMessage(DBMessageStoreImpl.java:100)
        at org.jboss.soa.esb.actions.MessagePersister.process(MessagePersister.java:72)
        at org.jboss.soa.esb.listeners.message.ActionProcessingPipeline.processPipeline(ActionProcessingPipeline.java:649)
        at org.jboss.soa.esb.listeners.message.ActionProcessingPipeline.processPipeline(ActionProcessingPipeline.java:603)
        at org.jboss.soa.esb.listeners.message.ActionProcessingPipeline.process(ActionProcessingPipeline.java:433)
        at org.jboss.soa.esb.listeners.message.MessageAwareListener$TransactionalRunner.run(MessageAwareListener.java:550)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
        at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: ORA-01691: unable to extend lob segment SAO.SYS_LOB0000049247C00003$$ by 1024 in tablespace
SYSTEM

Following these steps
SQL> select * from dba_tablespace_usage_metrics order by used_percent desc;

use the file location from the below SQL to the ALTER database
SQL> select dbms_metadata.get_ddl('TABLESPACE','SYSTEM') from dual;

SQL> ALTER DATABASE
  2  DATAFILE '/u01/app/oracle/oradata/XE/system.dbf'
  3  RESIZE 256M;
  
SQL> select * from dba_tablespace_usage_metrics order by used_percent desc;

No comments:

Post a Comment