Fatal NI connect error 12637

crishna1
crishna1 used Ask the Experts™
on
Hi,

I noticed the following in teh alert log, any suggestions?

Thanks!

-----------------
Fatal NI connect error 12637, connecting to:
 (LOCAL=NO)

  VERSION INFORMATION:
      TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
      Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
      Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
  Time: 09-FEB-2012 15:28:10
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12637
   
TNS-12637: Packet receive failed
    ns secondary err code: 12532
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
opiodr aborting process unknown ospid (3256) as a result of ORA-609
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
have you installed the correct(compatible) version of the database(seems like more of compatibility issue)

i think for windows7, the oracle database version which you had installed is 64-bit..


what is the version of windows?
by the errors it is visible that database is 11g, which software have you installed(database edtion 32bit/64bit?
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Check the possible resolutions for that error:
http://tns-12637.ora-code.com/

Are you doing any remote connections maybe through a DBLink?

Author

Commented:
It is on a Windows 2008 Server , 32-bit. No connections through DBLink.
-----

also foun this in the windows event viewer, if it has any relevance...i belive this one is from the application connecting to the database...

Faulting application TreksStacker.exe, version 13.1.3, time stamp 0x4d9d7abf, faulting module oracore11.dll, version 11.2.0.1, time stamp 0x4b71e95f, exception code 0xc00000fd, fault offset 0x00092367, process id 0x918, application start time 0x01cce7823437050c.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
If none of the reasons in the link I provided is the cause, I would open an SR with Oracle Support.  You will likely need to turn on tracing to discover the underlying cause.

Author

Commented:
you are right, it looks like this error is happening , after the app crashes, that being the first error...

from the link you provided , i read that the TNS-12637 could be caused due to "The other process was terminated", so i am guessing the app crashing is the issue?
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
>>so i am guessing the app crashing is the issue?

That would be my guess.

You just need to track dates/times the app crashes and see if the dates/times in the alert log are about the same.

Author

Commented:
yes they are, the errors in the log are immediately or at the same time of the app crash.
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Then what is left to answer?  Looks like the error in the alert log is caused by the app crashing.  As long as the app crashing is OK then the error in the alert log is OK.

Author

Commented:
the app crashing needs to be resolved, i guess that is an whole differenet issue.
I just wanted to make sure the error in the Oracle alter log is not causing the app to crash, instead it is caused by the app crash, correct?
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
That is my professional opinion.  Oracle is just reporting that something bad happned and is not the cause.
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Can I ask what additional information I could have provided to get an 'A' grade from you?

Did you just close this out to bypass the new question lock?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial