Re: [Run out of connections]

From: S Jayakumar <sjayakumar2000_at_usa.net>
Date: 5 Jan 2001 16:41:37 MST
Message-Id: <10732.125916@fatcity.com>

try mts setup instaed if possible

hoppe this helps

Jay

CC Harvest <ccharvest_at_yahoo.com> wrote:
Hi, Gurus:

I have an application to push/pull data from a database to a datamart(Oracle8i). But somehow, everytime when push, I got the "run out of connection" error. I already have processes=3D200 in initSID.ora file.

So what can I do? How do I check what causes the error? Which process, and why?

Any advice will be highly appreciated. TIA. Nice weekend.

Chris

Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online! http://photos.yahoo.com/
-- =

Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- =

Author: CC Harvest
INET: ccharvest_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).

Get free email and a permanent address at http://www.netaddress.com/?N=3D= 1

From: Winnie_Liu_at_infonet.com
Date: Fri, 5 Jan 2001 15:49:02 -0800
Subject: Re:

No, as of 806, you cannot change it on the fly.

But if you want to find out if you can change this parameter without bouncing the database. Check the v$parameter. It has columns like Received on Fri Jan 05 2001 - 17:41:37 CST