My Oracle Support Banner

EDQ Is Opening Files And Giving Error Of Too Many Database Open Files (Doc ID 3035603.1)

Last updated on JULY 22, 2024

Applies to:

Oracle Financial Services Customer Screening - Version 8.0.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.1.4.3 version, General

When attempting to execute job "Download, Prepare, Filter and Export All Lists", the following error occurs.

ERROR
-----------------------
SEVERE: 17-Jun-2024 10:40:40: [EDQ-06870] [job: Download, Prepare, Filter and Export All Lists:665][exid: 62][runlabel: 17_june_watch][ch0][EXPORT IDENTIFIER_JSON_Data:600]: job failed: error opening data provider or consumer
com.datanomic.director.runtime.data.WriterConfigurationException: There was a problem connecting to the external data store for export IDENTIFIER_JSON_Data: Could not connect to database: IO Error: Got minus one from a read call (Code: 2,010) (Code: 203,049)
at com.datanomic.director.exports.task.ExportWriter.(ExportWriter.java:293)
at com.datanomic.director.exports.task.ExportConsumer.getWriter(ExportConsumer.java:105)
at com.datanomic.director.exports.streaming.ExportStreamingConsumer.getWriter(ExportStreamingConsumer.java:110)
..........
SEVERE: 17-Jun-2024 10:42:17: [EDQ-01800] Error in database operation: ORA-01116: error in opening database file 88
ORA-01110: data file 88: '/u01/app/oracle/product/19.0.0/db_1/ora_data/DEV4_edq_conf.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 23: Too many open files in system
Additional information: 3
java.sql.SQLException: ORA-01116: error in opening database file 88
ORA-01110: data file 88: '/u01/app/oracle/product/19.0.0/db_1/ora_data/DEV4_edq_conf.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 23: Too many open files in system
Additional information: 3
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:457)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:452)
at oracle.jdbc.driver.T4C8TTILob.processError(T4C8TTILob.java:839)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8TTIClob.read(T4C8TTIClob.java:254)
..............


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. execute job "Download, Prepare, Filter and Export All Lists"

Changes

 NA

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.