database - Jitterbit - "ORA-12504, TNS:listener was not given the SID in CONNECT_DATA" -

issue:

we're attempting upserts salesforce lawson (oracle) database client, using jitterbit. using oracle [jdbc] driver on default port. have jitterbit agent running on windows server 2008 on machine inside client's network, , assured client (but not 100% certain) server can connect lawson database. when try initiate connection oracle database within jitterbit studio (studio not running windows server, we're running local machine) we're refused with:

listener refused connection following error: ora-12504, tns:listener not given sid in connect_data 

the question i'm hoping can is - listener lacking sid for? i'm familiar on basic level listener.ora , how sid information needs provided listener allow incoming connections database.

does sid in error refer to:

• the lawson database? (this seems unlikely, understanding listener referred here listener sitting on server lawson database)
• the machine agent sitting on (the windows server 2008)?
• or local machine we're running jitterbit studio from?

i'm waiting listener.ora , tnsnames.ora client, wanted see if had idea of root block own experience.

stack trace, in case it's helpful:

details: oracle.net.ns.netexception - listener refused connection following error: ora-12504, tns:listener not given sid in connect_data      @ org.jitterbit.integration.client.ui.interchange.locatable.actions.testconnectionresultdisplayer.showresult(testconnectionresultdisplayer.java:62)     @ org.jitterbit.integration.client.ui.interchange.locatable.actions.testconnectionjob.runimpl(testconnectionjob.java:55)     @ org.jitterbit.application.ui.job.uijob$2.run(uijob.java:509)     @ org.jitterbit.application.worker.defaultapplicationworker$runnablewrapper.run(defaultapplicationworker.java:105)     @ java.util.concurrent.executors$runnableadapter.call(executors.java:471)     @ java.util.concurrent.futuretask.run(futuretask.java:262)     @ java.util.concurrent.threadpoolexecutor.runworker(threadpoolexecutor.java:1145)     @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:615)     @ java.lang.thread.run(thread.java:745) 

screenshot of connection parameters supplied:

tnsnames.ora:

psilsfd1 =   (description =     (address = (protocol = tcp)(host = 10.33.22.224)(port = 1521))     (connect_data =       (server = dedicated)       (service_name = psilsfd1)     )   ) 

listener.ora:

# listener.ora network configuration file: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora # generated 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 

the jitterbit support pages include:

configure source or target oracle jdbc driver
- create new source , give name.
- type drop-down, select database.
- click select... , locate oracle driver. make sure jdbc check-box selected. may have refresh driver list if installed driver.
- depending on how oracle server configured may have enter server name, login , password (and port if server runs on non-standard port). however, in cases have construct connection string manually, see below.
...

with emphasis added. seem have followed instructions, since there supply service name, you'll need manual setup:

to use manual connection string, expand options section , check "construct connection string manually". type in connection string , test transformation.

based on in tnsnames.ora, connection string be:

jdbc:oracle:thin:@//10.33.22.224:1521/psilsfd1