Re: The dreaded TNS-12500 error.
From: lycovian <member38182_at_dbforums.com>
Date: Thu, 04 Sep 2003 18:31:34 -0400
Message-ID: <3332434.1062714694_at_dbforums.com>
Date: Thu, 04 Sep 2003 18:31:34 -0400
Message-ID: <3332434.1062714694_at_dbforums.com>
Had the same problem. In our case the oracle.exe process was crossing 3GB boundry. Try this, monitor the Virtual Bytes of your application with PERFMON. Watch the VB count rise as users log in. You may see that as you cross the 3GB Virtual Bytes boundry that you get this error. If that is the case then your user count (~2.7MB/user) is slowly driving you over the max process size that Win2K allows with the /3GB boot.ini switch enabled. If that is the case recommend a) switching to MTS and b) resizing your SGA such that it fits completely with in the 3GB boundry.
-- Posted via http://dbforums.comReceived on Fri Sep 05 2003 - 00:31:34 CEST