'The connection manager will not acquire a connection because the connection manager OfflineMode property is TRUE
I am trying to store connections in the configuration table, but getting the below errors. SSIS is not configured as Offline mode.
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.
The connection manager will not acquire a connection because the connection manager OfflineMode property is TRUE
Solution 1:[1]
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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Hadi |