Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle 9i refuses to allow client connection -- I need some h elp.
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C352A6.714964F0
Content-Type: text/plain;
charset="iso-8859-1"
Check Task Manager, Physical Memory, and Peak Memory Used.
If Peak Memory Used is getting close to half of Physical Memory, your server is running out of memory resources for user sessions because in Windows2000 the OS splits memory half and half between user and kernel processes, and Oracle runs as a user process.
We had a 4G Windows2000 server that stopped accepting user connections for about 5 minutes because its memory usage had reached 1.4G of memory. We had a problem on an iAS server when it hit 1.6G or memory used. The workarounds are either add more memory or shrink the size of your SGA(s) to allow for the memory allocation limitations.
Solution? Windows2000 Advanced Server lets you put a /3G switch in the boot.ini file, but that would only give you access to 75% of your server's memory. (I also read on the 'net that W2K AS comes with SQL Server built-in, I don't know if that's true). Needless to say, Windows Advanced Server costs more than Windows2000 Server.
I'd be curious to know if you were at or near half your physical memory used.
Patrice.
-----Original Message-----
From: Farnsworth, Dave [mailto:DFarnsworth_at_Ashleyfurniture.com]
Sent: Friday, July 25, 2003 9:49 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle 9i refuses to allow client connection -- I need some
help.
Might find something in your SID<ALRT>.log. This is in your Oracle_home\admin\bdump directory. Might also find something in your Oracle_home\network\log\listener.log depending on if any tracing is enabled. I used to have this problem. Found that stopping and restarting my listener service a few times a week took care of it. Also adding more memory helped. I had a TAR with Oracle on this and they recommended the stopping and restarting the listener service. I am on windoze though so it may be a platform dependent thing, not like M$ has any issues with their OS. ;o)
Dave
-----Original Message-----
From: Wolfe Stephen S GS-11 6 MDSS/SGSI
[mailto:Stephen.Wolfe_at_macdill.af.mil]
Sent: Friday, July 25, 2003 6:35 AM
To: Multiple recipients of list ORACLE-L
Subject: Oracle 9i refuses to allow client connection -- I need some help.
I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle
DBA courses, the
training has been approved, just hasn't been funded.
Anyway, the only things I do are add, modify, and reset application users'
password via EM and run
patching scripts via SQL-Plus. The application I have running on this
particular 9i server is TPOCS,
Third Party Outpatient Collection System -- a billing system for the DoD's
Military Health System (MHS).
Oracle 9i is running on a Windows 2000 server.
Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net
-- I'm still learning about that
mechanism. Here's my problem. Occasionally, Oracle refuses to let any
client connect to it -- it does this about
every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS
helpdesk recommended we increase the
ram on the server from 512MB to 1GB. Then the problem started occurring
every 7 to 8 days. To make the problem
go away I reboot the server -- it only takes 10 minutes, however, I feel
this a very poor work-around.
Which logs could I look in that would give you guys more information (like
an error code) on why Oracle refuses
client connections and then how would we make this problem go away. it is
becoming a PITA.
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
stephen.wolfe_at_macdill.af.mil
(813) 827-9974 DSN 651-9974
------_=_NextPart_001_01C352A6.714964F0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=965091012-25072003><FONT face=Arial color=#0000ff size=2>Check
Task Manager, Physical Memory, and Peak Memory Used.</FONT></SPAN></DIV>
<DIV><SPAN class=965091012-25072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=965091012-25072003><FONT face=Arial color=#0000ff size=2>If
Peak Memory Used is getting close to half of Physical Memory, your server is
running out of memory resources for user sessions because in Windows2000 the OS
splits memory half and half between user and kernel processes, and Oracle runs
as a user process.</FONT></SPAN></DIV>
<DIV><SPAN class=965091012-25072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=965091012-25072003><FONT face=Arial color=#0000ff size=2>We had
a 4G Windows2000 server that stopped accepting user connections for about 5
minutes because its memory usage had reached 1.4G of memory. We had a
problem on an iAS server when it hit 1.6G or memory used. The workarounds
are either add more memory or shrink the size of your SGA(s) to allow for the
memory allocation limitations.</FONT></SPAN></DIV>
<DIV><SPAN class=965091012-25072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=965091012-25072003><FONT face=Arial color=#0000ff
size=2>Solution? Windows2000 Advanced Server lets you put a /3G switch in
the boot.ini file, but that would only give you access to 75% of your server's
memory. (I also read on the 'net that W2K AS comes with SQL Server
built-in, I don't know if that's true). Needless to say, Windows Advanced
Server costs more than Windows2000 Server.</FONT></SPAN></DIV>
<DIV><SPAN class=965091012-25072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=965091012-25072003><FONT face=Arial color=#0000ff size=2>I'd be
curious to know if you were at or near half your physical memory
used.</FONT></SPAN></DIV>
<DIV><SPAN class=965091012-25072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=965091012-25072003><FONT face=Arial color=#0000ff
size=2>Patrice.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Farnsworth, Dave
[mailto:DFarnsworth_at_Ashleyfurniture.com]<BR><B>Sent:</B> Friday, July 25, 2003
9:49 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B>
RE: Oracle 9i refuses to allow client connection -- I need some
help.<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=984534411-25072003>Might find something in your
SID<ALRT>.log. This is in your Oracle_home\admin\bdump
directory. Might also find something in your
Oracle_home\network\log\listener.log depending on if any tracing is
enabled. I used to have this problem. Found that stopping and
restarting my listener service a few times a week took care of it. Also
adding more memory helped. I had a TAR with Oracle on this and they
recommended the stopping and restarting the listener service. I am on
windoze though so it may be a platform dependent thing, not like M$ has any
issues with their OS. ;o)</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=984534411-25072003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=984534411-25072003>Dave</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Wolfe Stephen S GS-11 6
MDSS/SGSI [mailto:Stephen.Wolfe_at_macdill.af.mil]<BR><B>Sent:</B> Friday, July
25, 2003 6:35 AM<BR><B>To:</B> Multiple recipients of list
ORACLE-L<BR><B>Subject:</B> Oracle 9i refuses to allow client connection --
I need some help.<BR><BR></DIV></FONT>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>I'm an Oracle
administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses,
the</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>training has been
approved, just hasn't been funded. </FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>Anyway, the only
things I do are add, modify, and reset application users' password via EM
and run</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>patching scripts via
SQL-Plus. The application I have running on this particular 9i server
is TPOCS,</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>Third Party
Outpatient Collection System -- a billing system for the DoD's Military
Health System (MHS).</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>Oracle 9i is running
on a Windows 2000 server.</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>Anyway, the TPOCS
client is a PowerBuilder client and connects via SQL-Net -- I'm still
learning about that</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>mechanism.
Here's my problem. Occasionally, Oracle refuses to let any client
connect to it -- it does this about</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>every 7 to 8
days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk
recommended we increase the </FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>ram on the server
from 512MB to 1GB. Then the problem started occurring every 7 to 8
days. To make the problem</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>go away I reboot the
server -- it only takes 10 minutes, however, I feel this a very poor
work-around.</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>Which logs could I
look in that would give you guys more information (like an error code) on
why Oracle refuses</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>client connections
and then how would we make this problem go away. it is becoming a
PITA.</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=480212510-25072003><FONT
color=#0000ff></FONT></SPAN> </DIV>
<DIV> </DIV> <DIV> </DIV> <P><B><FONT face=Arial color=#0000ff size=2>v/r</FONT></B> </P> <P><B><FONT face=Arial color=#0000ff size=2>Stephen S. Wolfe, GS-11,DAFC</FONT></B> <BR><B><FONT face=Arial color=#0000ff size=2>Data Services Manager</FONT></B> <BR><B><FONT face=Arial color=#0000ff size=2>stephen.wolfe_at_macdill.af.mil</FONT></B> <BR><B><FONT face=Arial Received on Fri Jul 25 2003 - 07:15:31 CDT
![]() |
![]() |