RDBMS Version: 18.104.22.168.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: TNSrotocol 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.