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!

Client sees ORA-3113

jr-phDBAJul 26 2016 — edited Jul 28 2016

Client was using a form, and seeing ORA-03113. Is it due to connection issue? I've checked the alert log, based on the time the user received the error. Please see below.


Tue Jul 26 05:50:57 2016


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

Fatal NI connect error 12170.

  VERSION INFORMATION:
        TNS for Solaris: Version 11.2.0.4.0 - Production
        Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.4.0 - Production
        TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.4.0 - Production
  Time: 26-JUL-2016 05:50:57
  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: 145
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=<IP Removed>)(PORT=<Port Removed>))

Can someone advise for workaround to avoid/fix the issue? I'm thinking if there is something to add/change in sqlnet parameter file.

Thank you

This post has been answered by jr-phDBA on Jul 28 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2016
Added on Jul 26 2016
7 comments
753 views