Hello everyone
I’m facing a strange issue with Oracle 11g (11.1.0.6) on Windows Server 2016
Problem: tnsping response time is inconsistent. Sometimes it responds immediately, while other times it takes several seconds
Examples:
OK (0 msec)
OK (4500 msec)
OK (8100 msec)
OK (43110 msec)
Environment:
- Oracle Database 11g Release 11.1.0.6
- Windows Server 2016 Datacenter
- Standalone server (not Active Directory)
- Oracle Listener on TCP port 1521
- Database service name:
gm
What I have already checked:
- Listener is running (lsnrctl status and lsnrctl services are normal)
- Database is OPEN and connects immediately every time
- Tried localhost, server IP in tnsnames.ora
- Network connectivity (ping) is normal
Any suggestions for advanced troubleshooting would be greatly
