Skip to Main Content

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!

ORA-3136; ORA-609

Tom ShenAug 29 2011 — edited Sep 1 2011
Today I did the monthly check for the oracle databaes for customer. I found two Errors. Please help me check about this.

Oracle version:Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
Operatoin System version:HP-UX IA (64-bit) B.11.31

Error One
Description:Almost every morning this error can be found in the alert log file and coming from same server.
Question:Whether the reason for this error is time out, or it is caused by the application?
Content
Mon Aug 01 01:36:56 2011


***********************************************************************

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for HPUX: Version 11.1.0.7.0 - Production
Oracle Bequeath NT Protocol Adapter for HPUX: Version 11.1.0.7.0 - Production
TCP/IP NT Protocol Adapter for HPUX: Version 11.1.0.7.0 - Production
Time: 01-AUG-2011 01:36:57
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNSperation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=198.120.1.24)(PORT=53239))

Wed Aug 03 01:23:05 2011


***********************************************************************

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for HPUX: Version 11.1.0.7.0 - Production
Oracle Bequeath NT Protocol Adapter for HPUX: Version 11.1.0.7.0 - Production
TCP/IP NT Protocol Adapter for HPUX: Version 11.1.0.7.0 - Production
Time: 03-AUG-2011 01:23:05
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNSperation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=198.120.1.24)(PORT=53466))
WARNING: inbound connection timed out (ORA-3136)

Error 2
Question:I have checked the problem online. The reason seems to be the oracle bug. Bug id 7659739;
Is it right? Is there any solution for this problem and what reason or issue will trigger this problem?
Content
Sat Aug 06 01:30:47 2011


***********************************************************************

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

VERSION INFORMATION:
TNS for HPUX: Version 11.1.0.7.0 - Production
Oracle Bequeath NT Protocol Adapter for HPUX: Version 11.1.0.7.0 - Production
TCP/IP NT Protocol Adapter for HPUX: Version 11.1.0.7.0 - Production
Time: 06-AUG-2011 01:30:47
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
ORA-609 : opiodr aborting process unknown ospid (21632_1)

Sun Aug 07 01:20:15 2011


***********************************************************************

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

VERSION INFORMATION:
TNS for HPUX: Version 11.1.0.7.0 - Production
Oracle Bequeath NT Protocol Adapter for HPUX: Version 11.1.0.7.0 - Production
TCP/IP NT Protocol Adapter for HPUX: Version 11.1.0.7.0 - Production
Time: 07-AUG-2011 01:20:15
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
ORA-609 : opiodr aborting process unknown ospid (4394_1)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2011
Added on Aug 29 2011
2 comments
1,409 views