Re: ioexception: end of tns data channel

• post for FREE via your newsreader at post.newsfeed.com ***

curwen wrote:
> Hi all,
>
> SCENARIO:
> - oracle 9i RAC installation on linux RedHat
> - java swing application using Jsdk1.4.2_06 deployed on HP machine,
> both resident on the same LAN.
> the application cycle on polling on another windows machine via FTP
> and save records on oracle
> - oracle JDBC driver used : ojdbc14-10-1-0-1-0.jar
>
> after a quite long period the application is running
> we are experiencing the following exception :
> -------------------
> Stack: java.sql.SQLException: IOException: End of TNS data channel
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
> at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:418)
> at

oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:193)
> ...
> -------------------
>
> the oracle client memory usage keep increasing, from 80M up to 200,
> the typically the exception raise up
>
>
> does anybody have any clue?
> thanks in advance
> vl

Are you running Oracle in server shared mode ? - check how many circuits   is in use and how many is max setup on your server. How many sessions you have from the application server and how many is enabled ?

The java application may use very bad optimized query in one of statements, or some code stack in endless loop. (it's just my speculation).

-AST  -----= Posted via Newsfeed.Com, Uncensored Usenet News =----- http://www.newsfeed.com - The #1 Newsgroup Service in the World! -----== 100,000 Groups! - 19 Servers! - Unlimited Download! =-----                    Received on Sat Aug 21 2004 - 18:04:58 CDT