| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><SPAN class=3D480212510-25072003><FONT color=3D#0000ff>I'm an =
Oracle=20
administrator-To-Be, I'm awaiting funding for the basic Oracle DBA =
courses,=20
the</FONT></SPAN></DIV>
<DIV><SPAN class=3D480212510-25072003><FONT color=3D#0000ff>training has =
been=20
approved, just hasn't been funded. </FONT></SPAN></DIV>
<DIV><SPAN class=3D480212510-25072003><FONT=20
color=3D#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=3D480212510-25072003><FONT color=3D#0000ff>Anyway, the =
only things=20
I do are add, modify, and reset application users' password via EM and=20
run</FONT></SPAN></DIV>
<DIV><SPAN class=3D480212510-25072003><FONT color=3D#0000ff>patching =
scripts via=20
SQL-Plus. The application I have running on this particular 9i =
server is=20
TPOCS,</FONT></SPAN></DIV>
<DIV><SPAN class=3D480212510-25072003><FONT color=3D#0000ff>Third Party =
Outpatient=20
Collection System -- a billing system for the DoD's Military Health =
System=20
(MHS).</FONT></SPAN></DIV>
<DIV><SPAN class=3D480212510-25072003><FONT color=3D#0000ff>Oracle 9i is =
running on=20
a Windows 2000 server.</FONT></SPAN></DIV>
<DIV><SPAN class=3D480212510-25072003><FONT=20
color=3D#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=3D480212510-25072003><FONT color=3D#0000ff>Anyway, the =
TPOCS client=20
is a PowerBuilder client and connects via SQL-Net -- I'm still learning =
about=20
that</FONT></SPAN></DIV>
<DIV><SPAN class=3D480212510-25072003><FONT =
color=3D#0000ff>mechanism. Here's=20
my problem. Occasionally, Oracle refuses to let any client connect =
to it=20
-- it does this about</FONT></SPAN></DIV>
<DIV><SPAN class=3D480212510-25072003><FONT color=3D#0000ff>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 </FONT></SPAN></DIV>
<DIV><SPAN class=3D480212510-25072003><FONT color=3D#0000ff>ram on the =
server from=20
512MB to 1GB. Then the problem started occurring every 7 to 8 =
days. =20
To make the problem</FONT></SPAN></DIV>
<DIV><SPAN class=3D480212510-25072003><FONT color=3D#0000ff>go away I =
reboot the=20
server -- it only takes 10 minutes, however, I feel this a very poor=20
work-around.</FONT></SPAN></DIV>
<DIV><SPAN class=3D480212510-25072003><FONT=20
color=3D#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=3D480212510-25072003><FONT color=3D#0000ff>Which logs =
could I look=20
in that would give you guys more information (like an error code) on why =
Oracle=20
refuses</FONT></SPAN></DIV>
<DIV><SPAN class=3D480212510-25072003><FONT color=3D#0000ff>client =
connections and=20
then how would we make this problem go away. it is becoming a=20
PITA.</FONT></SPAN></DIV>
<DIV><SPAN class=3D480212510-25072003><FONT=20
color=3D#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=3D480212510-25072003><FONT=20
color=3D#0000ff></FONT></SPAN> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<P><B><FONT face=3DArial color=3D#0000ff size=3D2>v/r</FONT></B> </P>
<P><B><FONT face=3DArial color=3D#0000ff size=3D2>Stephen S. Wolfe, =
GS-11,=20
DAFC</FONT></B> <BR><B><FONT face=3DArial color=3D#0000ff size=3D2>Data =
Services=20
Manager</FONT></B> <BR><B><FONT face=3DArial color=3D#0000ff=20
size=3D2>stephen.wolfe_at_macdill.af.mil</FONT></B> <BR><B><FONT =
face=3DArial=20
Received on Fri Jul 25 2003 - 05:38:36 CDT
 |
 |