SQLTeam.com | Weblogs | Forums

Unable to pull the data from Oracle servers (LINUX)


#1

Hi Team,

         We have recently migrated our DB servers to TLS 1.2. SQL 2012 DB is running on Windows 2012 server and Oracle DB is running on LINUX environment. After migrate the DB servers to TLSv1.2, we are not able to pull the data from Oracle server which is running on LINUX environment. We have migrated TLS 1.2 in both the DB servers (Windows and LINUX). If we enable TLSv1.0 in windows 2012 server, then the jobs are running fine.

I have applied all the patches for SQL and Windows as well. But still we are not able to pull the data using SSIS jobs.
Error code has been mentioned below:

"Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.6020.0 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 12:19:06 PM Error: 2017-09-28 12:19:07.35 Code: 0xC0202009 Source: 001-SSP-PACT-CheckBeforePULLFromORACLE Connection manager "OLEDB.CONN.MAIN" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "SSL Provider: The client and server cannot communicate, because they do not possess a common algorithm. ". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Client unable to establish connection". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Encryption not supported on the client.". End Error Error: 2017-09-28 12:19:07.35 Code: 0xC020801C Source: Data Flow Task OLE DB Destination [2] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "OLEDB.CONN.MAIN" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2017-09-28 12:19:07.35 Code: 0xC0047017 Source: Data Flow Task SSIS.Pipeline Description: OLE DB Destination failed validation and returned error code 0xC020801C. End Error Error: 2017-09-28 12:19:07.35 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2017-09-28 12:19:07.35 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:19:06 PM Finished: 12:19:07 PM Elapsed: 0.829 seconds. The package execution failed. The step failed."

Could you please anyone help us here...

Thanks
Sabu.