Skip to Main Content
  • Questions

  • ORA-12535: TNS: operation timed ORA-609 opiodr aborting process

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Meghana.

Asked: May 04, 2017 - 6:30 am UTC

Last updated: May 11, 2017 - 5:31 am UTC

Version: 11.2.0.3

Viewed 10K+ times! This question is

You Asked

ORA-12535: TNS: operation timed along with this ORA-609 opiodr aborting process as the secondary error.While this error is occurring tnsping takes longer than expected and SQLPLUS / also is taking too much time ,ping using the IP is working fine .There are no evident network glitches or memory/CPU utilization spikes. sqlnet.inbound_connect_timeout parameter has been increased to 240s and inbound_connect_timeout=120s has been added to listener.ora. Still error still persists and connections are getting timeout.

and Connor said...

Take a look at

Troubleshooting Guide for TNS-12535 or ORA-12535 or ORA-12170 Errors (Doc ID 119706.1)

There is a *large* list of potential cause, but it also describes how to setup a detailed level sqlnet trace to identify the cause.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.