Ora-04030 FOR SQLNET CONNECTIONS ulimits inherited from user starting Listener
(Doc ID 947983.1)
Last updated on OCTOBER 08, 2020
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
-- Problem Statement:
Ora-04030 (Koh-Kghu Sessi,Pmucalm Coll) Ora-04030 (Pga Heap,Kgh Stack)
When checking the user ulimits locally on the server, you see the unlimited system resources. When you check the same user when the user has logged in via a SQLNET connection you see they seem to lose the unlimited system kernel settings.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document