Peoplesoft XML Publisher Guide

Saturday 29 June 2013

ORA-12170: TNS:Connect timeout occurred

Peoplesoft windows Oracle client 11g R2 not connecting to Oracle database server 11g R2.

ORA-12170: TNS:Connect timeout occurred

Solution:
1) Try to tnsping the oracle database server.

>> tnsping server-name
>> Check for network firewall block
>>Stop the iptables and try again (log on server as root and "/etc/init.d/./iptables stop

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 29-JUN-2013 11:58:16

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

Used parameter files:
D:\app\oracle\product\11.2.0\client_1\network\admin\sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.6.1)(PORT=1521)))
OK (30 msec)

No comments:

Post a Comment