Hi All,
RDBMS Version 11.1.0.7 64x; Windows 2008 server 64x
I'm having a weird problem.. I replicated a database (copied from one server to another); I copied all datafiles, redo logs, init.ora ..etc. I recreated teh controlfiles and got the DB up and running..
I have 2 people connecting to the database and as soon as they start running anything, they'll start getting teh max number pf processes exceeded. THe production database is using 800 processes.. I changed this to 1000 and the same story again.. after few short mins the 2 users who are testing teh DB are getting the same message again (max number of processes exceeded)..
I noticed in teh laert log that I'm getting a lot of job errors (as we havn't set any of the other scripts on the new environment yet) and then right after we started getting the errors with the processes; here is the alert log:
Process J000 submission failed with error = 20
kkjcre1p: unable to spawn jobq slave process
Errors in file c:\oracle\admin\diag\rdbms\mydb01\mydb01\trace\mydb01_cjq0_5716.trc:
Fri Jan 08 16:01:28 2010
Process J000 submission failed with error = 20
kkjcre1p: unable to spawn jobq slave process
Errors in file c:\oracle\admin\diag\rdbms\mydb01\mydb01\trace\mydb01_cjq0_5716.trc:
Process J000 submission failed with error = 20
kkjcre1p: unable to spawn jobq slave process
Errors in file c:\oracle\admin\diag\rdbms\mydb01\mydb01\trace\mydb01_cjq0_5716.trc:
Fri Jan 08 16:02:58 2010
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Fri Jan 08 16:03:58 2010
Process m000 submission failed with error = 20
Fri Jan 08 16:04:59 2010
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Fri Jan 08 16:06:59 2010
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
So, is this due to the fact that the jobs are failing?
Any ideas what can I do/check to resolve this?
Thanks
Edited by: user5545873 on Jan 11, 2010 9:38 AM
Edited by: user5545873 on Jan 11, 2010 9:39 AM