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;
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