Ever received this error message in your alert log? I have on a couple of occasions. Perhaps an application server started spawning more database connections than it normally does in turn creating more processes on the database. The Oracle description of this error is: Error: ORA 20 Text: maximum number of processes exceeded Cause: An operation requested a resource that was unavailable. The maximum number of processes is specified by the initialization parameter PROCESSES. When this maximum is reached, no more requests are processed. Action: Try the operation again in a few minutes. If this message occurs often, shut down Oracle, increase the PROCESSES parameter in the initialization parameter file, and restart Oracle. But what if you cannot connect to your database to shut it down and increase the parameter? oradba01t[labdb01]-/home/oracle/>sqlplus /as sysdba SQL*Plus: Release 11.1.0.7.0 - Production on Mon Jun 6 11:25:05 2011 Copyright (c) 1982, 2008, Ora...
Comments
Post a Comment