IBM AIX 6.1 & Newer: TCP Connections Intermittently Failing ORA-12547 , TNS-12547, TNS-12560 and OS Error 32
(Doc ID 1084443.1)
Last updated on JANUARY 18, 2025
Applies to:
Oracle Net Services - Version 10.2.0.4 to 18.1.0.0.0 [Release 10.2 to 18.1]Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
IBM AIX on POWER Systems (64-bit)
Symptoms
Connections to the database via the listener (i.e. TCP) are limited in number and testing reveals that this number is fairly consistent. A shutdown of database and listener will resolve the issue until <n> number of TCP connections is established again. Local or bequeath connections are NOT exhibiting this problem so local connections to the database are not failing at the time that this issue is reproducible.
In our example case, when the number of TCP connections exceeded 500, remote connections started to fail. SQL*Plus connections using TCP failed with ORA-12547 and Tnspings that are launched remotely or on the server are failing with the following error:
The failure to connect would be intermittent because as sockets are freed on the client, newly spawned connections would be successful.
Changes
This is a new installation of IBM AIX 6.1 or the operating system has recently been upgraded to version 6.1. Alternatively, the Traffic regulation policy may have been configured or modified recently.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |