September 18, 2016 at 10:54 pm
Why we get error like below when we run the SSIS package?
[Oracle Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "OracleConnectionString" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. [Connection manager "OracleConnectionString"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit"
September 19, 2016 at 2:15 am
The error message is quite clear:
exceeded simultaneous SESSIONS_PER_USER limit
If you're the only user, try setting the RetainSameConnection property on the connection manager to true.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2016 at 1:20 pm
check this http://oraclehunterz.blogspot.ie/2013/06/ora-02391-exceeded-simultaneous.html
if you are executing code and/or querying over a remote dblink that can also happen
-- check last post on http://www.orafaq.com/forum/t/96704/ for this last issue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply