none
oracle connectivity RRS feed

  • Question

  • Hi,

    I am currently working on the scenario like querying oracle db for some details and getting response back.I have implemented using orchestration and dynamic 2 way send-port to connect to oracle server meanwhile getting oracle DB connection string,password and username from SQL table.while testing,

    no response from oracle send port and orchestration is getting dehydrated ,no suspended instance as well. can any one let me know where to check to solve this issue.

    I tested all connection details.


    • Edited by Radhika C Saturday, October 8, 2016 6:48 AM
    Saturday, October 8, 2016 6:47 AM

Answers

  • Hi Radhika,

    First of all..How many databases are under consideration...because if it is one or two databases, using a dynamic send port is not at all good idea.

    Secondly you should store the connection string in SSO that way it is easy to fetch the details inside the orch..using SQL should be avoided.

    Now as for you orchestration,

    What error or warning is logged in the event log?? There has to be a warning while connecting to oracle...and that is the most probable reason why the orch is getting dehydrated.

    Regards,


    Mandar Dharmadhikari

    Saturday, October 8, 2016 7:07 AM
    Moderator

All replies

  • Hi Radhika,

    First of all..How many databases are under consideration...because if it is one or two databases, using a dynamic send port is not at all good idea.

    Secondly you should store the connection string in SSO that way it is easy to fetch the details inside the orch..using SQL should be avoided.

    Now as for you orchestration,

    What error or warning is logged in the event log?? There has to be a warning while connecting to oracle...and that is the most probable reason why the orch is getting dehydrated.

    Regards,


    Mandar Dharmadhikari

    Saturday, October 8, 2016 7:07 AM
    Moderator
  • Is there anything in the Event Log?
    Saturday, October 8, 2016 12:21 PM
    Moderator
  • Hi Radhika,

    Please help us out with more details so that we can help you.

    Regards


    Mandar Dharmadhikari

    Friday, October 14, 2016 6:28 PM
    Moderator