maximum number of processes exceeds

[Chiranjeevi M]

I am using one web based aqpplication developed in j2ee technologies and with oracle 9i as back end on red hat linux platform with jboss 4.0 as application server .when go on accessing application it gives error no managable connection maximum no of threades exceeds more than 150(default) and it is not rinning .So i am unable aceess the application.oracle error number is ora-00020.so plz give me solution as soon as possible

[davey23uk]

increase the processes parameter in the database

[craigdba]

You will need to bounce your database, I don't beleive this parameter can be changed while the database is up, so you need to edit the pfile or alter system set processes=### scope=spfile;

Regards