Uvaraja wrote:the most common cause for TIMEOUT is a FireWall on or between client & DB Server
I have installed Oracle database 11g(SQL PLUS) and it is working. But I like to work in Toad. So i have installed it and when I tried to open it with same username and password which I gave for oracle database it is not opening.
The user name : scott
Password : tiger.
In my TNS Name Editor :
it showing the below mentioned error
"ORA-12170: TNS:Connect timeout occurred"
Here orcl is the database you are trying to connect.
C:\Documents and Settings\s0891811>tnsping orcl TNS Ping Utility for 32-bit Windows: Version 188.8.131.52.1 - Production on 13-OCT-20 12 10:59:11 Copyright (c) 1997 Oracle Corporation. All rights reserved. Used parameter files: C:\oracle\ora81\network\admin\sqlnet.ora C:\oracle\ora81\network\admin\tnsnames.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 184.108.40.206)(PORT = 1521))) (CONNECT_DATA = (SID = orcl))) OK (70 msec) C:\Documents and Settings\s0891811>