From carmichr@hotmail.com Mon, 03 Sep 2001 14:35:56 -0700 From: "Rachel Carmichael" Date: Mon, 03 Sep 2001 14:35:56 -0700 Subject: RE: Duhvelopers and DB-ehs? Message-ID: MIME-Version: 1.0 Content-Type: text/plain yup I did... and I also have a friend who has had tons of trouble setting up mail via utl_smtp it's definitely a way to go though. it won't monitor things like disk space in the OS and you have to configure it and then set up the job in EACH db, instead of running through a list of databases in a single shell script. I tend to like doing things once :) >From: "Thomas, Kevin" >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >Subject: RE: Duhvelopers and DB-ehs? >Date: Mon, 03 Sep 2001 09:40:38 -0800 > >Yea, I've got the 'running the unix shell script' part down...did you see >the mails someone sent re: utl_smtp?? > > >"hit any user to continue" >__________________ > >Kevin Thomas >Technical Analyst >Deregulation Services >Calanais Ltd. >(2nd Floor East - Weirs Building) >Tel: 0141 568 2377 >Fax: 0141 568 2366 >http://www.calanais.com > > >-----Original Message----- >Sent: 03 September 2001 17:35 >To: Multiple recipients of list ORACLE-L > > >well, we don't send it out of pl/sql directly, we run shell scripts that >run the sql, then use shell to check the results and if it meets the "send >a > >message" criteria, we use mail or mailx to send it. > >you can use pipes to call unix shell programs though > > > > >From: "Thomas, Kevin" > >Reply-To: ORACLE-L@fatcity.com > >To: Multiple recipients of list ORACLE-L > >Subject: RE: Duhvelopers and DB-ehs? > >Date: Mon, 03 Sep 2001 01:40:35 -0800 > > > >OOooh, that's something I want to be able to do is to send email to us > >in case of problems...I can send email from OraForms using Outlook but > >I've not got round to checking out how I send email from a Unix box > >via pl/sql or the likes....any suggestions? > > > >K. > > > >"hit any user to continue" > >__________________ > > > >Kevin Thomas > >Technical Analyst > >Deregulation Services > >Calanais Ltd. > >(2nd Floor East - Weirs Building) > >Tel: 0141 568 2377 > >Fax: 0141 568 2366 > >http://www.calanais.com > > > > > >-----Original Message----- > >Sent: 31 August 2001 17:38 > >To: Multiple recipients of list ORACLE-L > > > > > >we have homegrown shell scripts -- page us, email us, send daily status >of > >the world reports... works! > > > > > > > > >From: "Thomas, Kevin" > > >Reply-To: ORACLE-L@fatcity.com > > >To: Multiple recipients of list ORACLE-L > > >Subject: RE: Duhvelopers and DB-ehs? > > >Date: Fri, 31 Aug 2001 05:47:12 -0800 > > > > > >Database monitoring tools....thrrp! We wrote our own using Java and >lots > >of > > >SQL are shell scripts...patchy but it works ;-) > > > > > > > > >__________________ > > > > > >Kevin Thomas > > >Technical Analyst > > >Deregulation Services > > >Calanais Ltd. > > >(2nd Floor East - Weirs Building) > > >Tel: 0141 568 2377 > > >Fax: 0141 568 2366 > > >http://www.calanais.com > > > > > > > > >-----Original Message----- > > >Sent: 31 August 2001 14:17 > > >To: Multiple recipients of list ORACLE-L > > > > > > > > >I've got 11 databases (and just found out I'll probably have a new one, >a > > >semi, sort of, kind of data warehouse -- I need those books!) > > > > > >and there is me, my junior DBA who is not so junior anymore, and one > > >consultant. > > > > > >And my CTO thinks that the DBAs are really just extra programming > > >resources. > > > > > >So half the time we are doing non-DBA work. > > > > > >Oh yeah, and we don't have any of those high-falutin' database >monitoring > > >tools either :) > > > > > > > > > >From: Robertson Lee - lerobe > > > >Reply-To: ORACLE-L@fatcity.com > > > >To: Multiple recipients of list ORACLE-L > > > >Subject: RE: Duhvelopers and DB-ehs? > > > >Date: Fri, 31 Aug 2001 02:55:26 -0800 > > > > > > > >Bloody Hell, we have half that amount of systems yet only two DBAs. > >What > > >on > > > >earth do they do with the rest of their time. > > > > > > > > > > > >-----Original Message----- > > > >Sent: 31 August 2001 09:40 > > > >To: Multiple recipients of list ORACLE-L > > > > > > > > > > > >LOL...with 31 systems to support 24/7/365 if you threw a stone in any > > > >direction you would hit a DBA. At the last count I believe we had > >12...!! > > > > > > > > > > > >__________________ > > > > > > > >Kevin Thomas > > > >Technical Analyst > > > >Deregulation Services > > > >Calanais Ltd. > > > >(2nd Floor East - Weirs Building) > > > >Tel: 0141 568 2377 > > > >Fax: 0141 568 2366 > > > >http://www.calanais.com > > > > > > > > > > > >-----Original Message----- > > > >Sent: 30 August 2001 17:22 > > > >To: Multiple recipients of list ORACLE-L > > > > > > > > > > > >Sounds like your company is looking for a new DBA? :-)))) > > > > > > > >Jan Pruner > > > > > > > >Dne ?t 30. srpen 2001 17:26 jste napsal(a): > > > > > I have to say I resent being called a duhveloper, granted the > >majority > > > > > couldn't tune a banjo let alone tune a piece of SQL, but as a >techie > > > >(and > > > > > we all are), I find this list invaluable for getting advice on a > >wide > > > >range > > > > > of topics, not just keeping a DB up and running or tuned...I don't > > >call > > > >you > > > > > guys names, and let's face it you DB-ehs? couldn't write a decent > > > > > application if your lives depended on it... > > > > > > > > > > (blue touch-paper lit, retire a distance, do not re-approach once > >lit, > > > >and > > > > > wait for fireworks) > > > > > > > > > > > > > > > "hit any user to continue" > > > > > __________________ > > > > > > > > > > Kevin Thomas > > > > > Technical Analyst > > > > > Deregulation Services > > > > > Calanais Ltd. > > > > > (2nd Floor East - Weirs Building) > > > > > Tel: 0141 568 2377 > > > > > Fax: 0141 568 2366 > > > > > http://www.calanais.com > > > > > > > > > > > > > > > -----Original Message----- > > > > > Sent: 30 August 2001 15:46 > > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > > > > > > > > > no, those posts keep us "underworked" DBAs from killing the > > >duhvelopers > > > >who > > > > > make us do the same thing over and over and over and who never > >listen > > > >when > > > > > we tell them the correct way to design the tables. > > > > > > > > > > :) > > > > > > > > > > From: "Boivin, Patrice J" > > > > > > > > > > >Reply-To: ORACLE-L@fatcity.com > > > > > >To: Multiple recipients of list ORACLE-L > > > > > >Subject: RE: !! Keeping the list alive > > > > > >Date: Thu, 30 Aug 2001 04:00:52 -0800 > > > > > > > > > > > >Just look at the number of OT postings in the last couple of > > >months... > > > > > > > > > > > >: ) > > > > > > > > > > > >Patrice Boivin > > > > > >Systems Analyst (Oracle Certified DBA) > > > > > > > > > > > >Systems Admin & Operations | Admin. et Exploit. des systèmes > > > > > >Technology Services | Services technologiques > > > > > >Informatics Branch | Direction de l'informatique > > > > > >Maritimes Region, DFO | Région des Maritimes, MPO > > > > > > > > > > > >E-Mail: boivinp@mar.dfo-mpo.gc.ca > > > > > > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > From: schmoldt@fyiowa.com [SMTP:schmoldt@fyiowa.com] > > > > > > Sent: Wednesday, August 29, 2001 7:58 PM > > > > > > To: Multiple recipients of list ORACLE-L > > > > > > Subject: RE: !! Keeping the list alive > > > > > > > > > > > > You're surprised at those willing to pay? > > > > > > > > > > > > You have to realize that most DBAs are over-payed and >under-worked > > > > > >.... > > > > > > <> > > > > > > > > > > > > > -----Original Message----- > > > > > > > From: Jared.Still@radisys.com >[mailto:Jared.Still@radisys.com] > > > > > > > Sent: Wednesday, August 29, 2001 1:43 PM > > > > > > > To: Multiple recipients of list ORACLE-L > > > > > > > Subject: !! Keeping the list alive > > > > > > > > > > > > > > > > > > > > > > > > > > > > This list is apparently a more valuable resource to many >of you > > > > > > > > > > > >than I > > > > > > > > > > > > > realized. > > > > > > > > > > > > > > I'm literally bowled over by the generosity. I've >received > > > > > > > so many emails > > > > > > > about > > > > > > > this that I really can't personally reply to them all >right now. > > > > > > > > > > > > -- > > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > > > -- > > > > > > Author: > > > > > > INET: schmoldt@fyiowa.com > > > > > > > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) > >538-5051 > > > > > > San Diego, California -- Public Internet access / >Mailing > > > > > >Lists > > > > > > > > -------------------------------------------------------------------- > > > > > > To REMOVE yourself from this mailing list, send an E-Mail >message > > > > > > to: ListGuru@fatcity.com (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.com > > > > > >-- > > > > > >Author: Boivin, Patrice J > > > > > > INET: BoivinP@mar.dfo-mpo.gc.ca > > > > > > > > > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) >538-5051 > > > > > >San Diego, California -- Public Internet access / Mailing > > >Lists > > > > > > > >-------------------------------------------------------------------- > > > > > >To REMOVE yourself from this mailing list, send an E-Mail message > > > > > >to: ListGuru@fatcity.com (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). > > > > > > > > > > _________________________________________________________________ > > > > > Get your FREE download of MSN Explorer at > > > >http://explorer.msn.com/intl.asp > > > >-- > > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > >-- > > > >Author: Jan Pruner > > > > INET: jan@pruner.cz > > > > > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > >San Diego, California -- Public Internet access / Mailing >Lists > > > >-------------------------------------------------------------------- > > > >To REMOVE yourself from this mailing list, send an E-Mail message > > > >to: ListGuru@fatcity.com (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.com > > > >-- > > > >Author: Thomas, Kevin > > > > INET: Kevin.Thomas@calanais.com > > > > > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > >San Diego, California -- Public Internet access / Mailing >Lists > > > >-------------------------------------------------------------------- > > > >To REMOVE yourself from this mailing list, send an E-Mail message > > > >to: ListGuru@fatcity.com (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). > > > > > > > > > > > >The information contained in this communication is > > > >confidential, is intended only for the use of the recipient > > > >named above, and may be legally privileged. If the reader > > > >of this message is not the intended recipient, you are > > > >hereby notified that any dissemination, distribution or > > > >copying of this communication is strictly prohibited. > > > >If you have received this communication in error, please > > > >re-send this communication to the sender and delete the > > > >original message or any copy of it from your computer > > > >system. > > > >-- > > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > >-- > > > >Author: Robertson Lee - lerobe > > > > INET: lerobe@acxiom.co.uk > > > > > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > >San Diego, California -- Public Internet access / Mailing >Lists > > > >-------------------------------------------------------------------- > > > >To REMOVE yourself from this mailing list, send an E-Mail message > > > >to: ListGuru@fatcity.com (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). > > > > > > > > >_________________________________________________________________ > > >Get your FREE download of MSN Explorer at > >http://explorer.msn.com/intl.asp > > > > > >-- > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > > >-- > > >Author: Rachel Carmichael > > > INET: carmichr@hotmail.com > > > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > >San Diego, California -- Public Internet access / Mailing Lists > > >-------------------------------------------------------------------- > > >To REMOVE yourself from this mailing list, send an E-Mail message > > >to: ListGuru@fatcity.com (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.com > > >-- > > >Author: Thomas, Kevin > > > INET: Kevin.Thomas@calanais.com > > > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > >San Diego, California -- Public Internet access / Mailing Lists > > >-------------------------------------------------------------------- > > >To REMOVE yourself from this mailing list, send an E-Mail message > > >to: ListGuru@fatcity.com (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). > > > > > >_________________________________________________________________ > >Get your FREE download of MSN Explorer at >http://explorer.msn.com/intl.asp > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Rachel Carmichael > > INET: carmichr@hotmail.com > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California -- Public Internet access / Mailing Lists > >-------------------------------------------------------------------- > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: ListGuru@fatcity.com (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.com > >-- > >Author: Thomas, Kevin > > INET: Kevin.Thomas@calanais.com > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California -- Public Internet access / Mailing Lists > >-------------------------------------------------------------------- > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: ListGuru@fatcity.com (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). > > >_________________________________________________________________ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Rachel Carmichael > INET: carmichr@hotmail.com > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru@fatcity.com (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.com >-- >Author: Thomas, Kevin > INET: Kevin.Thomas@calanais.com > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru@fatcity.com (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). _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr@hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (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).