Re: ORA

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Mon, 02 Jul 2001 05:13:21 -0700
Message-ID: <F001.0033F041.20010702051632@fatcity.com>

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 <EvaD_at_TFMC.co.za> 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: abardeen1_at_yahoo.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).

Received on Mon Jul 02 2001 - 07:13:21 CDT