Bob,
We sure have. Your problem comes from end users who do not terminate their
database sessions gracefully. This can come from a number of different places,
like a program that doesn't log off before closing, or a user who just switches
off their PC. Also certain versions of MicroSoft ODBC for Oracle, anything
before 2.57, disconnect improperly too. At any rate the dedicated server
process has not cleanly terminated leaving a mess behind. Now since MicroSoft
never heard of TCPKeepAlive and it's not in their kernel your ONLY option is to
reboot, like we do at 00:00:01 Sunday morning.
Well OK, you do have other options, like upgrade to Linux.
Dick Goulet
____________________Reply Separator____________________
Author: Bob Robert <[EMAIL PROTECTED]>
Date: 8/15/2002 1:58 PM
Gurus,
Oracle Version: 8.0.4 (I know we are way behind)
OS: Windows NT (Service Pack 6)
Physical Memory: 1.5 GB
Virtual Memory: 1.5 GB
Once in every week, we get "TNS-12500 TNS:listener
failed to start a dedicated server process". When I
check listener process, it was running. When I check
number of sessions, it was always below number
processes (setup by init.ora file). Whenever we get
this error message, one out of fifteen sessions get
successful connection. When we check system resources,
we had enough free memory in the system.If we try to
stop listener process and restart again, it works for
a while (may be 30 Min.). We couldn't find any error
messages both in alert log file as well as OS event
log.
Only solution, we had right now is to reboot the NT
server in the middle of production time. Users are
getting frustrated whenever we reboot the server.
I think upgrading database to 8i or 9i would help our
problem. But, we are not in a position to do so.
I think there might be memory leakage which we could
not see from the OS Task Manager.
Did any one come across similar kind of problem. I
would appreciate if you could share your experience
with me.
Thanks,
Bob
__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bob Robert
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
