title: Jitterbit - "ORA-12504, TNS:listener was not given the SID in CONNECT_DATA"
body: <p><strong>Issue:</strong> </p>
  
  <p>We're attempting to do upserts to Salesforce from a Lawson (Oracle) database for a client, using Jitterbit. We are using the Oracle [JDBC] driver on the default port. We have the Jitterbit Agent running on Windows Server 2008 on a machine inside the client's network, and we are assured by the client (but not 100% certain) that the server can connect to the Lawson database. When we try to initiate a connection to the Oracle database from within Jitterbit Studio (Studio is NOT running from the Windows Server, we're running it from a local machine) we're refused with:</p>
  
  <pre><code>Listener refused the connection with the following error:
  ORA-12504, TNS:listener was not given the SID in CONNECT_DATA
  </code></pre>
  
  <p><strong>The question I'm hoping someone can help with is</strong> - what exactly is the listener lacking the SID for? I'm familiar on a basic level with listener.ora and how SID information needs to be provided for the listener to allow incoming connections to the database.</p>
  
  <p>Does the SID in the error refer to:</p>
  
  <ul>
  <li>the Lawson database? (this seems unlikely, as my understanding is that the listener referred to here is the listener sitting on the server for the Lawson database)</li>
  <li>the machine that the Agent is sitting on (the Windows Server 2008)? </li>
  <li>or the local machine that we're running Jitterbit Studio from?</li>
  </ul>
  
  <p>I'm waiting to get listener.ora and tnsnames.ora from the client, I just wanted to see if anyone had an idea of the root block from their own experience.</p>
  
  <p>Stack trace, in case it's helpful:</p>
  
  <pre><code>Details: oracle.net.ns.NetException - Listener refused the connection with the following error:
  ORA-12504, TNS:listener was not given the SID in CONNECT_DATA
  
      at org.jitterbit.integration.client.ui.interchange.locatable.actions.TestConnectionResultDisplayer.showResult(TestConnectionResultDisplayer.java:62)
      at org.jitterbit.integration.client.ui.interchange.locatable.actions.TestConnectionJob.runImpl(TestConnectionJob.java:55)
      at org.jitterbit.application.ui.job.UiJob$2.run(UiJob.java:509)
      at org.jitterbit.application.worker.DefaultApplicationWorker$RunnableWrapper.run(DefaultApplicationWorker.java:105)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
      at java.util.concurrent.FutureTask.run(FutureTask.java:262)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      at java.lang.Thread.run(Thread.java:745)
  </code></pre>
  
  <p><strong>Screenshot of where connection parameters are supplied:</strong></p>
  
  <p><img src="https://i.stack.imgur.com/jCKzv.png" alt="enter image description here"></p>
  
  <p>tnsnames.ora:</p>
  
  <pre><code>PSILSFD1 =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.22.224)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = PSILSFD1)
      )
    )
  </code></pre>
  
  <p>listener.ora:</p>
  
  <pre><code># listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
  # Generated by Oracle configuration tools.
  
  LISTENER =
    (DESCRIPTION_LIST =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = psidevdba01)(PORT = 1521))
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      )
    )
  
  ADR_BASE_LISTENER = /u01/app/oracle
  </code></pre>