Stephen Go to http://technet.oracle.com and register -- it's free.
Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:09 AM To: Multiple recipients of list ORACLE-L 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 [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > 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" > > <[EMAIL PROTECTED]> > > Date: 2003/07/28 Mon AM 08:11:32 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > 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 > > [EMAIL PROTECTED] > > (813) 827-9974 DSN 651-9974 > > > > > > > > > -----Original Message----- > > > From: Ron Rogers [mailto:[EMAIL PROTECTED] > > > 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 > > > > > > >>> [EMAIL PROTECTED] 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 > <[EMAIL PROTECTED]> > > > 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 > > > > [EMAIL PROTECTED] > > > > (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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).