Message-Id: <26013.339588@fatcity.com> From: "Wolfe Stephen S GS-11 6 MDSS/SGSI" Date: Fri, 25 Jul 2003 05:38:36 -0500 Subject: Oracle 9i refuses to allow client connection -- I need some help. This is a multi-part message in MIME format. ------_=_NextPart_001_01C35298.E707D6D5 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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_01C35298.E707D6D5 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
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 things=20 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 on=20 a Windows 2000 server.
 
Anyway, the = TPOCS client=20 is a PowerBuilder client and connects via SQL-Net -- I'm still learning = about=20 that
mechanism.  Here's=20 my problem.  Occasionally, Oracle refuses to let any client connect = to it=20 -- it does this about
every 7 to 8 = days. =20 It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended = we=20 increase the
ram on the = server from=20 512MB to 1GB.  Then the problem started occurring every 7 to 8 = days. =20 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 look=20 in that would give you guys more information (like an error code) on why = Oracle=20 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