Saturday, 28 December 2013
kkjcre1p: unable to spawn jobq slave process,TNS-12514,TNS-12523,TNS-12502,TNS-12520,TNS-12528
This problem occurred due to resource allocation on the db side .
Here is the solution approach :-
1.check the kernel parameter and see if it configured at optimum level.
2.Check the swap space and their usage and re-config them if it is needed .
3.It may be your JOB_QUEUE_PROCESSES is too low comparison to processes parameter , increase it upto
32 and decrease the processes parameter upto 800 for now .
4.Check the session,transaction and process parameter and tune the session and process parameter.
5.monitor the PROCESSES usage at the database level using the V$RESOURCE_LIMIT view and increase it if is
Shivendra Narain Nirala
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)