The TNS-0510 error is self explanatory: 00510, 00000, "Internal limit restriction exceeded" // *Cause: Too many files or sockets open simultaneously (or some other // resource has been depleted). // *Action: For further details, trace the operation for protocol // details. There are several entries on MetaLink that deal with this, you should take a look. Also, when asking for help, by supplying the following you may prevent a number of folks from ignoring your message. OS: name and version Oracle: version Platform: brand, how much RAM Jared On Monday 02 July 2001 06:10, Denham Eva wrote: > Hi here's more of the error: > > 02-JUL-2001 13:57:07 * > (CONNECT_DATA=(SERVICE_NAME=maxtfmc)(CID=(PROGRAM=C:\Program > Files\Max411\MAXLOGIN.EXE)(HOST=CENT8000)(USER=HAMILTT))) * > (ADDRESS=(PROTOCOL=tcp)(HOST=165.144.249.68)(PORT=2062)) * establish * > maxtfmc * 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 > I hope this will help... > > -----Original Message----- > Sent: Monday, July 02, 2001 2:25 PM > To: Multiple recipients of list ORACLE-L > > > Hi, > > Please help!, I have a number of clients connecting to a Oracle Database: > Oracle8i Release 8.1.6.0.0 - Production > PL/SQL Release 8.1.6.0.0 - Production > CORE 8.1.6.0.0 Production > TNS for 32-bit Windows: Version 8.1.6.0.0 - Production > NLSRTL Version 3.4.1.0.0 - Production > The problem is that the connections are either being dropped, or are > failing some way. > The Oracle error experienced is : > ORA-12500: TNS:listener failed to start a dedicated server process > > The platform is Windows 2000. > The clients are all running the same oracle version, only the client side, > also on NT/Win 2000. > Please help. This all worked fine during Development:-) > > Regards > Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).