Retrying while Opening connection to Oracle Database using Polly

extensions.cs

using System;
using Oracle.ManagedDataAccess.Client;
using Polly;


namespace frontend.ExtensionMethods
{
    public static class Extensions
    {
        const int retryTimes = 3;

        static readonly Polly.Policy retryPolicy = Policy
            //.Handle<OracleException>(e => e.Message.Contains("Connection request timed out"))
            .Handle<OracleException>(ex => ex.IsRecoverable)
            .WaitAndRetry(retryTimes, retryAttempt =>
   TimeSpan.FromMilliseconds(Math.Pow(2, retryAttempt)), (exception, timespan, retrycount, context) =>
            {
                if (retrycount == 1)
                {
                    OracleConfiguration.TraceOption = 1;
                    OracleConfiguration.TraceLevel = 7;
                }
                System.Diagnostics.Trace.WriteLine(string.Format("Retry:{0} -> failed with Error Message: {1} ", retrycount, exception.ToString()));
            });

        public static void OpenWithRetries(this OracleConnection conn)
        {

            try
            {
                conn.KeepAlive = true;

                retryPolicy.Execute(() =>
                {
                    conn.Open();
                });
            }
            finally
            {
                OracleConfiguration.TraceLevel = 0;
            }

        }

    }
}