Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Fatal NI connect error 12170 / TNS-12535: TNS:operation timed out in my database server

Future DBAMar 11 2022 — edited Mar 11 2022

Hi all,
For a few days, I have this problem on my Database.
<code>Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 12.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 12.2.0.1.0 - Production
Time: 11-MAR-2022 13:03:41
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12609
nt main err code: 0
nt secondary err code: 0</code>
I added this SQLNET.EXPIRE_TIME=10 in the sqlnet.ora of my server, but the problem persists.

Can someone help me, it is my production database.

Comments

Post Details

Added on Mar 11 2022
#general-database-discussions
4 comments
885 views