Re: ORA-12500 TNS:listener failed -- Intermittent

Hello Bob

We had the same thing an it was because the current connections + oracle SGA used up to 2GB limit of memory available for oracle on NT. The solution for us was to lower the size of the block_buffers so the SGA used less memory. The solution that Chaim talks about works only on NT Enterprise version. We are on standard version so it did not worked for us.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, August 15, 2002 11: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: 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-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: Yechiel Adar
  INET: adar76_at_inter.net.il

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).