| 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 h
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C3529D.2279B310
Content-Type: text/plain
What is the error message (if any)
Can you connect thru SQL*Plus (/ as sysdba)
-----Original Message-----
From: Wolfe Stephen S GS-11 6 MDSS/SGSI
[mailto:Stephen.Wolfe_at_macdill.af.mil]
Sent: Friday, July 25, 2003 1:35 PM
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
stephen.wolfe_at_macdill.af.mil
(813) 827-9974 DSN 651-9974
------_=_NextPart_001_01C3529D.2279B310
Content-Type: text/html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=502340511-25072003>What
is the error message (if any)</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=502340511-25072003>Can
you connect thru SQL*Plus (/ as sysdba)</SPAN></FONT></DIV>
<DIV class=Section1>
<P class=MsoAutoSig><?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" /><o:p> </o:p></P></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Wolfe Stephen S
GS-11 6 MDSS/SGSI [mailto:Stephen.Wolfe_at_macdill.af.mil] <BR><B>Sent:</B>
Friday, July 25, 2003 1:35 PM<BR><B>To:</B> Multiple recipients of list
ORACLE-L<BR><B>Subject:</B> Oracle 9i refuses to allow client connection -- I
need some help.<BR><BR></FONT></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>I'm an Oracle
administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses,
the</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>training has been
approved, just hasn't been funded. </FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>Anyway, the only
things I do are add, modify, and reset application users' password via EM and
run</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>patching scripts via
SQL-Plus. The application I have running on this particular 9i server is
TPOCS,</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>Third Party Outpatient
Collection System -- a billing system for the DoD's Military Health System
(MHS).</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>Oracle 9i is running
on a Windows 2000 server.</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>Anyway, the TPOCS
client is a PowerBuilder client and connects via SQL-Net -- I'm still learning
about that</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>mechanism.
Here's my problem. Occasionally, Oracle refuses to let any client
connect to it -- it does this about</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>every 7 to 8
days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk
recommended we increase the </FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>ram on the server from
512MB to 1GB. Then the problem started occurring every 7 to 8
days. To make the problem</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>go away I reboot the
server -- it only takes 10 minutes, however, I feel this a very poor
work-around.</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>Which logs could I
look in that would give you guys more information (like an error code) on why
Oracle refuses</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT color=#0000ff>client connections and
then how would we make this problem go away. it is becoming a
PITA.</FONT></SPAN></DIV>
<DIV><SPAN class=480212510-25072003><FONT
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=480212510-25072003><FONT
color=#0000ff></FONT></SPAN> </DIV>
<DIV> </DIV> <DIV> </DIV> <P><B><FONT face=Arial color=#0000ff size=2>v/r</FONT></B> </P> <P><B><FONT face=Arial color=#0000ff size=2>Stephen S. Wolfe, GS-11,DAFC</FONT></B> <BR><B><FONT face=Arial color=#0000ff size=2>Data Services Manager</FONT></B> <BR><B><FONT face=Arial color=#0000ff size=2>stephen.wolfe_at_macdill.af.mil</FONT></B> <BR><B><FONT face=Arial color=#0000ff size=2>(813) 827-9974 DSN 651-9974</FONT></B> Received on Fri Jul 25 2003 - 06:08:53 CDT
 |
 |