Error Message: unable to allocate memory

Error Message: unable to allocate memory

Action:
While using the Oracle Destination, the following error message was returned.
Error Message:
'Oracle.DataAccess.Client.OracleException (0x80004005): Impossible d'allouer de la mé­¯ire (unable to allocate memory in french)

   at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable, OracleLogicalTransaction m_OracleLogicalTransaction)'

Solution:

Install the Oracle client 19.c and then the latest bundle patches on it in order to solve the problem. The bundle patch is from August 2020. 

19c Oracle client can be downloaded from below link (19.3)
https://www.oracle.com/database/technologies/oracle19c-windows-downloads.html

Following Windows bundle patch released in Oct 2020 can be applied on top of 19c client 19.3 :
https://updates.oracle.com/download/31719903.html

 

In addition, you have to download a more recent version of the Opatch utility than the one provided with the Client 19c

You must use the OPatch utility version 12.2.0.1.17 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 12.2, which is available for download from My Oracle Support patch 6880880 by selecting the 12.2.0.1.0 release.

For information about OPatch documentation, including any known issues, see My Oracle Support Document 293369.1 OPatch documentation list.

 

When testing the version provided with the client 19.3 without applying the patch the memory leaking is not solved.

You have to apply the patch to have the problem finally solved..