ORA-12170

ORA-12170: TNS:Connect timeout occurred

1.Firewall is disable.
2.configure sqlnet.inbound_connect_timeout in SQLNET.ORA file
3.if you install ORACLE EXPRESS EDITION then configure TNSNAMES.ORA file for specified SERVICE_NAME.


C:\>tnsping fak

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 31-MAR-2
007 19:23:24

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\sqlnet.ora

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTO
COL=TCP)(HOST=192.168.100.106)(PORT=1521)))
TNS-12535: TNS:operation timed out

C:\>tnsping fak

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 31-MAR-2
007 19:52:18

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.100.64)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = fak)))
OK (90 msec)


SQL> conn sys@fak as sysdba
Enter password:
ERROR:
ORA-12170: TNS:Connect timeout occurred


SQL> conn sys@fak as sysdba
Enter password:
Connected.
SQL>


Note: on my system i am install Oracle 10gr1 or Oracle XE. but service_name FAK i am just configure TNSNAMES.ORA file belong to Oracle 10gr1 instead of Oracle XE. WHEN i configure TNSNAMES.ORA file of Oracle XE and add service_name (FAK) PROBLEM SOLVE.