title: Connecting to oracle database with proxy address
body: <p>So I'm trying to connect to an Oracle database using the <code>Oracle.ManagedDataAccess</code>-library, where I'm using the following datasource: </p>
  
  <pre><code>(DESCRIPTION =(SOURCE_ROUTE = YES)
  (ADDRESS_LIST=
  (ADDRESS = (PROTOCOL = TCP)(Host = PROXY-OracleConnectionManager)(Port = 1111))
  (ADDRESS = (PROTOCOL = TCP) (Host = MAIN-DATABASE) (Port = 0000)))
  (connect_data= (UR = A)(SERVICE_NAME = SERVICENAME)))
  </code></pre>
  
  <p>I'm also providing a user id and password. </p>
  
  <p>We don't have any control over the database on our end, but as far as I know, they are using a connection manager as the first address, which should route us to the next address in the list if we are authenticated. This works when using this in Oracle SQL Developer but does not work programatically with <code>Oracle.ManagedDataAccess.</code></p>
  
  <p>This is how I build and use the connection string:</p>
  
  <pre><code>var connString = new OracleConnectionStringBuilder
              {
                  {"User Id", settings.DbUserId},
                  {"Password", settings.DbUserPassword},
                  {"Data Source", settings.DbDataSource}
              };
  OracleConnection conn = new OracleConnection(connectionString.ToString())
  conn.Open()
  </code></pre>
  
  <p>When I run this, I get the following error: </p>
  
  <blockquote>
    <p>ORA-12537: Network Session: End of file</p>
  </blockquote>
  
  <p>I suspect that the issue is the <code>ADDRESS_LIST</code> and that the routing doesn't work, but I can't say for sure. Anyone able to provide some insight?</p>