Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RE: Oracle 9i refuses to allow client connection -- I need

Re: RE: Oracle 9i refuses to allow client connection -- I need

From: <rgaffuri_at_cox.net>
Date: Mon, 28 Jul 2003 05:24:29 -0800
Message-ID: <F001.005C7769.20030728052429@fatcity.com>


the otn document for administering oracle on windows is pretty solid. the book includes most of that stuff plus some fo the gui tools.
>
> From: "Wolfe Stephen S GS-11 6 MDSS/SGSI" <Stephen.Wolfe_at_macdill.af.mil>
> Date: 2003/07/28 Mon AM 08:11:32 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: Oracle 9i refuses to allow client connection -- I need
>
>
>
> v/r
> Thanks for the encouragement and yes I would like to know some of the good Oracle 101 under a windows environment books. I'm pretty certain that my approved training will be funded with year-end money, but that means the earliest I'll get to class is in late October or early November.
>
> Hope you don't mind me bugging you all a while until I get squared away.
>
> Stephen S. Wolfe, GS-11, DAFC
> Data Services Manager
> stephen.wolfe_at_macdill.af.mil
> (813) 827-9974 DSN 651-9974
>
>
>
> > -----Original Message-----
> > From: Ron Rogers [mailto:RROGERS_at_galottery.org]
> > Sent: Friday, July 25, 2003 10:59 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Oracle 9i refuses to allow client connection -- I need
> >
> >
> > Stephen,
> > I also would like to extend a warm welcome to the world of
> > Oracle. I hope that you find it interesting and challenging
> > and rewarding.
> > I would suggest that you get a head start on your training
> > so you won't be overwhelmed when you attend, by acquiring
> > some of the "Oracle 101" books that are available on the
> > market. They are a valuable resource that I refer to
> > constantly as I can't remember as much as I use to.
> > I don't mean to slight any of the excellent authors that
> > are on this list by not listing their works here. I am sure
> > that if you asked for references you will be supplied with a
> > list that will be quite complete and up to date. Again,
> > Welcome. Ron mª¿ªm
> >
> > >>> wisernet100_at_yahoo.com 07/25/03 08:59AM >>>
> > there are a number of logs that could help:
> >
> > first, does the application itself generate a log? If so,
> > does that log reflect the actual error returned? It might
> > look something like "ORA-nnnnnn"
> >
> > Second, on the Windows Box itself, look for a file name
> > "alert<sid>.log" (I'm not that familiar with Oracle's
> > configuration on Windows as I run Unix but it should look
> > something like that). Look to see if there are any error
> > messages in that file at the time the connections are refused.
> >
> > If increasing memory on the box itself helped, it's likely
> > that what's happening is that users are connecting to the
> > box, never dropping or closing the connections so that memory
> > stays allocated. The box runs out of memory, you reboot
> > (closing the connections and releasing the
> > memory) and you are good for another week or so.
> >
> > if that's what's happening -- you either have to get the
> > users to LOG OFF (yeah, right) or find a way of
> > closing/killing the connections after x amount of time (look
> > into the online docs -- technet.oracle.com, specifically look
> > at the network manuals).
> >
> > and welcome! It's always nice to see a new face here,
> > especially one who is willing to LEARN
> >
> > --- Wolfe Stephen S GS-11 6 MDSS/SGSI <Stephen.Wolfe_at_macdill.af.mil>
> > wrote:
> > > 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
> > >
> > >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! SiteBuilder - Free, easy-to-use web site design
> > software http://sitebuilder.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Rachel Carmichael
> > INET: wisernet100_at_yahoo.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> > and in the message BODY, include a line containing: UNSUB
> > ORACLE-L (or the name of mailing list you want to be removed
> > from). You may also send the HELP command for other
> > information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Ron Rogers
> > INET: RROGERS_at_galottery.org
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> > and in the message BODY, include a line containing: UNSUB
> > ORACLE-L (or the name of mailing list you want to be removed
> > from). You may also send the HELP command for other
> > information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Wolfe Stephen S GS-11 6 MDSS/SGSI
> INET: Stephen.Wolfe_at_macdill.af.mil
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Jul 28 2003 - 08:24:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US