ORA-12516

Last couple of days i faced strange problem with our development database.

We are getting following error when trying to connect to database with TNS_ENTRY

ORA-12516: TNS:listener could not find available handler with matching protocolstack

When i check ALERTSID.LOG file i am getting following entry

Mon Jun 16 09:36:01 2008

Process q000 started up but failed with error = 20

Mon Jun 16 09:57:55 2008

Process q000 started up but failed with error = 20

Mon Jun 16 10:02:01 2008

Timed out trying to start process J000.

Mon Jun 16 10:02:02 2008

kkjcre1p: unable to spawn jobq slave process

Mon Jun 16 10:02:02 2008

Errors in file d:\oracle\product\10.1.0\admin\bdump\oramfe_cjq0_3328.trc:

Timed out trying to start process J000.

according error message i search on metalink and found to increase

job_queue_processes parameter from default value 10 to 20 but after that the problem is not solved.

after that i checked without TNS_ENTRY and found below error message

SQL> conn scott/tiger

ERROR:ORA-00020: maximum number of processes (%s) exceeded

then finally I increase PROCESSES parameter & change Listener Registration from DYNAMIC to STATIC then after problem solved.

How to change listener registration from DYNAMIC to STATIC see below link

http://dbataj.blogspot.com/2007/02/ora-12514.html

SQL> alter system set processes = 400 scope=spfile;