JDBC Connection Refused to 10g on Solaris 8

From: Tim Smith (timasmith_at_hotmail.com)
Date: 05/28/04

  • Next message: jackie: "Re: Oracle Connection Pooling" 
    Date: 27 May 2004 20:33:29 -0700

    Hi,

    Not sure where the problem is but I have a new demo Solaris 8 Sparc
    Blade 480 server, on which I installed Oracle 10g.

    I have 4 PCs spawning 15 threads each with a couple of database
    connections (each) and I watch the Oracle select count(*) from
    v$session run up to 110 or so before suddenly the JDBC connections
    fail, saying tns listener refused the connection.

    I cant find anything exciting in the listener.log and the database
    sessions max is set to 1000. I tried prespawning threads and cant see
    anything for max processes on the Solaris and I am at my wits end.

    I had upgraded to classes12.jar for 10g from otn.oracle.com and I am
    using Java 1.4. I never had a problem against the old Oracle 8.0.5
    databases for the same code/JDBC connections.

    Does anyone have any idea why connections would be refused once they
    become numerous??

    thanks!

    Tim

  • Next message: jackie: "Re: Oracle Connection Pooling"

    Relevant Pages

    • JDBC Connection Refused to 10g on Solaris 8
      ... Not sure where the problem is but I have a new demo Solaris 8 Sparc ... on which I installed Oracle 10g. ... v$session run up to 110 or so before suddenly the JDBC connections ... I cant find anything exciting in the listener.log and the database ...
      (comp.unix.solaris)
    • Re: ORA-12518, 04030 errors after 9i-10G upgrade.
      ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... out of process memory errors. ... that Oracle is having issues with OS resources. ...
      (comp.databases.oracle.server)
    • ADO.Net Connection Pooling Problem with Oracle
      ... with running out of database connections. ... the number of database sessions in Oracle seem to ... in Oracle from 150 to 300, but we're coming pretty close to this limit. ... database connections everywhere they're used. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Limitation of Oracle XE
      ... What is the maximum number connection of Oracle XE? ... affect how many users can access the database concurrently and, ... connections is operating system dependent. ... operating systems, including Windows NT 4, Windows 2000, and Windows XP ...
      (comp.databases.oracle.server)
    • Re: Effect of listener on existing connections?
      ... Oracle support is not giving us satisfactory results. ... and attempts to create new connections are ... We also see these messages appearing with regularity in our listener ... how does a blocked listener explain the fact that apps with existing ...
      (comp.databases.oracle.server)