My Oracle Support Banner

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 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

-- 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.

 



Cause

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
Symptoms
Cause
Solution

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