Denham, Most likely you're hitting the 3GB process limit (or 2GB if you haven't enabled the process to grow past 2GB). See Note: 46001.1 "Oracle Database and the Windows NT memory architecture, Technical Bulletin" for more details. Check the memory used by the oracle.exe process in task manager. If you're already hitting the 3GB limit, then you should consider using MTS connections instead of dedicated server connections. Also make sure that sort_area_size and sort_area_retained_size are not set too high. HTH, -- Anita --- Denham Eva <[EMAIL PROTECTED]> wrote: > 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 __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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).
