RE: Oracle 9i refuses to allow client connection -- I need some h elp.

[Boivin, Patrice J]

Title: Message

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:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] (813) 827-9974  DSN 651-9974