| 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: RE: Oracle 9i refuses to allow client connection -- I need
Stephen.
OTN is the abreviation for Oracle Technology Network
http://otn.oracle.com/. It is a source and startup point for
documentation, softrare , news, and other Oracle related "stuff". I
would surf the site to see what is available for the Oracle applications
you have and to locate the documentation that you might need.
I would also suggest that you get a MetaLink account
http://metalink.oracle.com. Metalink is the Oracle site where an
Oracle answered forums exist, patches reside, cetrification is listed,
ITAR's are created, etc. If you have an Oracle support contract you
should have access to the MetaLink site without any problems.
Ron
>>> Stephen.Wolfe_at_macdill.af.mil 07/28/03 10:09AM >>> 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
> >
>
> > 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
>
-- 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: 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).Received on Mon Jul 28 2003 - 09:39:24 CDT
 |
 |