ORA-27302: failure occurred at: skgpspawn3 on SLES12 or later with large number of processes established (Doc ID 2801372.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

When relocating service from node1 to node2, DB instance failed to startup with below error:

OS parameter UserTasksMax is set to 12288 which is defined in /etc/systemd/login.conf.
Database processes is set to 30000.
When the issue occurred, there are more than 11500 DB processes have been forked and established.

Cause

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