"ORA-12170: TNS:Connect timeout occurred" While Trying To Connect To A Newly Upgraded 19.11 Database Using Jdbc (Doc ID 2794952.1)

Last updated on MARCH 12, 2024

Applies to:

Symptoms

Connections to a newly upgraded 19.11 database using JDBC 19c fail with the error shown below.
Connections succeed against a 12.1 or 19.9 database.


ERROR
-----------------------
SQLcl connect times out with
Error Message = IO Error: Connection reset by peer, Authentication lapse 0 ms.

The alert log on the affected database reports:
===

Fatal NI connect error 12170, connecting to:
 (ADDRESS=(PROTOCOL=tcp)(HOST=<HOSTNAME>)(PORT=<PORT>))
  VERSION INFORMATION:
  TNS for Linux: Version 19.0.0.0.0 - Production
  Oracle Bequeath NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
  TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
  Version 19.11.0.0.0
  Time: 25-JUL-2021 13:30:43
  Tracing not turned on.
  Tns error struct:
  ns main err code: 12535

TNS-12535: TNS:operation timed out
  ns secondary err code: 12606
  nt main err code: 0
  nt secondary err code: 0
  nt OS err code: 0
2021-07-25T13:30:43.083980-05:00
opiodr aborting process unknown ospid (31628) as a result of ORA-609
Errors in file /<DIR>/<INSTANCE NAME>_ora_31628.trc:
ORA-00609: could not attach to incoming connection
ORA-12170: TNS:Connect timeout occurred
2021-07-25T13:30:56.085301-05:00

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.