title: OracleConnection.Open is throwing ORA-12541 TNS no listener
body: <p>So I am connecting to an external server through C#. I just installed <strong>Oracle 11g</strong> client on my machine from here: <a href="http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html">http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html</a> (255MB one).</p>
  
  <p>After reading many blogs/questions I found this article to be useful:</p>
  
  <p><a href="http://dbaspot.com/oracle-faq/444787-ora-12541-tns-no-listener.html">http://dbaspot.com/oracle-faq/444787-ora-12541-tns-no-listener.html</a></p>
  
  <p>So is this correct? I cannot do anything. The DBA has to edit the <strong>LISTENER.ORA</strong> file?</p>
  
  <p>My <strong>tnsnames.ora</strong> looks like this:</p>
  
  <pre><code>  TestingConnect=
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = TestHostName.us.local)(PORT = 1523))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = TEST)
      )
    )
  </code></pre>
  
  <p>It is throwing me the err at:</p>
  
  <pre><code>Oracle.DataAccess.Client.OracleConnection connection = new Oracle.DataAccess.Client.OracleConnection();
  
  connection.ConnectionString = "Data Source=TestHostName.us.local;Persist Security Info=True;" + "User ID=tesName;Password=test";
  
  connection.Open() //Throwing ERR!!!
  </code></pre>
  
  <p>What should I do? I appreciate any comments. Thanks!</p>