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

Please excuse the ignorance but what is an otn document? I have three Oracle based applications here and each one was delivered without any documentation.

v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
stephen.wolfe_at_macdill.af.mil
(813) 827-9974 DSN 651-9974
> -----Original Message-----
> From: rgaffuri_at_cox.net [mailto:rgaffuri_at_cox.net]
> Sent: Monday, July 28, 2003 9:24 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: Oracle 9i refuses to allow client connection
> -- I need
>
>
> 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).
>

-- 
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).