Message-Id: <26013.339597@fatcity.com>
From: "Boivin, Patrice J" <BoivinP@mar.dfo-mpo.gc.ca>
Date: Fri, 25 Jul 2003 09:15:31 -0300
Subject: 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@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@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@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>&nbsp;</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>&nbsp;</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.&nbsp; We had a 
problem on an iAS server when it hit 1.6G or memory used.&nbsp; 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>&nbsp;</DIV>
<DIV><SPAN class=965091012-25072003><FONT face=Arial color=#0000ff 
size=2>Solution?&nbsp; 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.&nbsp; (I also read on the 'net that W2K AS comes with SQL Server 
built-in, I don't know if that's true).&nbsp; 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>&nbsp;</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>&nbsp;</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@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&lt;ALRT&gt;.log.&nbsp; This is in your Oracle_home\admin\bdump 
  directory.&nbsp; Might also find something in your 
  Oracle_home\network\log\listener.log depending on if any&nbsp;tracing is 
  enabled.&nbsp; I used to have this problem.&nbsp; Found that stopping and 
  restarting my listener service a few times a week took care of it.&nbsp; Also 
  adding more memory helped.&nbsp; I had a TAR with Oracle on this and they 
  recommended the stopping and restarting the listener service.&nbsp; I am on 
  windoze though so it may be a platform dependent thing, not like M$ has any 
  issues with their OS.&nbsp; ;o)</SPAN></FONT></DIV>
  <DIV><FONT face=Arial color=#0000ff size=2><SPAN 
  class=984534411-25072003></SPAN></FONT>&nbsp;</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@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.&nbsp; </FONT></SPAN></DIV>
    <DIV><SPAN class=480212510-25072003><FONT 
    color=#0000ff></FONT></SPAN>&nbsp;</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.&nbsp; 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>&nbsp;</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.&nbsp; 
    Here's my problem.&nbsp; 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.&nbsp; 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.&nbsp; Then the problem started occurring every 7 to 8 
    days.&nbsp; 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>&nbsp;</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.&nbsp; it is becoming a 
    PITA.</FONT></SPAN></DIV>
    <DIV><SPAN class=480212510-25072003><FONT 
    color=#0000ff></FONT></SPAN>&nbsp;</DIV>
    <DIV><SPAN class=480212510-25072003><FONT 
    color=#0000ff></FONT></SPAN>&nbsp;</DIV>
    <DIV>&nbsp;</DIV>
    <DIV>&nbsp;</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@macdill.af.mil</FONT></B> <BR><B><FONT face=Arial