[Solved] TNS Connection Timeout Issue Between Application and Database Servers

The issue may be due to one or more of the following scenarios. Please check and address each of these:

1. Verify if there is a network issue between the client and the server by ensuring you can ping the server from your client machine.
2. Confirm that the TNS listener on the Oracle server is active and running.
3. Ensure that the TNSNAMES.ORA file on the client side contains the correct configuration details for the Oracle database.
4. Check that no firewall is obstructing the connection between the client and the server.

Please review the information highlighted below. If you have any insights or suggestions, please let me know.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.53.0.48)(PORT=1521)))

STATUS of the LISTENER

Alias: LISTENER
Version: TNSLSNR for 64-bit Windows: Version 19.0.0.0.0 - Production
Start Date: 01-AUG-2024 17:57:39
Uptime: 0 days 0 hr. 26 min. 41 sec
Trace Level: off
Security: ON: Local OS Authentication
SNMP: OFF
Listener Parameter File: D:\app\oracle\product\19.0.0\dbhome_1\network\admin\listener.ora
Listening Endpoints Summary

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.53.0.48)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=SINPORCLDB003.gigroup.local)(PORT=5500))(Security=(my_wallet_directory=D:\APP\admin\orcl\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary

Service "CLRExtProc": 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service.
Service "orcl": 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service.
Service "orclXDB": 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service.
The command completed successfully.

The issue appears to be related to the connection of two services.

Could you please check and confirm if this issue has been resolved? If not, please share your Anydesk or UltraViewer details so we can connect and investigate further