Hi All.
This is an ORDS / Apex installation.
ORDS: ords-23.3.0.289.1830
Apex is version 23
Oracle Database is 19c under Windows (pluggale DB).
I'm ocassionally getting Net Errors (not specifically related to ORDS / Apex, which BTW is running under Tomcat 9).
Like I said I´m suspecting this may not be specifically related to ORDS and Apex. For example I´ve gotten net errors during impdp operations (ocassionally).
Also found this type of errors on alert.log:
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for 64-bit Windows: Version 19.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 19.0.0.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 19.0.0.0.0 - Production
Version 19.21.0.0.0
Time: 22-ABR-2024 14:06:02
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:timeout de la operación
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Timeout de la operación
nt secondary err code: 60
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.70.1)(PORT=51516))
2024-04-22T14:18:10.480240-03:00
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for 64-bit Windows: Version 19.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 19.0.0.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 19.0.0.0.0 - Production
Version 19.21.0.0.0
Time: 22-ABR-2024 14:18:10
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:timeout de la operación
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Timeout de la operación
nt secondary err code: 60
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.70.1)(PORT=12548))
2024-04-22T16:12:55.484022-03:00
***********************************************************************
However, as you can see on the screenshot above, we may be hitting the maximum number of sessions in the pool. So I would like to know:
- How to query the actual value for connection pool used by ORDS.
- How to increase that value.
Thanks so much in advance !!!