This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Jul 26, 2013 10:09 AM by EdStevens RSS

Unable to Connect to DB - ORA-12170 : TNS : Connection Time Out Occurred

DashtheEnigmatic Newbie
Currently Being Moderated

Pls help me to connect to my Database

 

OS : Windows 7 - 64 bit

Oracle 11g

PL/SQL Developer Version : 9.0.1.1613

 

SQLNET.ORA file as below

# sqlnet.ora Network Configuration File: C:\app\DASH\Oracle\product\11.1.0\db_1\network\admin\sqlnet.ora

# Generated by Oracle configuration tools.

# 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)

 

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

---------------------------------------------------------------------------------------------------------------------------------------------------------------

TNSNAMES.ORA as below

# tnsnames.ora Network Configuration File: C:\app\DASH\Oracle\product\11.1.0\db_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

 

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.7)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

---------------------------------------------------------------------------------------------------------------------------------------------------------------

LISTENER.ORA ( I have modified this file as per suggestion from other thread - not sure if this is correct )

# listener.ora Network Configuration File: C:\app\DASH\Oracle\product\11.1.0\db_1\network\admin\listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = C:\app\DASH\Oracle\product\11.1.0\db_1)

      (PROGRAM = extproc)

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.7)(PORT = 1521))

    )

  )

---------------------------------------------------------------------------------------------------------------------------------------------------------------

PLS HELP ME..... Thanks in advance

1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points