| 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: ORA-12500 TNS:listener failed -- Intermittent
Bob,
We've had a symtoms like that (Oracle 7.3 and windows NT). In our case it
was related to the size of the Oracle executable on windows - it grows
dynamically based on the number of connections (and how much work the
connections are doing?) but it normally can't grow larger than 2Gb because
of limits in windows. The db buffers, the pools, and the the memory for
each connected user (4mb? per session) adds up pretty quickly. We had db
block buffers of about 700Mb and a couple of hundred sessions. The
solution that worked for us (it's in the docs and in metalink) was to add a
switch to windows boot.ini file which will allow Oracle to grow up to 3Gb.
Chaim
Bob Robert <mssql_2002_at_yahoo.com>@fatcity.com on 08/15/2002 05:58:30 PM
Please respond to ORACLE-L_at_fatcity.com
Sent by: root_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: mssql_2002_at_yahoo.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Fri Aug 16 2002 - 09:39:13 CDT
(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: Chaim.Katz_at_Completions.Bombardier.com 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: 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).
 |
 |