TNS-12540: TNS:internal limit restriction exceeded

Actually i have read the one posted question here. however, i am using the port 1531 for better network with SDU and TDU sizes for newly created listener. i monitor the coming in public which looks fine in the early session but after 4-5 hours as the load is auto generated load i see 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
   32-bit Windows Error: 8: Exec format error
in the listener log, i have a new listener service for my application. in this case it doesn't allow me to open a new single session also.

SID_LIST_LSTNR3 =
 (SID_LIST =
   (SID_DESC =
     (SDU = 1460)
     (TDU = 1460)
     (SID_NAME = PLSExtProc)
     (ORACLE_HOME = D:\oracle\ora81)
     (PROGRAM = extproc)
   )
   (SID_DESC =
     (SDU = 1460)
     (TDU = 1460)
     (GLOBAL_DBNAME = mysid)
     (ORACLE_HOME = D:\oracle\ora81)
     (SID_NAME = mysid)
   )
 )

LSTNR3 =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (SDU = 1460)
     (TDU = 1460)
     (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1531))
   )
   (DESCRIPTION =
     (SDU = 1460)
     (TDU = 1460)
     (ADDRESS = (PROTOCOL = IPC)(KEY = mysid))
   )
 )

above is my new entry for the new listener.

i have 8 gig of ram and processes=1750 with 400mb shared pool.

anybody has anything on this, appreciate in advance...i know nothing abt the points maths here, as i am new here... Start Free Trial