| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: User disconnects (ora-0311) and tracing
We had the same problem and fixed it by placing the line "SQLNET.EXPIRE_TIME = 10" in our $TNS_ADMIN/sqlnet.ora file. It was caused by the firewall expiring idled connections.
Hope this helps.
--Michael
-----Original Message-----
Sent: Tuesday, November 13, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L
Sun Solaris 2.6; Oracle 8.0.5
We've been fighting a problem for several days. It's getting worse. And it's causing MAJOR heartburn. (How bad is it? It's SO bad that the vice president has been assigned the task of following IS staff members around to see what we're doing and reporting back on our progress to the president. It's real embarrassing for him when I go to the bathroom.)
Of the 70 to 80 users we have connected to Oracle, several (usually around 12 to 15) users are disconnected from the database all at once with an "end of file on communication channel". Other users remain on. Not always the same users disconnected. No commonality that we can find.
There's nothing in the alert log, and there are no trace files created. Oracle knows nothing about the disconnected users -- they remain connected to the database from the server side 'till pmon comes along to clean them up.
FINALLY, my question. Oracle has suggested that we turn on trace event 10046. I confess I've never done this before. In svrmgrl, I issue the command oradebug setorapid nnnnn, then oradebug event 10046 trace name context forever, level 12. This worked 1 time for 1 user. It created a trace file in the udump directory. However, I'd like to set this event on for several users. The command executes without error, but no add'l trace files are created.
What am I missing? Can I only do this for 1 user? Does it have something to do with running MTS? I tried using the setorapid (pid) instead of the setospid (spid), but it made no difference.
Any ideas?
Thanks for any help.
Barb "The chipmunk" dba
P.S. Yes, we do have both our SA's and network folks looking at the problem, as well as several consultants. Everyone is clueless.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Baker, Barbara
INET: bakerb_at_rockymountainnews.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Nov 13 2001 - 16:15:11 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |