ORA-12537: Network Session: End of file (itgenclr130) when connecting to Oracle

[forums]

Using the .net core version of Invantive Data Hub 22.0.664, but also on the .net framework version, I am getting intermittent Oracle errors when connecting:

The data container with alias ‘ora’ could not be opened on provider ‘OracleManaged’.
ORA-12537: Network Session: End of file.
OracleInternal.Network.NetworkException
Oracle.ManagedDataAccess.Client.OracleException
ValidationException
ValidationException
at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)
at OracleInternal.Network.OracleCommunication.Connect(String tnsDescriptor, Boolean doNAHandshake, String IName, ConnectionOption CO)
at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, OracleConnection connRefForCriteria, String instanceName)
Exception during boot: Invantive.Basics.ValidationException: itgendhb005: Could not connect to database ‘L120\invoicing3’. Application will be closed.
at Invantive.Basics.ValidationException…ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String errorMessage, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable`1 uid, Boolean isRecoverable, String poolIdentityId, String url)
at Invantive.Producer.Data.Hub.QueryEngine.Run(String arguments)
at Invantive.Producer.Data.Hub.Program.Main(String args)
at Invantive.Producer.Data.Hub.QueryEngine.Run(String arguments)

The error code is itgenclr130.

Typically, the connection will succeed when trying again. When the problem persists, rebooting the Oracle database helps.

The Oracle database is Oracle Standard Edition Two version 19.0.0 (2023-04) with 2 GB of memory allocated and few concurrent users.

[forums]

First recommendation is to increase the available memory on Oracle to 4 GB and try for some time whether this resolves the issue.

[forums]

This question was automatically closed after at least 2 weeks of inactivity after a possible solution was provided. The last answer given has been marked as a solution.

Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.