While using the Oracle Destination, the following error message was returned.
'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)'
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)
Following Windows bundle patch released in Oct 2020 can be applied on top of 19c client 19.3 :
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 22.214.171.124.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 126.96.36.199.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..