| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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<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)
=20
Dave
-----Original Message-----
From: Wolfe Stephen S GS-11 6 MDSS/SGSI =
[mailto:Stephen.Wolfe_at_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_at_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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 5.00.3315.2870" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D984534411-25072003>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)</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D984534411-25072003></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D984534411-25072003>Dave</SPAN></FONT></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Wolfe Stephen S =
GS-11 6=20
MDSS/SGSI [mailto:Stephen.Wolfe_at_macdill.af.mil]<BR><B>Sent:</B> =
Friday, July=20
25, 2003 6:35 AM<BR><B>To:</B> Multiple recipients of list=20
ORACLE-L<BR><B>Subject:</B> Oracle 9i refuses to allow client =
connection -- I=20
need some help.<BR><BR></DIV></FONT>
<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=20
things 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=20
on 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=20
client is a PowerBuilder client and connects via SQL-Net -- I'm still =
learning=20
about that</FONT></SPAN></DIV>
<DIV><SPAN class=3D480212510-25072003><FONT =
color=3D#0000ff>mechanism. =20
Here's my problem. Occasionally, Oracle refuses to let any =
client=20
connect to it -- it does this about</FONT></SPAN></DIV>
<DIV><SPAN class=3D480212510-25072003><FONT color=3D#0000ff>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 </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=20
days. 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=20
look in that would give you guys more information (like an error code) =
on why=20
Oracle 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 color=3D#0000ff face=3DArial size=3D2>v/r</FONT></B> </P> <P><B><FONT color=3D#0000ff face=3DArial size=3D2>Stephen S. Wolfe, =GS-11,=20
 |
 |