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.
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.
User contributions licensed under CC BY-SA 3.0