Message-Id: <26013.339595@fatcity.com> From: "Farnsworth, Dave" Date: Fri, 25 Jul 2003 06:52:02 -0500 Subject: RE: Oracle 9i refuses to allow client connection -- I need some help. This is a multi-part message in MIME format. ------_=_NextPart_001_01C352A3.29952196 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Might find something in your SID.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) =20 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. =20 =20 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. =20 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=20 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. =20 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. =20 =20 =20 =20 v/r=20 Stephen S. Wolfe, GS-11, DAFC=20 Data Services Manager=20 stephen.wolfe@macdill.af.mil=20 (813) 827-9974 DSN 651-9974=20 ------_=_NextPart_001_01C352A3.29952196 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message
Might=20 find something in your SID<ALRT>.log.  This is in your=20 Oracle_home\admin\bdump directory.  Might also find something in = your=20 Oracle_home\network\log\listener.log depending on if any tracing is = enabled.  I used to have this problem.  Found that stopping = and=20 restarting my listener service a few times a week took care of it.  = Also=20 adding more memory helped.  I had a TAR with Oracle on this and = they=20 recommended the stopping and restarting the listener service.  I am = on=20 windoze though so it may be a platform dependent thing, not like M$ has = any=20 issues with their OS.  ;o)
 
Dave
-----Original Message-----
From: Wolfe Stephen S = GS-11 6=20 MDSS/SGSI [mailto:Stephen.Wolfe@macdill.af.mil]
Sent: = Friday, July=20 25, 2003 6:35 AM
To: Multiple recipients of list=20 ORACLE-L
Subject: Oracle 9i refuses to allow client = connection -- I=20 need some help.

I'm an = Oracle=20 administrator-To-Be, I'm awaiting funding for the basic Oracle DBA = courses,=20 the
training = has been=20 approved, just hasn't been funded. 
 
Anyway, = the only=20 things I do are add, modify, and reset application users' password via = EM and=20 run
patching = scripts via=20 SQL-Plus.  The application I have running on this particular 9i = server is=20 TPOCS,
Third = Party Outpatient=20 Collection System -- a billing system for the DoD's Military Health = System=20 (MHS).
Oracle 9i = is running=20 on a Windows 2000 server.
 
Anyway, = the TPOCS=20 client is a PowerBuilder client and connects via SQL-Net -- I'm still = learning=20 about that
mechanism. =20 Here's my problem.  Occasionally, Oracle refuses to let any = client=20 connect to it -- it does this about
every 7 to = 8=20 days.  It use to do it every 2 days, but the Tier 3 TPOCS = helpdesk=20 recommended we increase the
ram on the = server from=20 512MB to 1GB.  Then the problem started occurring every 7 to 8=20 days.  To make the problem
go away I = reboot the=20 server -- it only takes 10 minutes, however, I feel this a very poor=20 work-around.
 
Which logs = could I=20 look in that would give you guys more information (like an error code) = on why=20 Oracle refuses
client = connections and=20 then how would we make this problem go away.  it is becoming a=20 PITA.
 
 
 
 

v/r

Stephen S. Wolfe, = GS-11,=20 DAFC
Data Services=20 Manager
stephen.wolfe@macdill.af.mil