This is similar to https://community.oracle.com/tech/developers/discussion/334857/oracle-dataaccess-client-oracleexception-connection-request-timed-out-error given that the error message is same. However, I'd like to explain my scenario here to understand the root cause:
We have an application critical sql id on which we have performed profiling
Post profiling, we observed plan flipping happening for this sql id
DBA pinned the best plan to this sql id, and we never saw any slowness in execution time
Recently, we performed baselining so that we don't have to pin the plan every time the sql id changes
Now the sql id is running intermittently slower (and sometimes faster of course). DBA has confirmed that a single plan is getting used every time this sql id is running
We received Connection request timeout error intermittently when we are trying to execute this sql from our .net app.
We need to understand why we are getting connection request time out error. Is there anything we need to do from configuration perspective?
ODAC - Oracle.DataAccess.dll (2.122.1.0)
oracle server is 12g (we are using oraas server)
Please let me know if this information is inadequate. happy to add more information to get to the root cause of this issue.