RE: [Problem connecting from JDBC]

From: Ravindra Basavaraja <ravindra_at_sentica.com>
Date: Wed, 10 Jan 2001 21:00:41 -0800
Message-Id: <10737.126365@fatcity.com>

the database is running as MTS.
The listener has just an entry for the listening port address and the SID_LIST entries.

It doesnot haev an entry for conection idle time in the listener. Should i set this parameter.

How can i chck for max connection.The JDBC dbcondif.dat file has an entry for Max connection as 5...

Pls advice
ravindra

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of S Jayakumar Sent: Wednesday, January 10, 2001 2:41 PM To: Multiple recipients of list ORACLE-L Subject: Re: [Problem connecting from JDBC]

Please check the following ,

connection idle time in the listener ( if the connection seems to be hanging / disconnected after some time of idle ness )
Max connections . After max connections are established , it may not accept new connections. in this case U may use MTS

Hope this may help
Jay

"Ravindra basavaraja" <ravindra_at_sentica.com> wrote: We have a java application that connects to the database using JDBC.At some point
the java application cannot get connected to the database.

I was told to stop and start the listener.I dont' know if the listener is hanging.
After doing this the connection gets established.This happens everytime. But when the problem is happening I can still make a client connection from the Oracle
client on NT.If the listener was hanging then the Client connection wouldn't have got
conencted.

Can anyone tell me how to identify where the problem.I am the DBA and I think that
this is not a Listener problem but the developers are telling that this is a database
related problem as they don't face this problem when working on other databases.
This happens only with the testing database.

Thanks

Ravindra

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ravindra basavaraja
INET: ravindra_at_sentica.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

Get free email and a permanent address at http://www.netaddress.com/?N=1
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: S Jayakumar
INET: sjayakumar2000_at_usa.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message