1 Reply Latest reply: Feb 18, 2013 3:38 AM by user248025 RSS

    Error :"Connect timeout occurred"

    921364
      Hi Experts,
      I installed ODBC client and wanted to test the connection using my oracle TNS. For some reason i'm getting "Connect timeout occurred" when i tried to test the connection. Below are the database details.

      Can you please look into this and provide solutions on how to resolve this.

      Database version : Oracle 10 g
      Oracle Client version : Oracle 11 g

      tnsnames:
      ORCL =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = BHELRND)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
      )
      )
        • 1. Re: Error :"Connect timeout occurred"
          user248025
          Hi,

          Can try below way,

          1. Copy your tnsnames.ora to {Oracle_BI1}\network\admin directory & {oracle_common}\network\admin directory (only the former is needed as that is the ORACLE_HOME)

          2. Or instead of tnsnames.ora source entry, use the full expanded tnsnames as shown below

          (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))

          Note: put it u r IP, Port service name etc.
          alternative method, try to test it OCI Call interfact
          //database_host[:port]/service_name (RPD -->physical layer --> put it under u r dsn name)
          for more refer, http://gerardnico.com/wiki/dat/obiee/oci


          Thanks
          Deva