Re: ORA-12500 error

Hi Gary,
If you have several hundred connections - get rid of NT. I had a battle with 12500 almost 6 months (since 200 connections on my DB) - now i'm on UnixWare - calm and happy
Vadim Gorbunov
Oracle DBA

Gary Fox wrote:

> Hi,
> Get ORA-12500 "TNS:listener failed to start a dedicated server process"
> trying to connect
> I'm using 8.1.5 on NT
> I can connect locally to my 8.1.5 database using svrmgrl and exp, but not
> with us/pw_at_orcl. Connect a/b works, connect a/b_at_orcl gives ORA-12500.
>
> It was working fine the past year until I recently shutdown and started the
> database.
>
> I checked possible problems found in Metalink notes, all with no success:
> I stopped all extra programs (Web Server, discoverer...) to clear up
> resources
> I changed init.ora to have the instance use less memory
> I increased processes in init.ora
> There are no warnings in NT Event Viewer
> Doesn't matter if I start the listener with either NT services or lsnrctl
> NT listener service is running as system - no change
>
> Is this fixable through SQL*Net or the database? My next thought is to
> uninstall and reinstall SQL*Net. Might that help?
>
> Gary Fox
> Vertex Systems, Inc.
> 310-571-2222
> garyf_at_vertexsystems.com
> www.vertexsystems.com
>
> --
> Author: Gary Fox
> INET: GaryF_at_VertexSystems.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).
Received on Thu May 25 2000 - 11:05:25 CDT