My Oracle Support Banner

Veridata Compare Fails Failed : java.io.IOException: Too many open files (Doc ID 2923578.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version 10.4.0.132 to 10.0.0.2 [Release 10.4.0 to 10.0.0]
Information in this document applies to any platform.

Symptoms

 
Starting Veridata Agent session for target rowhash at 2023-01-01 05:15:23.

rowhash target Agent Information:
Version: 12.2.1.4.220831
Java version: 1.8.0_221
SSL enabled: false
JDBC URL: jdbc:oracle:thin:@//.com:1521/fsfgffe
Session ID: 1876
SortNull: high
RepairSupported: true
RepairDupRecordsSupported: true
Database version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
Database driver(s): ojdbc8.jar
Driver version: 19.15.0.0.0
NLS_CHARACTERSET: AL32UTF8

Performance Statistics for Source Rowhash at 2023-01-01 05:15:44.

rows : 1208647
duration (secs) : 00:00:20
rows/sec : 58513
row bytes : 851388757
row bytes/sec : 41217503
bytes/row : 704
rows skipped : 0
blocks skipped : 0
time fetching : 00:00:14
time until first row: 00:00:05
ipc msgs : 171
ipc bytes : 87040131
bytes/msg : 508903
compressed bytes/msg: 147684
compressed bytes/sec: 1222599
compression ratio : 0.29

2023-01-01 05:15:44 Initial Compare Error message:Side-Target:java.io.IOException: Too many open files

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
Cause
Solution


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