Error while validating worker count

Error while validating worker count - Invalid worker Count

Error

When running the AD Online Patching (ADOP) utility in Oracle E-Business Suite (EBS) 12.2, the prepare phase may fail with the following error:


[UNEXPECTED] Invalid worker Count: 0  
[UNEXPECTED] Error while validating worker count

Reason

This issue is typically caused by the database reaching its maximum number of processes during ADOP execution.

To verify this, run the following SQL query:


SELECT * FROM v$resource_limit 
WHERE RESOURCE_NAME IN 
('processes', 'sessions', 'parallel_max_servers', 
'parallel_min_servers');

Sample Output

RESOURCE_NAME	CURRENT_UTILIZATION	MAX_UTILIZATION	INITIAL_ALLOCATION	LIMIT_VALUE
processes	191	200	200	200
sessions	199	243	408	408
parallel_max_servers	0	8	8	3600
parallel_min_servers	0	8	8	160

The high utilization of processes and sessions indicates that the system is running close to its limits, leading to failures in ADOP execution.

Solution

To resolve this issue, follow these steps in a development environment before applying changes to production:

Step 1: Increase Database Initialization Parameters

Modify the init.ora file to increase the following database parameters

processes
sessions
parallel_max_servers / parallel_min_servers
open_cursors

Ensure that the new values accommodate system workload while maintaining stability.

Step 2: Restart the Database

Once the parameters are updated, restart the database for changes to take effect.


ALTER SYSTEM SET processes = <new_value> SCOPE=SPFILE;
ALTER SYSTEM SET sessions = <new_value> SCOPE=SPFILE;
ALTER SYSTEM SET parallel_max_servers = <new_value> SCOPE=SPFILE;
ALTER SYSTEM SET open_cursors = <new_value> SCOPE=SPFILE;
SHUTDOWN IMMEDIATE;
STARTUP;

Step 3: Retest ADOP Execution

Run the ADOP prepare phase again to confirm that the process runs successfully without errors:


adop phase=prepare

If the error persists, re-evaluate the database resource allocation and increase limits accordingly.

Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment

Error while validating worker count - Invalid worker Count