title: ERROR ORA-12170: TNS:Connect timeout occurred (oracle forms 11g)
body: <p>I'm struggling to connect to the database using oracle forms 11g. I'm using my machine as a local host using weblogic and XE database. When I try to connect to the database using oracle forms, this error pops</p>
  
  <blockquote>
    <p>"ERROR ORA-12170: TNS:Connect timeout occurred"</p>
  </blockquote>
  
  <p>Here are the files
  C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN</p>
  
  <p><strong>listener</strong></p>
  
  <pre><code>SID_LIST_LISTENER =
    (SID_LIST =
      (SID_DESC =
        (SID_NAME = PLSExtProc)
        (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
        (PROGRAM = extproc)
      )
      (SID_DESC =
        (SID_NAME = CLRExtProc)
        (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
        (PROGRAM = extproc)
      )
    )
  LISTENER =
    (DESCRIPTION_LIST =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
        (ADDRESS = (PROTOCOL = TCP)(HOST = NB**MyIP**.com)(PORT = 1521))
      )
    )
  DEFAULT_SERVICE_LISTENER = (XE)
  </code></pre>
  
  <hr>
  
  <p><strong>sqlnet</strong></p>
  
  <pre><code># This file is actually generated by netca. But if customers choose to
  # install "Software Only", this file wont exist and without the native
  # authentication, they will not be able to connect to the database on NT.
  SQLNET.AUTHENTICATION_SERVICES = (NTS)
  </code></pre>
  
  <hr>
  
  <p><strong>tnsnames</strong></p>
  
  <pre><code>XE =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = NB**MyIP**.com)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = XE)
      )
    )
  EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )
      (CONNECT_DATA =
        (SID = PLSExtProc)
        (PRESENTATION = RO)
      )
    )
  ORACLR_CONNECTION_DATA =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )
      (CONNECT_DATA =
        (SID = CLRExtProc)
        (PRESENTATION = RO)
      )
    )
  </code></pre>
  
  <p>I also changed</p>
  
  <pre><code>HOST = NB**MyIP**.com)(PORT = 1521)) to
  HOST = localhost)(PORT = 1521))
  </code></pre>
  
  <p>and copied all files to C:\Oracle\Middleware10_3\asinst_1</p>
  
  <p>and copied tnsnames to<br>
  C:\Oracle\Middleware10_3\asinst_1\config</p>
  
  <p>I have another C:\Oracle\Middleware\Oracle_Home for JDeveloper.</p>
  
  <p>I don't have technical experience to solve it.</p>
  
  <p><a href="http://i.stack.imgur.com/Z49E1.jpg" rel="nofollow">http://i.stack.imgur.com/Z49E1.jpg</a></p>