Database generates error: 'Unable to spawn jobq secondary process' and crashes (Doc ID 445225.1)

Last updated on JANUARY 05, 2023

Applies to:

Symptoms

-- Problem Statement:
Problems in spawning jobq secondary.

-- Business Impact:
Users cannot login to database until Oracle Service is shutdown and restarted. May be necessary to
restart service once or twice a day during business hours. Errors occur everyday. Database is a
production system that must be reliable as it is the basis for several data feeds.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.