Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Continuous growth of our soainfra : Internal Exception: java.sql.SQLException: ORA-01653: unable t

SanaeOct 17 2019 — edited Jan 28 2020

Hello,

I have a problem in our production environement

After the upgrade of our SOA infra from 12.1 to 12.2.3 , the automatic purge didn't work

The support recommended to us to disable the constraint and restart the domain again , and that suppose be work after ..But it's not the case

That why , we do the purge of all the SOA composites using the soa.delete_instances and for Recovery instances , we delete them from the EM console

Th eproblem is that the Data files in out SOA_INFRA database still increase day after day , now we are at 89,87%

Before the database team added a new data files , we had the error below in our SOA composites :

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLException: ORA-01653: unable to extend table INTPOAPRD1_SOAINFRA.CUBE_SCOPE by 8192 in tablespace INTPOAPRD1_SOAINFRA

Any solutions , to how reduce the continuous growth of the soainfra databse , please ?

Thanks ,

Best Regards ,

Sanae

This post has been answered by Martien van den Akker on Oct 21 2019

Jump to Answer

Added on Oct 17 2019

#soa-process-management, #soa-suite-discusssions

5 comments

234 views