Labels

algorithms (22) Design Patterns (20) java (19) linux (14) Snippet (13) service mix (6) soa (4)

ORA-01691: DEV_SOAINFRA.SYS_LOB

Internal Exception: java.sql.BatchUpdateException: ORA-01691: unable to extend lob segment DEV_SOAINFRA.SYS_LOB0000073615C00017$$ by 1024 in tablespace DEV_SOAINFRA

Error Code: 1691
    at oracle.integration.platform.instance.store.DOStore.put(DOStore.java:177)
    at oracle.integration.platform.instance.error.DOObjectExceptionHandler.recover(DOObjectExceptionHandler.java:41)
    at oracle.integration.platform.instance.error.FileBackedExceptionHandler.recover(FileBackedExceptionHandler.java:301)
    at oracle.integration.platform.instance.error.FileBackedExceptionHandler.run(FileBackedExceptionHandler.java:355)
    at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:106)
    at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:183)
    at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)
Caused by: Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.3.0) (Build 100323)): oracle.toplink.exceptions.DatabaseException

 

Solution

Increase the table space of DEV_SOAINFRA

  1. log in to oracle em web gui https://<hostname/ip>:1158/em
  2. click on server tab
  3. under storage –> select Tablespaces
  4. click on edit, then there is another edit click on it too
  5. and then you will get file size increase it appropriately.

image

1 comment:

  1. That's a great news who are using ipad. I am sure you are doing good job which will be very informative to me to know the discussion as well and sure the article must provide me the info to develop the ipad working because I am working with the ipad development.

    ReplyDelete

Search 24 Bytes