An "ORA-17410: No More Data to Read From Socket" Error Has Been Signaled From An ODI Integration Interface [ID 423982.1] Symptoms When using Oracle Data Integrator (ODI) to extract data from an Oracle database, after 17000 rows the extraction process interrupts and the following error is signaled: 17410 : null : java.sql.SQLException: No more data to read from socketCause The ORA-17410 error which is generally associated to Oracle connectivity issues (Oracle server and JDBC driver) indicates that the JDBC driver is waiting indefinitely for data on the established connection. Possible causes: 1.A temporary problem on your host (a process was inappropriately killed, a timeout was detected, a data transfer operation was interrupted...). 2.Inappropriate version of the JDBC driver; the JDBC driver does not match the Oracle database version. 3.May also be due to some inappropriate characteristics of the data that is being processed (LOB fields, multiple columns...). Solution Points to verify. 1.Check the Oracle Server's 'alert.log' file. The ORA-17410 error may be associated to an Oracle Server or Listener problem (errors ORA-600, ORA-7445...). 2.Increase the SQLNET.EXPIRE_TIME (or set it to 0) in the Oracle server's 'sqlnet.ora' configuration file. 3.Verify the version of the installed JDBC driver according to Note 423733.1 Best Practices For Oracle JDBC Drivers 4.If the error occurs on Oracle Data Integrator (ODI) Metadata Navigator, after having restarted the Oracle Database and/or the Oracle Listener, then:◦either use at least version 3.2.03.33 of Repository Explorer◦either restart the Application Server (Tomcat, OC4J...) after having restarted the Oracle Database and/or Oracle Listener.
你可以查查user的profile有没有这样的限制 select * from user_resource_limits
An "ORA-17410: No More Data to Read From Socket" Error Has Been Signaled From An ODI Integration Interface [ID 423982.1] Symptoms
When using Oracle Data Integrator (ODI) to extract data from an Oracle database, after 17000 rows the extraction process interrupts and the following error is signaled: 17410 : null : java.sql.SQLException: No more data to read from socketCause
The ORA-17410 error which is generally associated to Oracle connectivity issues (Oracle server and JDBC driver) indicates that the JDBC driver is waiting indefinitely for data on the established connection. Possible causes:
1.A temporary problem on your host (a process was inappropriately killed, a timeout was detected, a data transfer operation was interrupted...).
2.Inappropriate version of the JDBC driver; the JDBC driver does not match the Oracle database version.
3.May also be due to some inappropriate characteristics of the data that is being processed (LOB fields, multiple columns...).
Solution
Points to verify.
1.Check the Oracle Server's 'alert.log' file. The ORA-17410 error may be associated to an Oracle Server or Listener problem (errors ORA-600, ORA-7445...).
2.Increase the SQLNET.EXPIRE_TIME (or set it to 0) in the Oracle server's 'sqlnet.ora' configuration file.
3.Verify the version of the installed JDBC driver according to Note 423733.1 Best Practices For Oracle JDBC Drivers
4.If the error occurs on Oracle Data Integrator (ODI) Metadata Navigator, after having restarted the Oracle Database and/or the Oracle Listener, then:◦either use at least version 3.2.03.33 of Repository Explorer◦either restart the Application Server (Tomcat, OC4J...) after having restarted the Oracle Database and/or Oracle Listener.
select * from user_resource_limits