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:

enter image description here

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

Comments

Post a Comment

Popular posts from this blog

Android : Making Listview full screen -

-
<linearlayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".mainactivity"> <edittext android:layout_margintop="5dp" android:layout_width="match_parent" android:layout_height="50dp" android:background="@drawable/location_edittext" android:id="@+id/locationeditext" android:textsize="15sp" android:textcolor="#999" android:paddingleft="15dp" /> <com.example.ravi_gupta.slider.viewpagercustomduration android:layout_width="wrap_content" android:layout_height="0dp" android:id="@+id/viewpager" android:scrollbarstyle="outsideoverlay" android:layout_weight="0.5...
Read more

javascript - Parse JSON from the body of the POST -

-
i'm using cameratag.com record video on website. service can send json response server can save data database. don't know how proceed here: the documentation states please note json repsonse passed in body of post , not form parameters. here example of how parse response in ruby: data = json.parse(request.raw_post) video_uuid = data["uuid"] but don't know how data on javascript. i'm not experienced in js please bare me :) post sample: { "uuid": "00012710-4b65-0131-ffe6-22000a499ea4", "camera_uuid": "98373a20-79ee-0130-3e42-1231390fcc11", "created_at": "2013-12-20t05:25:02.000z", "percent_complete": 100, "short_code": "kktb4q", "metadata": { }, "state": "published", "recorded_from": "http://singwho.com", "publish_type": null, "formats": [ { "name...
Read more

javascript - How to Hide Date Menu from Datepicker in yii2 -

-
basically in datetimepicker widget date choose first time, how can hide date option widget , filter according time. tried not working want hide remove button [ 'attribute'=>'time', 'label'=>'time', 'format'=>'raw', 'value'=>function($data){ return date('h:i:s',strtotime($data->time)); }, 'filter'=> datetimepicker::widget([ 'model' => $searchmodel, 'attribute' => 'time', 'clientoptions' => [ 'autoclose' => true, 'format' => 'hh:ii', 'showon' =...
Read more