SSIS connection not acquire because the connection manager OfflineMode property is TRUE

1

I am trying to store connections in configuration table, but getting below errors.

Offline mode is false I checked again n again......please help

An error has occurred while connecting Oracle  Server: Exception from HRESULT: 0xC0202009.
Validation error. Oracle to BO: : The connection manager "Oracle  Server" will not acquire a connection because the connection manager OfflineMode property is TRUE. When the OfflineMode is TRUE, connections cannot be acquired.  
Validation error. Oracle to BO: Oracle to BO: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Oracle  Server" failed with error code 0xC0014041.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.  
Validation error.  : The connection manager "Oracle  Server" will not acquire a connection because the connection manager OfflineMode property is TRUE. When the OfflineMode is TRUE, connections cannot be acquired.  
Validation error. Oracle to BO Oracle _PROFILE table [106]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Oracle  Server" failed with error code 0xC0014041.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.  
Validation error. Oracle to BO: : The connection manager "Oracle  Server" will not acquire a connection because the connection manager OfflineMode property is TRUE. When the OfflineMode is TRUE, connections cannot be acquired.  
Validation error. Oracle to BO: Oracle to BO: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Oracle  Server" failed with error code 0xC0014041.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.  
Validation error.  : The connection manager "Oracle  Server" will not acquire a connection because the connection manager OfflineMode property is TRUE. When the OfflineMode is TRUE, connections cannot be acquired.  
Validation error. Oracle to BO Oracle _TPA table [114]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Oracle  Server" failed with error code 0xC0014041.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.  
ssis
asked on Stack Overflow Aug 25, 2015 by Sandeeep Adate • edited Aug 25, 2015 by Jan Eglinger

1 Answer

0

I believe this error is happening because TNS entry is mission in that machine.

Please verify if oracle TNS for the database is present in that machine or not?

You can find the TNS file in the below path.

C:\Oracle\product\11.2.0\client_1\network\admin

If it is not there and try one more time.

answered on Stack Overflow May 26, 2016 by Amit Kumar • edited Feb 10, 2019 by Hadi

User contributions licensed under CC BY-SA 3.0