TNS Connection Lost

From: Ed Jennings <jenningse_at_mindspring.com>
Date: 1997/10/27
Message-ID: <3454EA4A.23FC@mindspring.com>#1/1

About two weeks ago I enabled the cost based optimizer in a 7.3.2.3 instance. The next day people started reporting sporadic problems getting into the DB via SQLnet. I have been able to reproduce it myself from both unix and windows. As I said it is sporadic. I fail once, but retry immediately and get in. The sqlnet.log file left in my home directory states:

"Fatal OSN connect error 12547"
"TNS-12206: TNS:received a TNS error during navigation"
"TNS-12547: TNS:lost contact"
"TNS-00517: Lost contact"

There are a few other odds & ends, but these are the main messages. I never saw this before using the cost-based optimizer and since it is the only change in many months, I have no choice to suspect it. But for the life of me I can't figure out how the optimizer mode could possibly ffect a connection through SQLnet. Has anyone run into a problem like this? Nay help is *greatly* appreciated.

Ed Jennings
Oracle DBA
EPS, Inc.
Wilmington, DE

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~
jenningse_at_mindspring.com

Received on Mon Oct 27 1997 - 00:00:00 CST