Tuesday, November 24, 2015

Oracle ORA-00020 : Maximum Number of Processes(XXX) Exceeded.

Hi,

When connecting to oracle sometimes, user may face this error:

Maximum Number of Processes(XXX) Exceeded.

The reason is the process in the server are in use.

Solution:

<![if !supportLists]>1.    <![endif]>Is to increase the value of Processes in initialization parameter.

Or

<![if !supportLists]>2.    <![endif]>Kill the long time ideal session to free the processes. From oracle and in unix if needed


--List of processes not connected to sessions (Oracle8i):
***********************************************
select 'kill -9 '|| SPID || ';'  from v$process where program!= 'PSEUDO'and addr not in (select paddr from v$session)and addr not in (select paddr from v$bgprocess)and addr not in (select paddr from v$shared_server);

Thanks & Regards

Fauzi


Friday, November 20, 2015

The remote server returned an error: (407) Proxy Authentication Required.



Hello,

I was writing an asp.net utility(console application) to fetch an image from a URL. During development i faced the following message:

The remote server returned an error: (407) Proxy Authentication Required.

The solution is we need to place a app.config file to the project and add the following nodes





defaultProxy useDefaultCredentials="true"

Hope it helps...