Is this an OLTP DB? Changing parameter 'process' could be a temporary fix.
You may also need to investigate lingering connections. People write bad
code
That opens a connection and doesn't bother to close it, which will
eventually
Lead to the error you got now.
-Ancy

-----Original Message-----
From: Srikanta L
[mailto:oracledba-ezmlmshield-x69759271.[Email address protected]
Sent: Friday, October 28, 2005 6:30 AM
To: LazyDBA Discussion
Subject: ORA-00020: maximum number of processes (150) exceeded


Dear All

While compiling SP containing database link, I am getting the following
error,

9i : ORA-00020: maximum number of processes (150) exceeded.

Kindly let me know, what's need to be done.

Thanks in advance.

Srikanta.L

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



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page