Hello,
In one of our legacy database/application we are getting ORA-12170: TNS:Connect timeout occurred from app server, app is getting connected using thin client (i.e there is no Oracle client installed). I was troubleshooting this issue with instant client and this is the outcome.
When I tried to connect through sqlplus with a TNS entry, I get ORA-12170
[root@app1 | 08:26:36 instantclient_10_2]$ ./bin/sqlplus system@EPDB
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jun 21 08:26:46 2016
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Enter password:
ERROR:
ORA-12170: TNS:Connect timeout occurred
When I tried to connect through sqlplus with the connection string am getting connected
[root@app1 | 08:27:58 instantclient_10_2]$ ./bin/sqlplus system@'(DESCRIPTION=(ADDRESS=(PROTOCOL =TCP)(HOST=e68)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=e69)(PORT=1521))(FAILOVER=on)(LOAD_BALANCE=on)(CONNECT_DATA=(SERVICE_NAME=EPDB)))'
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jun 21 08:28:31 2016
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL>
I have checked the firewall and its been disabled already,
Can you please help me troubleshoot this issue?
-J