Oracle.ManagedDataAccess.Client.OracleException (0x80004005): Connection request timed out

Question

I have been struggling with this for a several days. The code runs and connects to the database successfully on my development machine, but when I deploy it to the server, I get this error. I am using Oracle.ManagedDataAccess. This is what I have tried so far.

Checked whether 32bit or 64bit. Turned out to be 64bit Checked TNS Names file. It was correct Checked both machines are on the same network. They were. Tried creating a stripped down console application that connects to the database. The console application worked on both machines. Main application fails to work on server. Tried creating a stripped down web forms application that connects to the dtabase. The web forms application reproduced the error, ruling out a problem with main application itself. Tried doubling timeout value. Tried decreasing timeout value to 1 second. Tried turning off connection pooling. Tried increasing connection pool size. Tried giving IIS_IUSR full privileges over the Oracle Home directory. Tried rebooting server. Tried <setting name="SQLNET.AUTHENTICATION_SERVICES" value="null" />.

Here's the code for the small web application.

        string sql = @"

            SELECT *
            FROM SIMMS_TAB

        ";

        context.Response.ContentType = "text/plain";
        
        int rows = 0;

        try
        {
            using (OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
            {
                conn.Open();

                OracleCommand cmd = conn.CreateCommand();

                cmd.CommandType = CommandType.Text;
                cmd.CommandText = sql;

                var reader = cmd.ExecuteReader();

                while (reader.Read())
                {
                    rows++;
                }

            }

            context.Response.Write(string.Format("Successfully connected! Found {0} rows.<br />", rows));
        }
        catch (Exception ex)
        {
            context.Response.Write(ex);
        }

The exception text is as follows

Oracle.ManagedDataAccess.Client.OracleException (0x80004005): Connection request timed out
   at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, CriteriaCtx criteriaCtx, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, CriteriaCtx criteriaCtx, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, CriteriaCtx criteriaCtx)
   at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
   at StripedDownWebApplication.TestHandler.ProcessRequest(HttpContext context) in C:\Users\mikem\Source\Repos\StripedDownWebApplication\TestHandler.ashx.cs:line 34

Is the connection string correct? What's the full exception text? There may be more information in any inner exceptions — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Aug 24, 2021 at 14:31
I can only assume the connection string is correct because it works on the development machine. I'll edit the question to include the exception text. — Michael S. Miller
– Michael S. Miller, Commented Aug 24, 2021 at 15:03
Do you have a client installed on your dev machine? What about the server? — GH DevOps
– GH DevOps, Commented Aug 24, 2021 at 15:20
The oracle client is installed on both the dev machine and the server. — Michael S. Miller
– Michael S. Miller, Commented Aug 24, 2021 at 17:25

Michael S. Miller · Accepted Answer · 2021-08-26 20:45:23Z

2

In my case, the problem turned out to be very subtle. First of all, the retry_count and the retry_delay of my connection string were set so high that it was timing out retrying the same failed connection over and over again, and thus never showing me the exception that was actually occurring. Once I set them to a more sane value, like 3, I got a different error, a ssl handshake failure. This was then resolved by setting the LoadUserProfile setting in the application pool in IIS to true. After this, the problem went away. It was frustrating, but I hope this helps people who are having this problem in the future.

answered Aug 26, 2021 at 20:45

Michael S. Miller

4372 gold badges8 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle.ManagedDataAccess.Client.OracleException (0x80004005): Connection request timed out

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related