title: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
body: <p>I'm trying to connect my local Oracle 11g database using server explorer in Visual Studio 2010. I tried to setup everything as per instruction, but I'm still getting an ORA-12504 error.</p>
  
  <p>Here is the error:</p>
  
  <p><img src="https://i.stack.imgur.com/3rAct.png" alt="enter image description here"></p>
  
  <p>Here is my tnsnames.ora contents:</p>
  
  <pre><code># tnsnames.ora Network Configuration File: C:\app\rsahi\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
  # Generated by Oracle configuration tools.
  
  
  VENUS =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = SPRPRG020)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = VENUS)
      )
    )
  
  LISTENER_VENUS =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SPRPRG020)(PORT = 1521))
  </code></pre>
  
  <p>listener.ora file contents,</p>
  
  <pre><code># listener.ora Network Configuration File: C:\app\rsahi\product\11.2.0\dbhome_1\network\admin\listener.ora
  # Generated by Oracle configuration tools.
  
  LISTENER =
    (DESCRIPTION_LIST =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = SPRPRG020)(PORT = 1521))
      )
    )
  
  ADR_BASE_LISTENER = C:\app\rsahi
  </code></pre>