Re: ORA

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: jkstill_at_cybcon.com

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: ListGuru_at_fatcity.com (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).