Re: Could only connect via SVRMGR

From: jiang <jiangxph_at_public.wh.hb.cn>
Date: Sat, 10 Mar 2001 07:12:19 -0800
Message-ID: <F001.002C8F19.20010310065022@fatcity.com>

This week we had the similar problem. The database (AIX 4.2 running Oracle 7.3.4) couldn't allow any new connections. But those already were fine. I could sqlplus from server. The number of user processes hadn't approached max processes we often had. The listener log was normal.

I called Oracle support service. It was busy. Then I called an IBM senior engineer. He told me Oracle always had this problem in its listener. So I killed the process of listener and re-startup it. It was OK. Afterwards I called Oracle. They told me they know the bug. But they gave me suggestion also was to kill the process.

Jiang

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, January 10, 2001 9:15 PM

Had fun this morning where our most critical plant database would not allow new connections, but those already in were running just fine. I had a similar issue a couple months ago where moving the tnsnames file into the BIN directory solved the problem (I still don't know why!), but that wasn't the case this time.

I could tnsping the db but SQLPlus would hang from my desk. From the server, I could connect internal via svrmgr, but SQLPlus would still just hang using sys. I ended up crossing my fingers and bouncing the db, which worked thank goodness.

NT4 running 7.3.4 (I know, I know).

Any ideas?

Michael Ray
Oracle DBA
TRW, Marshall, IL
217-826-3011 x2438

--

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

Author: jiang
INET: jiangxph_at_public.wh.hb.cn

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 Sat Mar 10 2001 - 09:12:19 CST