Re: Memory fragmentation or Windows limitation?

Shailesh wrote:
> Hello,
>
> RDBMS Version: 8.1.7.4.1
> Operating System and Version: Windows 2000 Advanced Server
>
> All OS and Server version details are mentioned above, although single
> instance can take 2GB of memory on Windows, when Oracle.exe reaches
> 1.7GB, we start getting this error. Total SGA size is 1.1 GB, 400
> sessions and dedicated server mode. So initially we reduced SGA size by
> reducing DB_BUFFER_CACHE. But again hit same error...
>
> 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
> 32-bit Windows Error: 8: Exec format error
>
> Now we have inserted /3 GB parameter in boot.ini and also reduced SGA
> by 100 MB. In long term we are planning to use Multi Threaded server.
> What else can be done to avoid this error? Is this windows issue of
> memory fragmentation when application sessions are connected and
> disconnected frequently? please help us.
>
> Thanks & Regards,
>
> Shailesh

(Make sure you have /3GB without a space in the middle.) How about appending /PAE to the line in boot.ini? See Note:225349.1. Failing that, reduce stack size in oracle.exe with orastack.

I have a note about TNS-12500 at
http://rootshell.be/~yong321/oranotes/12500.txt

Yong Huang Received on Thu Jan 12 2006 - 13:24:18 CST