Re: TNS-12203: TNS:unable to connect to destination

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 06 Dec 2000 08:13:14 -0500
Message-Id: <10702.123773@fatcity.com>

Richard,
  What is your system configuration?
OS.
MEMORY.
SGA SIZE.
 The reason I ask is that a friend of mine has a server running NT with = 4GIG memory and SGA of 1.5GIG. In that configuration only 25 connections = were allowed. He reduced the SGA to 1 GIG and all the connections were = allowed. I have not heard the final resolution yet but I suspect it has = something to do with max SGA and memory usage on NT. Thanks,
ROR m=AA=BF=AAm

>>> RICHARD.T.CALE_at_saic.com 12/05/00 04:15PM >>>
Hi All,

Oracle 8.0.5,NT 4.0

I am getting the above error in trying to make new connects. I had = several
connections going,sql*plus,
pro*c program(been working for years,etc. After the pro*c program been running a couple of hours I got
the above error and all other connections are refused. These have been working in the past so I do not
know what is now causing. Of course I can bounce the server and I suspect = I
will be able to connect
but I would like to know what is causing it.

Thanks
Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555
e-mail: caler_at_saic.com=20

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: Cale, Rick T (Richard)
  INET: RICHARD.T.CALE_at_saic.com=20

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 Wed Dec 06 2000 - 07:13:14 CST