Oracle-L: RE: Networking problem

From: John Hallas <john.hallas_at_hcresources.co.uk>
Date: Sun, 02 Jun 2002 01:53:21 -0800
Message-ID: <F001.00471E63.20020602015321@fatcity.com>

Just a couple of thoughts to try and narrow the problem down.

Have you tried a single client to the 8.1.7 database and then to the 9.2 database. If so then is it disconnecting from both or just the 9i one. That would be a test worth trying as you are then focusing on the database rather than a client problem if it only disconnected from the 9i system. From what you are saying I am guessing that is the likely cause anyhow.
Does the 9i system have any sort of profile set up for the accounts that you are connecting to that will disconnect on excess activity (cpu used etc ). I suppose that could be another test - try 2 connections to different accounts (say system and a standard user one) and see if they both fail or just the standard user – again looking like a profile type setting

HTH John

-----Original Message-----
Sent: 31 May 2002 23:14
To: Multiple recipients of list ORACLE-L

Hello list,
I am having trouble with clients losing their connections to a 9.2 database. We have a Solaris 7 box running 8.1.7 and 9.2.0 and the clients that connect to this box will lose the connection to the 9.2.0 database after about 20 minutes. The
connection to the 8.1.7 database has no problems. The client software is 9.2, 8.1.7
and 8.1.5 and they all behave the same way. The listener on the server is 9.2.0.
Now here's the kicker.... I have another server set up the "same" way with a 9.2
database and I don't lose that connection. I have just started tracing in the hopes it will point to something but I thought
I would throw this out to everyone for ideas Thanks
Steve

--

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

Author: John Hallas
INET: john.hallas_at_hcresources.co.uk

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). Received on Sun Jun 02 2002 - 04:53:21 CDT