I'm after a little guidance and insight from the collective.
We are seeing the following errors in the Listner.log when the connection numbers get fairly high (approx 700 connections). We are running 8.1.7 on NT SP6a (the box has 2GB), initially the SGA was configures to use about 1.2GB...we reduced this when we hit these errors to 950Mb (to give the OS more resource) and this had the effect of increasing the number of connection before the errors returned.
Has anyone seen this before and how can it be avoided - apart from moving to Unix ;-)
03-MAY-2002 09:53:40 * (CONNECT_DATA=(SERVICE_NAME=cad2)(CID=(PROGRAM=C:\win32app\ingr\ICALL\bin\icall.exe)(HOST=STRE111418 Q)(USER=JamesKX))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.131.90)(PORT=1638)) * establish * cad2 * 12500
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