Error Message: unable to allocate memory
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)
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..
Book a Presales Call
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Error Message: Could not create a managed connection manager
Action: While using Oracle Destination, the following error message was encountered.: Error Message: 'Could not create a managed connection manager' Solution: Most probably the required Oracle ODAC package is not installed on the machine where it ...Where can I find the documentation for the Oracle Destination?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Oracle Destination can be found at the following link. For many of the components you can find ...An error occurred with the following error message: "'0000-00-00 00:00:00' default is invalid for column type TYPE_TIMESTAMP".
Action: When executing an SSIS package containing an ODBC Destination, the following error message occurred. Error Message: An error occurred with the following error message: "'0000-00-00 00:00:00' default is invalid for column type TYPE_TIMESTAMP". ...Error Message: The underlying connection was closed: An unexpected error occurred on a send. (System.Web.Services)
Action: My Salesforce connections have suddenly started giving errors. Attached is the error message I am recieving on testing the connections . Please note the connections were working fine until yesterday and I am getting same issue for both ...Error Message: The operation has timed out.
Action: When moving data into a SharePoint list using the SharePoint Destination component, the following error intermittently occurs. Error Message: The operation has timed out. Solution: Try increasing the timeout parameter in the Sharepoint ...