Re: Help with Windows error - I have this issue as well - Not urgent UPDATE some resolve

thanks. This is what I have so far
  Versions of Microsoft the same and same for db   Yes we were at 3G but we were getting 100 less connections with nothing different    

  Took out sga_max_size bounced computer and got 100 connections back.   question is why this did not affect the old database and yes it was in as a parameter.    

  The old machine compact 8000
  The new machine dell 6850 - does have more ram,etc    

  Went through registry, machine settings, still haven't seen what the deal is.    

  Going to try orastack.exe to shrink things down to 768K, don't know if 512K will work    

  Not going to try the PAE switch as I found some cool features involving memory leaks    

  Did try to split the pagefile on the app server and database (per Oracle support) on two different virtual drive - NO AFFECT    

  did try to reduce the db_cache_size - NO AFFECT    

  did try to reduce shared_pool - negative affect on db. put back up as we were pretty small anyway.    

  3G switch DOES help and I did test this. Went from not being able to get to 200 connections to over 400 (without sga_max_size)    

  Used swingbench to test. very cool very helpful. very free.    

  I will let you know how the orastack turns out. I think it will work, but I am not sure how the 3rd party app will work.    

  Kathy
  and miles to go before I sleep   

Giovanni Cuccu <giovanni.cuccu_at_gmail.com> wrote:   Hi Kathy,
I run into a similar issue some time ago. Here is my experience:
if in the listener.ora you have:
32-bit Windows Error: 8: Exec format error you are hitting a memory limit.
To determine what the mory limit is you have to open performance monitor in administrative tools, select process in the performance voice combo and the oracle process in the list that appears on the rigth of the window. Choose virtual bytes between the options on the left and you can see what happens. If you got the error while the virtual bytes is around 1,7gb you are unable to use the /3GB switch (or /PAE or whatever).
I clearly remeber that on win2000 (not the 2003 you have) standard the 3GB switch has no effect you need an higher os version. On 2003 the situation is a little more complicated, but I have to do some more investigations.
Hope it helps,
Giovanni

On 7/24/06, kathy duret wrote:
>
> Riddle me this. Used to get over 500 connections, now only 400 on windows
> before I hit error
>
> Windows 2003, 32bit 9.2.0.6
>
> Yes I have a sev 1 tar open with Oracle and they haven't been able to solve
> my issue. No, I can't upgrade from 9.2.0.6 to 10 on 3rd party application
> and not certified.
> No new applications deployed, no program changes in.
>
> I have these errors:
> TNS-12500: TNS:listener failed to start a dedicated server process
> TNS-12540: TNS:internal limit restriction exceeded
> TNS-12560: TNS:protocol adapter error
> TNS-00510: Internal limit restriction exceeded
>
> Moved to a new dell 6850 box and clone of 9.2.06 database this weekend.
> Everything is the same that I can tell except :
>
> The parameters are all the same EXCEPT db_cache size which I DECREASED by
> almost 1/2 per Oracle instructions.
>
> My shared_pool_size is very small, large pool is 32K which I can't decrease
> any more, java pool is 0.
>
> since this was a new OS install on windows, the os and patch levels are the
> SAME.
>
> could there be any register setting that might be different or ?
>
> anyone got a clue, cause Oracle doesn't
>
> Thanks,
>
>
> Kathy
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com

-- 
--------------------------------------------------------------------
Another free oracle resource profiler
http://sourceforge.net/projects/oraresprof/
Now version 0.9


 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--
http://www.freelists.org/webpage/oracle-l