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