OTN is shorthand for Oracle Technical Network.... technet.oracle.com
--- Wolfe Stephen S GS-11 6 MDSS/SGSI <[EMAIL PROTECTED]> wrote: > 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 > === message truncated === __________________________________ 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).
