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