OTN is shorthand for Oracle Technical Network....
technet.oracle.com
- Wolfe Stephen S GS-11 6 MDSS/SGSI <Stephen.Wolfe_at_macdill.af.mil>
wrote:
> 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
>
=== message truncated ===
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).
Received on Mon Jul 28 2003 - 09:19:30 CDT
