ORA-12170: TNS:Connect timeout occurred
February 03, 2010 19:32:30 Last update: February 04, 2010 16:30:49
This happens when you don't have connectivity to the Oracle server. This could be that the server is not up or you are blocked because of some firewall rules. A typical session looked like this:
Use tnsping to confirm the cause:
C:\>sqlplus scott/tiger@xe SQL*Plus: Release 10.1.0.5.0 - Production on Wed Feb 3 13:27:41 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12170: TNS:Connect timeout occurred Enter user-name: scott@xe Enter password: ERROR: ORA-12170: TNS:Connect timeout occurred
Use tnsping to confirm the cause:
C:\>tnsping xe TNS Ping Utility for 32-bit Windows: Version 10.1.0.5.0 - Production on 03-FEB-2 010 11:54:02 Copyright (c) 1997, 2003, Oracle. All rights reserved. Used parameter files: C:\work\globaltnsnames\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = delta)(Port = 1521))) (CONNECT_DATA = (SID = XE))) TNS-12535: TNS:operation timed out
Easy email testing with http://www.ximailstop.com
