Debugging ORA-12157
Does anyone reading this have experience with debugging ORA-12157 TNS Internal network communication error?
Googling for it isn't really helpful. I get a bunch of pages that say the same thing as the Oracle docs (turn on tracing and reproduce the issue).
The problem is that we don't see it consistently enough to even know to reproduce it properly much less create a minimal test case.
Update:
I looked in the alert.log and found a few "ORA-609 : opiodr aborting process unknown ospid" errors each with a corresponding trace file that ends with "opiino: Attach failed due to ORA-12537".
I'm married with 2 girls. By day, I work as a Senior Design Engineer (full time Perl programmer) for EFJohnson Technologies, a Land Mobile Radio company, in the Dallas/Fort Worth area. By night, I play various games as the mood strikes me. (Lately it's CPAN smoke testing.)
tnsping shows that it is up and accessible every time I have tried it.
According to this page http://it.toolbox.com/wiki/index.php/ORA-12537 the ORA-12537 could be caused by Oracle running out of memory so that's at least something that I can check out.