No question at this time
DBA Top 10
1 M. Cadot 17000
2 A. Kavsek 14300
3 B. Vroman 10300
4 M. Hidayathullah ... 8400
5 T. Boles 4900
6 P. Wisse 4400
7 J. Schnackenberg 3500
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 800
9 T. P 800
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48097
Total active users1702
Act. users last 24h1
Act. users last hour0
Registered user hits last week237
Registered user hits last month1339
Go up

Fatal NI connect error 12170
Next thread: oracle asm RPM required for oracle 12c on linux 5.8
Prev thread: Needed help to understand behaviour of sessions parameter

Message Score Author Date
Hi We had to recover our primary database to a ...... James Alcroft Jun 19, 2017, 11:13
Dear James, Please check below mos note and lin...... Mirza Hidayathullah Baig Jun 19, 2017, 11:26

Follow up by mail Click here


Subject: Fatal NI connect error 12170
Author: James Alcroft, United Kingdom
Date: Jun 19, 2017, 11:13, 181 days ago
Os info: Windows 2012
Oracle info: 11.2
Error info: Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production
Time: 18-JUN-2017 17:33:20
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 60
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=86.xxx.yyy.181)(PORT=63441))
Message: Hi

We had to recover our primary database to a backup server, which all went well. Database had been running fine for 5 weeks, but in the last weeks I am seeing a number of errors in the trace files, as per the error message below.

The IP address can sometimes be the application server connected to this database. Sometimes it is the public IP for our office network. Yesterday, it was something completely different and not related to our company network.

Is this really a problem? We are suffering random performance issues and my manager is insisting the problem is the database, but I am not convinced.

What should I be looking at to fix this problem?

Many thanks

James
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Fatal NI connect error 12170
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Jun 19, 2017, 11:26, 181 days ago
Message: Dear James,

Please check below mos note and link

Fatal NI Connect Error 12170, 'TNS-12535: TNS:operation timed out' Reported in 11g Alert Log (Doc ID 1286376.1)


https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:9533032800346155822

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here