maximum number of processes (150) exceeded

I am using oracle database and i get these error's :---
1) Dump file c:\kcoracle\ora92\admin\kcdata91\udump\kcdata91_ora_4440.trc
Sun Dec 07 08:27:51 2003
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: kcdata91

Redo thread mounted by this instance: 1

Oracle process number: 149

Windows thread id: 4440, image: ORACLE.EXE


*** SESSION ID:(145.1142) 2003-12-07 08:27:51.000
kxfpg1srv
        could not start local P001
Dump file c:\kcoracle\ora92\admin\kcdata91\udump\kcdata91_ora_4440.trc
Sun Dec 07 08:27:55 2003
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: kcdata91

Redo thread mounted by this instance: 1

Oracle process number: 147

Windows thread id: 4440, image: ORACLE.EXE


*** SESSION ID:(145.1144) 2003-12-07 08:27:55.000
kxfpg1srv
        could not start local P002
Dump file c:\kcoracle\ora92\admin\kcdata91\udump\kcdata91_ora_4440.trc
Sun Dec 07 08:27:59 2003
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: kcdata91

Redo thread mounted by this instance: 1

Oracle process number: 147

Windows thread id: 4440, image: ORACLE.EXE


*** SESSION ID:(145.1148) 2003-12-07 08:27:59.000
kxfpg1srv
        could not start local P002
kxfpg1srv
        could not start local P002
Dump file c:\kcoracle\ora92\admin\kcdata91\udump\kcdata91_ora_4440.trc
Sun Dec 07 08:28:19 2003
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: kcdata91

Redo thread mounted by this instance: 1

Oracle process number: 0

4440


OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00020: maximum number of processes (150) exceeded

2)  Dump file c:\kcoracle\ora92\admin\kcdata91\udump\kcdata91_ora_5512.trc
Sun Dec 07 08:27:48 2003
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: kcdata91

Redo thread mounted by this instance: 1

Oracle process number: 147

Windows thread id: 5512, image: ORACLE.EXE


*** SESSION ID:(146.778) 2003-12-07 08:27:48.000
kxfpg1srv
        could not start local P002
fakhryAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

shivsaCommented:
you could be having a problem either with the max processes exceeding or max cursors open.
You can easily increase the maximum number of process in your ORA file.(ora.ini)
But that would depend on how many users are going to access the application.
You also need to check the number of cursors open in the database as well. If you do see the cursors open the the database then you need to properly handle all connections in the code and close them.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shivsaCommented:
In case of Oracle JDBC even statements like INSERT, UPDATE, DELETE opens a cursor !!! Remeber to call close on statements i case of ResultSet use rs.getStatement().close()
0
shivsaCommented:
Also from
http://download-west.oracle.com/otn_hosted_doc/repository/doc_library/release4/messages/ora_messages.htm

here is the solution to the problem
=============================
ORA-00020, 00000, "maximum number of processes (%s) exceeded"
Cause:  All process state objects are in use
Action: Increase  maximum processes - init.ora parameter "processes"

=========================================
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

anand_2000vCommented:
In any case increase your PROCESSES parameter in the init file
0
seazodiacCommented:
ORA-00447: fatal error in background process
ORA-00020: maximum number of processes (150) exceeded

This probably means that Oracle server cannot even start fully with all the background processes.

two questions:

1. how much Physical memory does your machine have?
2. how big is your max_sga_size?

show the contents of your init<sid>.ora file?
0
schwertnerCommented:
Increase PROCESSES parameter in the SPFILE.
If you can not stsart the instance, find the pfile.ora, make the changes and start the instance
SQL>startup pfile=c:\........\init<sid>.ora

At the startup time Oracle starts only limited number of processes - between 9 and 15. So it seems that a process consuming application immediatelly connects to Oracle. This may be an application server or a farm of app. servers.
0
edvinkvCommented:
Pls reduce the parallell query processes to fix this issue. (Reduce it by half)


in the init.ora file.. also pls restart the database.

max_parallel_servers=
min_parallel_servers=0 (or you may reduce this also by half)

0
sagaciousCommented:
Increase the number of processes of your oracle server...

Go into the console and manage it. But if you are hit with this problem, you should check your codes as this derives mainly from connections opened and not closed and things just accumulate and stops there.

Sagacious
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.