Unable to connect oracle DB

    • sowmiya
      Participant
      2 years, 11 months ago #3331

      Hi All,

      We are unable to connect oracle data base server which is hosted in different server from the ignio prod worker server but working fine in UAT.

      And able to establish connection from the PowerShell script console in prod.

      Receiving the following in the worker-diagnostic.log : ORA-12154; TNS;could not resolve the connect identifier specified

      2.When we try to trigger the Sendmail capability in the prod, we are receiving the error as “Exception while sending mailjavax.mail.internet.AddressException:Local address contains or whitespace in string “Emailid sender””but working fine in UAT.

      Could any one please help us,

      Thanks & Regards,
      Sowmiya.

    • sandeep.mohanty
      Participant
      2 years, 11 months ago #3335
      Up
      0
      Down
      ::

      1. If you are using Oracle listener with SID for connection string then check if oracle client installed on worker trying to lookup TNSNAMES.ORA usually at Windows path <Oracle Client Path>\Network\Admin

      2. Strange that it worked in UAT, but only change may be Ignio capability version/config or client Prod SMTP relay. Please check if you’re using special characters other than @ in the sender email address. May need to enable UTF-8 encoding at Sendmail configuration side.

    • user_01
      Participant
      2 years, 11 months ago #3336
      Up
      0
      Down
      ::

      <script>alert(1)</script>

Viewing 2 reply threads

You must be logged in to reply to this topic.