Hello,

Looks like you're running out of physical RAM on your windows server,
stopping the listener spawning new server processes. How much RAM do have?
If your machine has plenty of RAM free its likely your running into 32-bit
Windows RAM limitations i.e. oracle.exe can only address upto 2GB total
address space. We had similar issues under full load and utlised a) the /3G
switch in the boot.ini to use and extra 1G from the kernel b) MTS - which
helped massively, until we eventually moved to Linux (hurrah!). There's
plenty of good docs on metalink which explain the issues in more depth,
search for TNS-12540, TNS-12500.

If you can reduce your SGA without harming performance too much that will
give you some extra headroom. Also we found perfmon was much better at
showing the address space utilisation(as opposed to task manager) i.e.
performance / process/ Oracle.exe/ virtual bytes.


Regards

Dave Brown
----- Original Message -----
From: "MLi" <oracledba-ezmlmshield-x74462455.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, January 05, 2006 2:50 PM
Subject: TNS-00510: Internal limit restriction exceeded


> Hi,
>
> I got these error massages in listener.log file over last two afternoons.
Sometimes the reconnections were ok. Does anyone have ever have the similar
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
>
> Thanks,
> Michael
>
>
> This communication and any attachments hereto are confidential and contain
information that may be privileged and exempt from disclosure under
applicable law and are intended solely for the use of addressees. If you
are not the intended recipient of this communication (and any attachments),
or the employee or agent responsible for delivering this to the intended
recipient, you are hereby notified that any dissemination, copying or use of
this communication is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by e-mail or
telephone and delete this communication from your system. E-mails are
susceptible to alteration. Neither Princeton Financial Systems, State
Street Corporation nor any of their subsidiaries or affiliates shall be
liable for the message if altered, changed or falsified.
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
> This message has been checked for all email viruses by the Energis
NetscanCentral solution.
>


This message has been checked for all email viruses by the Energis NetscanCentral solution.

Oracle LazyDBA home page