Raja 于 2012/11/24 在 7:23 上午 | 回复 Richard If you are using java this might helo you: java/jdk1.6.0_31/jre/lib/security/java.security change securerandom.source=file:/dev/urandom to securerandom.source=file:///dev/urandom 于 2016/01/05 在 12:25 上午 | 回复 Fadoua Vertical align top in multicolumn When stating a theorem in textbook, use the word "For all" or "Let"? All legitimate Oracle experts publish their Oracle qualifications. Problems with "+" in grep (Possibly Easy) Formal Language Question Looking for a term like "fundamentalism", but without a religious connotation Simulate keystrokes Does the string "...CATCAT..." appear in the DNA

The " No more data to read from socket" and the alert log specifies "Address not mapped to object"... Main protagonist is the son of a blacksmith I don't want to get lung cancer like you do Is my boss being unreasonable or am I? How to say “let's” in Portuguese? Forum New Posts Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders dBforums Database Server Software Oracle No more data to read from socket in ORACLE

This is the accepted answer. On the other hand, maybe this condition is somehow triggering the error? –Colin 't Hart Jun 5 '14 at 13:36 add a comment| 2 Answers 2 active oldest votes up vote I can run SELECT to_char(sysdate, 'mmyyyy') FROM dual; on all 3 databases and get the expected result. I don?t have exact >> idea on this error, does any one have idea on this.. >> Currently the web sphere using oracle JDBC thin driver adapter 9.2 .. >> >>

Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 23 Exception stack trace follows: >> javax.transaction.xa.XAException >> >> Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: No more >> data to read from socketDSRA0010E: SQL State = null, Error Code = 17,410 >> >> > > You can lead some folks to knowledge, but you can not make them think. We have the same problem executing the query on different client (dbvisualizer, squirrel) and on oracle console.

SystemAdmin 110000D4XK ‏2007-08-28T14:43:34Z [email protected] wrote: > I am receiving this error often in web sphere logs. I don?t have exact idea on this error, does any one have idea on this.. > Currently the web sphere using oracle JDBC thin driver adapter 9.2 .. > > 8/27/07 So, try restarting your application server if applicable. Thanks in advance for your help.

Caused by: java.sql.SQLRecoverableException: No more data to read from socket at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1142) at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1099) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:288) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) at Database 1 returns 2 more columns than Database 2 for the statement - SELECT username AS table_schem FROM all_users ORDER BY table_schem On the call with the to_char(sysdate, 'mmyyyy') call, Prod Exception stack trace follows: javax.transaction.xa.XAException Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: No more data to read from socketDSRA0010E: SQL State = null, Error Code = 17,410 Log in to reply. However, from Database 2, it comes down with Error Code: 17410, SQL State: null - No more data to read from socket If you replace C.pseudo_date_field = to_char(sysdate, 'mmyyyy') with C.pseudo_date_field

Also 'I tried starting the DB service ... The only information that I saw regarding 17410 errors had to do with LOB/CLOBs in my Google search (and that doesn't make any sense). Join them; it only takes a minute: Sign up No more data to read from socket error up vote 27 down vote favorite 12 We are using Oracle as the database Experience comes from bad judgement.

Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the Crystal balls have since long been sold out here. The error is attributed to the Oracle DB server failing and glassfish does not recover. I get this error intermittently in JDBC.

I have tried updating to the latest ojdbc14.jar file from Oracle (10.2.0.1.0) and have tried both oracle.jdbc.driver.OracleDriver and oracle.jdbc.OracleDriver. The application runs well most of the time, but we get this "No more data to read from socket" error. The no more data from socket error can also mean that the shadow process crashed, often with an ORA-00600 or ORA-07445 error. For most folks, they don't know, what they don't know.

If you are using Java this might help you: In java/jdk1.6.0_31/jre/lib/security/Java.security change securerandom.source=file:/dev/urandom to securerandom.source=file:///dev/urandom share|improve this answer edited Nov 23 '12 at 23:46 Peter O. 16.1k74862 answered Nov 23 '12 I'm hoping that someone here has an idea. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count). This is likely a bug See this : https://blogs.oracle.com/db/entry/ora-600_troubleshooting share|improve this answer answered Nov 9 '11 at 17:57 sensware 711 add a comment| up vote 0 down vote For future googlers,

This is the accepted answer. Good judgement comes from experience. How common is it to have a demo at a doctoral thesis defence session? Oracle FAQ Your Portal to the Oracle Knowledge Grid HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US Home -> Community -> Usenet -> c.d.o.server -> Error

Looking for a term like "fundamentalism", but without a religious connotation Unix command that immediately returns a particular return code?

Cheers Like Show 0 Likes(0) Actions 6. Like Show 0 Likes(0) Actions 13. Thanks in advance..!! I'm running this on Mac (as well as you, I assume) bpg added a commit to bpg/akka-persistence-jdbc that referenced this issue Jan 23, 2015 bpg

Just to explain that situation.. You can check this link Maybe this helps someone. You signed out in another tab or window. The average person thinks he's above average! step1: open $ORACLE_HOME/network/admin/tnsnames.orastep 2: change "(SERVER = DEDICATED)" to "(SERVER = SHARED)"step 3: bounce Oracle and the listener See MOSC Article ID 1083922.1 Article ID 423982.1 for more troubleshooting details on Like Show 0 Likes(0) Actions 1 2 Previous Next Go to original post Actions Incoming ...

We really need some help to catch the error location!! Post Reply Bookmark Topic Watch Topic New Topic Similar Threads java.sql.SQLException: No more data to read from socket Connection to database Exception Oracle.JDBC Connection Problem SQLException : The Network Adapter could Install Setup not working How do I input n repetitions of a digit in bash, interactively Should I serve jury duty when I have no respect for the judge? The average person thinks he's above average! Wendy Gibbon...

I've seen cases where the database gets confused enough that a particular SPID gets hung and has to be killed. org.springframework.jdbc.UncategorizedSQLException : Hibernate operation: could not execute query; uncategorized SQLException for SQL [sql removed] SQL state [null]; error code [17410]; No more data to read from socket; nested exception is java.sql.SQLException: Oracle Training from Don Burleson The best on site "Oracle training classes" are just a phone call away! private long delay...