Re: ORA-12500: TNS:listener failed to start a dedicated server process

Hi guys

Thanks for all your help. I am putting the area from the listener.log where the error started.

27-AUG-2005 17:22:45 *
(CONNECT_DATA=(sid=income)(server=dedicated)(CID=(PROGRAM=C:\new80\new80.exe)(HOST=NEW80)(USER=BY)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.4.4)(PORT=2745)) * establish * income * 12560
TNS-12560: TNS:protocol adapter error
 TNS-00517: Lost contact
  32-bit Windows Error: 54: Unknown error    TNS-12500: TNS:listener failed to start a dedicated server process     TNS-12547: TNS:lost contact

     TNS-12560: TNS:protocol adapter error
      TNS-00517: Lost contact
       32-bit Windows Error: 54: Unknown error

Next instance of the same error in listener.log

28-AUG-2005 00:42:28 *
(CONNECT_DATA=(sid=income)(server=dedicated)(CID=(PROGRAM=C:\new80\new80.exe)(HOST=NEW80)(USER=BY)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.4.4)(PORT=4751)) * establish * income * 12560
TNS-12560: TNS:protocol adapter error
 TNS-00517: Lost contact
  32-bit Windows Error: 54: Unknown error    TNS-12500: TNS:listener failed to start a dedicated server process     TNS-12547: TNS:lost contact

     TNS-12560: TNS:protocol adapter error
      TNS-00517: Lost contact
       32-bit Windows Error: 54: Unknown error

Next Instance

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

I have the processes parameter set to 200.

In the last third instance of the error, I see internal limit restriction exceeded. As I said in my original post, if I look at the database connections at any given time(thru enterprise manager), it had never been anything more than 30 connections. Is there some other parameter to be looked for ??

Thanks in advance

Brijesh Mathew Received on Mon Aug 29 2005 - 11:39:50 CDT