maximum number of processes exceeded

From: Paul Drake <paled_at_home.com>
Date: Thu, 30 Aug 2001 10:51:49 -0700
Message-ID: <F001.0037D549.20010830091546@fatcity.com>

Hi.

Filing an iTAR - though I'd see if anyone had a similar experience.

NT Server 4.0 Enterprise Edition - SP6a
Dell PowerEdge 4400 - 4 CPUs

Oracle Server Standard Edition 8.1.7.1.2        
        (will be applying 81715 soon, after current problems resolved)

started with
processes = 150
increased to
processes = 250

hiked transactions, max_rollback_segments, etc in init.ora

the 2nd NIC was changed from a DMZ address to an internal address. no changes were made to the 1st NIC which had an internal address.

Site reports that they're getting error:

"ORA-01034: maximum number of processes exceeded"

at login.

only 10 connections viewable via a netstat -n

I cannot get in with svrmgrl - get an ORA-00020 error. Will have to get in after shutting down the instance.

I disabled the OracleSNMP Master Agent.

No third party monitoring tools are in use (HP Openview, etc.)

gonna break out a packet sniffer when I can get access.

thanks for any help.

Paul
--

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

Author: Paul Drake
INET: paled_at_home.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). Received on Thu Aug 30 2001 - 12:51:49 CDT