File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

init.ora parameter HELP

 
Rama Ituarte
Ranch Hand
Posts: 62
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ok, am not a database guy, but am having a problem with a parameter in my init.ora file. The parameter is QUERY_REWRITE_ENABLED. If I set it to true, which I need so oracle knows about hints. I get this error: java.sql.SQLException: No more data to read from socket
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:933)
at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java, Compiled Code)
at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java, Compiled Code)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java, Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java, Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java, Compiled Code)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java, Compiled Code)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java, Compiled Code)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java, Compiled Code)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:395)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:446)
Compiled Code)
I have downloaded the latest JDBC drivers, and that didn�t help.
Help is greatly appreciated!
Rama Ituarte
 
Beksy Kurian
Ranch Hand
Posts: 254
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you sure that it is because of that init.ora parameter. It looks like it has something to do with the connection. Is the connection getting closed in between? What is the JDBC driver you are using and what is the database version?
Regards
Beksy
[ September 18, 2002: Message edited by: Beksy Kurian ]
 
Rama Ituarte
Ranch Hand
Posts: 62
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The drivers are the latest drivers that Oracle has out thier. The DB version is 8.1.7.
Thanks for you reply.
It make no sense that when I take out this parameter the call to the function works fine.
 
Mike Curwen
Ranch Hand
Posts: 3695
IntelliJ IDE Java Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How about this?
Bug 1528882 Fixed: 8.1.7.1
Hangs / Spins
High parse times are possible for queries with long OR chains if
query_rewrite_enabled is set to true.


Perhaps this is happening, and your query times out?
 
Beksy Kurian
Ranch Hand
Posts: 254
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That could be right!
I tried to test this with my 8.1.7.4 (installed the 8.1.7.4 patch set yesterday) database (which has bfiles) and couldn't duplicate the problem.
Regards
Beksy
 
Rama Ituarte
Ranch Hand
Posts: 62
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, I ended up creating a TAR with Oracle. Their solution was to upgrade to 8.1.7.4. Thanks for the input guys.
Rama Ituarte
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic