I have a package that connects to Oracle and brings data. It also deletes some from Oracle.
So when the first step runs where the data is brought from Oracle into SQL Server, it runs fine. But when the deletion step runs, following error is shown.
Failed to acquire connection "My Connection". Connection may not be configured correctly or you may not have the right permissions on this connection.
This "My Connection" is basically OracleClient Data Provider connection.
The thing is the same package is working fine on two other machines but this 3rd machine it is not working on. The only differences between those 2 machines and this one are:
1. This new machine is part of SQL Cluster while other two are standalone
2. This new machine is Windows Server 2012 R2 and the other two are Windows 2012
So I am thinking could this error be due to Windows Server 2012 R2? Like somethings may have changed in this Windows version due to which it is not working? Or this error is due to some Oracle misconfiguration on machine?