Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: TNS-12203: TNS:unable to connect to destination
Richard,
What is the size of your SGA? and the memory on your server.?
The reason I ask is that a friend of mine has a NT server with 4GIG memory =
and 1.5GIG SGA. Only 25 connections are allowed. If the SGA is reduced to =
1GIG all connections are allowed. I have not heard the final resolution =
but I thing that it has to do with the memory allocation and usage =
combination. Oracle is using more memory for the binaries and each =
connection and the memory allocated gets used up.
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:18:24 CST
![]() |
![]() |