Unable to connect to Oracle data base from Ignio Prod Cheetah server

    • vibin.vincent
      Participant
      2 years, 11 months ago #3487

      Hi We are trying to configure Oracle Database server with Ignio Cheetah Server SP6 . We have installed oracle 12client on the server side and trying to ODBC driver , but while trying the test connection we are getting the below error

      When I am trying to configure the ODBC driver for Oracle, facing the below issue TNS: Connect timeout occurred.
      we tried to execute the command “tnsping p2mdm”, but getting the error like TNS-12535: TNS: Operation timed out.

      We checked with the network team if there is any communication issue from the source to destination or vice versa , and they confirmed it is working fine . Request your help

    • Mohamed Hanif
      Participant
      2 years, 11 months ago #3488
      Up
      0
      Down
      ::

      Hi Vibin Vincent,
      The given error is not from the Ignio product. It is a generic thrown from Oracle some of the reasons are given below.
      Check your connection entry in the tnsnames.ora file, especially the values of hostname, port number.
      Is your hostname is pingable from the target server? if not resolve it.
      Have you given the proper port number in the tnsnames.ora file for the connection entry?
      Do Ignio user has proper read privilege on the tnsnames.ora file?
      Is the port is opened in the firewall?
      Is the port is not blocked by the antivirus?

Viewing 1 reply thread

You must be logged in to reply to this topic.