Oracle Error Vendor Code 17410
ORA-17410: No more data to read fromsocket 2008/06/17 作者:Jesse Hu When using two JDBC connections accessing the same Oracle database, "SqlException : No more data to read from socket" thrown. This is because your database doesn’t support connection sharing, or it’s a dedicated server that will not respond to different clients. Solution 1: $ dbca -Configuration & Migration Tool ---database Configuration Assistant Select radio button --Configure Data base options in database Select your database--e.g. Oracle or pspl Select --- shared server mode Solution 2 (same to 1 but manual work): open $ORACLE_HOME/network/admin/tnsnames.ora change "(SERVER = DEDICATED)" to "(SERVER = SHARED)" restart database and listener Now your database is sharable, so we can use from different client. Thanks http://www.orafaq.com/forum/t/47457/0/ 赞过:赞 正在加载…… 相关 发表在 Oracle | Tagged database, Oracle | 5条评论 5条回应 于 2008/10/13 在 4:56 下午 | 回复 Mariam Thank you so much. This is helpful🙂 于 2009/08/10 在 1:48 下午 | 回复 Raja I am Getting the same error while i am connecting to Oracle 10g database from my Client machine and executing SQL Query through PL/SQL Developer Tool. I have tried executing the same Query through SQL*Plus and Toad also. The same error i am getting. I have browsed through Google for the Resolution, bit most of the sites says that, the error is due ti JDBC Client. Any Suggestions. 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 Many thanks ^_^ ! 于 2016/06/01 在 2:10 下午 | 回复 xiaojuya Thanks! It is very useful. Comments RSS 发表评论 取消回复 请在此输入您的评论... ... Fill in your details below or click an icon to log in: 电子邮件 (必填) (Address never made public) 姓名 (必填) 站点 You are commenting using your WordPress.com account. (LogOut/更改) You are commenting using your Twitter account. (LogOut/更改) You are commenting using your Facebook account. (LogOut/更改) You are commenting using your Google+ account. (LogOut/更改) 取消 Connecting to %s 有新评论时通过电子邮件通知我。 搜索: Blog Stats 140,093 hits My Bookmarks Tag Cloud11g adapter android apache CDL chef cloud_computing couchdb crontab database date Director DRCP escape firefox git HTML IBM idea java javascript jdbc keyless leap Li
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 3 Replies Latest reply on Sep 14, 2014 5:13 AM by SDCraig No more data to read from socket - Union Queries SDCraig Sep 14, 2014 4:08 AM All:I'm using ORACLE 11g XE, with SQL Developer 4.0.2.15. I have a number of queries that I UNION together. I'm getting the error message:An error was encountered https://jessehu.wordpress.com/2008/06/17/ora-17410-no-more-data-to-read-from-socket/ performing the requested operation:No more data to read from socketVendor code 17410The queries I'm running resemble something like this: "SELECT [FIELD1], [FIELD2], 1 "ID" FROM [SOMETABLE] WHERE [FIELD3] LIKE '%TERM1%' UNION "SELECT [FIELD1], [FIELD2], 2 "ID" FROM [SOMETABLE] WHERE [FIELD3] LIKE '%TERM2%' UNION "SELECT [FIELD1], [FIELD2], 3 "ID" FROM [SOMETABLE] WHERE CONTAINS([FIELD3], '?TERM3') > 0.....I'm running 10 at a time. Some groups of 10 work, others not, with no discernable difference in query https://community.oracle.com/thread/3607827 complexity. Each time I get the error message, I need to shut down and re-start the application.Is this a capacity issue? Not sure why that would be. I'm rather new to the ORACLE world. Multiple union queries work fine in SQL Express (I can run 300+ queries union'd together no problem). The reason I'm using ORACLE instead of SQL Express is that many of the queries include FUZZY matching functionality that I can't replicate in SQL (as exemplified in above example).Thanks for any all help. I have the same question Show 0 Likes(0) 620Views Tags: none (add) queryContent tagged with query, unionContent tagged with union, sql developerContent tagged with sql developer, oracle 11gContent tagged with oracle 11g This content has been marked as final. Show 3 replies 1. Re: No more data to read from socket - Union Queries sol.beach Sep 14, 2014 4:14 AM (in response to SDCraig) How can we reproduce what you report? Like Show 0 Likes(0) Actions 2. Re: No more data to read from socket - Union Queries SDCraig Sep 14, 2014 4:35 AM (in response to sol.beach) I'm not really sure. I have a table with 17,000 records. The field I'm querying is a text field that could contain values up to 3,000 characters. UPDATE: I just ran 300 union queries th
[Error Code: 17410, SQL State: null] No more data to read from socket [message #138779] http://www.orafaq.com/forum/t/52272/ Fri, 23 September 2005 10:41 rumn8tr Messages: 2Registered: September 2005 Junior http://www.dbforums.com/showthread.php?1647978-No-more-data-to-read-from-socket-in-ORACLE-11g Member Here is a strange situation...I have 2 databases that are both pointing to the same remote database. I have a query (run using ojdbc14.jar - although I don't think it is a java issue): select sum(x) as TOTAL from A, B, oracle error C.C@remote_db_connect C where C.pseudo_date_field = to_char(sysdate, 'mmyyyy') and A.key = C.field_a and B.field = C.field_b and A.key not in (1,2,3,4); A.key and C.field_a are both NUMBER(9) B.field and C.field_b are both VARCHAR2(25) C.pseudo_date_field is VARCHAR2(6) This query runs fine from Database 1. However, from Database 2, it comes down with Error Code: 17410, SQL oracle error vendor 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 = '092005', the query does run from database 2. I can run SELECT to_char(sysdate, 'mmyyyy') FROM dual; on all 3 databases and get the expected result. I have tried using the ojdbc14_g.jar files to generate a trace. The only differences I saw were: Quote: The DriverManager.getConnection is pointing to different databases (a given). The DBAC OPER DBItem.clone statements have different hash identifiers (also a given). 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 gets through 9 DBAC OPER DBItem.clone statements before the call to DRVR OPER OracleResultSetImpl.getMetaData() and PreProd gets through 9 DBAC OPER DBItem.clone statements before the error occurs. Due to the error, PreProd skips DRVR OPER OracleResultSetImpl.getMetaData(), DRVR OPER ResultSet.getBigDecimal(columnIndex=1), DRVR OPER OracleResultSetImpl.wasNull(), D
visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: No more data to read from socket in ORACLE 11g Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-19-09,04:55 #1 K.Sundaresan View Profile View Forum Posts Registered User Join Date Jul 2009 Posts 7 Unanswered: No more data to read from socket in ORACLE 11g Hi I am upgrading my database from 10 g to 11g after upgrading the database,while selecting the table[dbvisualizer] it shows error as [Error Code: 17410, SQL State: 08000] No more data to read from socket so i tried in sqlplus (cmd.exe) it shows ERROR at line 1: ORA-03113: end-of-file on communication channel Process ID: 5944 Session ID: 119 Serial number: 294 need help to solve this issue..., [Note : ORACLE Version : Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production OS : Windows XP NLS_DATE_FORMAT = 'yyyy-mm-dd hh24:mi:ss' NLS_COMP=ANSI NLS_SORT=BINARY_CI Reply With Quote 09-19-09,10:45 #2 anacedent View Profile View Forum Posts Registered User Join Date Aug 2003 Location Where the Surf Meets the Turf @Del Mar, CA Posts 7,776 Provided Answers: 1 I suspect that the upgrade is not complete. Can you connect to DB using sqlplus while logged onto DB server system? You can lead some folks to knowledge, but you can not make them think. The average person thinks he's above average! For most folks, they don't know, what they don't know. Good judgement comes from experience. Experience comes from bad judgement. Reply With Quote 09-19-09,11:21 #3 K.Sundaresan View Profile View Forum Posts Registered User Join Date Jul 2009 Posts 7 Ya, i connected to SQLPLUS username/password from cmd Reply With Quote 09-19-09,11:51 #4 anacedent View Profile View Forum Posts Registered User Join Date Aug 2003 Location Where the Surf Meets the Turf @Del Mar, CA Posts 7,776 Provided Answers: 1 If Oracle & sqlplus work, then problem is with the client s/w. You can lead some folks to knowledge, but you can not make them think.