Thanks! I'll start perusing the sites right away. v/r
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: Monday, July 28, 2003 10:39 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: RE: Oracle 9i refuses to allow client connection > -- I need > > > Stephen. > OTN is the abbreviation for Oracle Technology Network > http://otn.oracle.com/. It is a source and startup point for > documentation, software , 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, certifications 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 > > >>> [EMAIL PROTECTED] 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 > [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: 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).