ORA-12540 oracle on windows



Check the lister.log file

19-MAY-2008 16:52:20 * (CONNECT_DATA=(SERVICE_NAME=bsnl)(CID=(PROGRAM=C:\ORANT\BIN\ifrun60.EXE)(HOST=DOTSOFT)(USER=DOT))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.165.2.72)(PORT=1626)) * establish * bsnl * 12500
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



increase  PROCESSES  parameter

 alter system set processes=1000 scope=both;

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post