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