RE: Perl DBA Tools

2001-04-25 Thread John Carlson
le ?   Maybe I need to test some more !!   Regards Lee Robertson -Original Message-From: John Carlson [mailto:[EMAIL PROTECTED]]Sent: 24 April 2001 19:47To: Multiple recipients of list ORACLE-LSubject: Re: Perl DBA Tools How about wrapping this is a s

Re: Perl DBA Tools

2001-04-25 Thread Stefan Jahnke
Hi, well, what we are actually using right now is this: (Korn Shell): create 2 named pipes. create a sql*plus and redirect input/output to the pipes. have monitoring scripts sending sql requests to the input pipe. have reporting scripts reading the output from the output pipe. I tried to start

RE: Perl DBA Tools

2001-04-25 Thread Hillman, Alex
Can I have these scripts if possible. Please post it on the list or e-mail it to [EMAIL PROTECTED] Alex hillman -Original Message- Sent: Wednesday, April 25, 2001 10:49 AM To: Multiple recipients of list ORACLE-L Hi Jared, A few things we use Perl for: - watchfs.pl This thing monito

Re: Perl DBA Tools

2001-04-25 Thread Casey Dyke
Hi Jared, A few things we use Perl for: - watchfs.pl This thing monitors db related file systems and alerts (via our NOC) if thresholds are exceeded. Thresholds managed in dynamic config file. - process_ora_trace.pl A one off that helped us w/a vendor. Takes trace output files for a databas

RE: Perl DBA Tools

2001-04-25 Thread Robertson Lee - lerobe
some more !!   Regards Lee Robertson -Original Message-From: John Carlson [mailto:[EMAIL PROTECTED]]Sent: 24 April 2001 19:47To: Multiple recipients of list ORACLE-LSubject: Re: Perl DBA Tools How about wrapping this is a script of your choice

Re: Perl DBA Tools

2001-04-24 Thread Jared Still
Great John, thanks! It appears I need to look at the SQLNet docs, as I didn't know you could do that. Jared On Tuesday 24 April 2001 11:47, John Carlson wrote: > How about wrapping this is a script of your choice: > > ARCHIVE_LISTENER_FILENAME=listener`date +%Y%m%d%H%M`.log > lsnrctl set log_f

Re: Perl DBA Tools

2001-04-24 Thread John Carlson
How about wrapping this is a script of your choice:   ARCHIVE_LISTENER_FILENAME=listener`date +%Y%m%d%H%M`.log lsnrctl set log_file listener2.logmv listener.log $ARCHIVE_LISTENER_FILENAMEmv listener2.log listener.loglsnrctl set log_file listener.loggzip $ARCHIVE_LISTENER_FILENAME This way, yo

RE: Perl DBA Tools

2001-04-24 Thread Toepke, Kevin M
Run EXPLAIN PLAN... email me if you want to integrate my version in your tool. Kevin Toepke -Original Message- Sent: Tuesday, April 24, 2001 1:21 PM To: Multiple recipients of list ORACLE-L On Tuesday 24 April 2001 06:15, Rachel Carmichael wrote: > truncating listener logs -- or even

Re: Perl DBA Tools

2001-04-24 Thread Jared Still
On Tuesday 24 April 2001 03:40, Mark Leith wrote: > > I'm still thinking about this one - we have loads of requests for > functionality in tools that just seem outrageous - shall I send them all to > you in a great big list? :-) > Thanks for your thought Mark. As for the others, go ahead and sen

Re: Perl DBA Tools

2001-04-24 Thread Jared Still
On Tuesday 24 April 2001 06:15, Rachel Carmichael wrote: > truncating listener logs -- or even starting a secondary listener, stopping > the one with the log that is too large and removing the log, then > restarting the original listener > Good idea. Thanks Rachel Jared -- Please see the

RE: Perl DBA Tools

2001-04-24 Thread Rachel Carmichael
cipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Perl DBA Tools >Date: Tue, 24 Apr 2001 02:40:25 -0800 > >Jared, > >Adding on to monitoring the alertSID.log, how about also monitoring the >Archive log directory for free space - and size, then alert by email when

RE: Perl DBA Tools

2001-04-24 Thread Mark Leith
Jared, Adding on to monitoring the alertSID.log, how about also monitoring the Archive log directory for free space - and size, then alert by email when say 90% full. Or go one step further - and when it reaches 90% full ftp the older logs to a backup directory. I'm still thinking about this one

RE: Perl DBA Tools

2001-04-24 Thread Lord David
Jared Don't have any suggestions (except for enterprise manager that works, fast), but if you're looking for perl development help, I'd be interested. David Lord -Original Message- Sent: 23 April 2001 20:02 To: Multiple recipients of list ORACLE-L Hello List, For those of you that u

Re: Perl DBA Tools

2001-04-23 Thread Jared Still
> *>-Original Message- > *>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Seley, > *>Linda > *>Sent: Monday, April 23, 2001 2:50 PM > *>To: Multiple recipients of list ORACLE-L > *>Subject: RE: Perl DBA Tools > *> > *> &g

RE: Perl DBA Tools

2001-04-23 Thread Molina, Gerardo
ech Spt Design United Airlines Flight Training Center Denver CO *>-Original Message- *>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Seley, *>Linda *>Sent: Monday, April 23, 2001 2:50 PM *>To: Multiple recipients of list ORACLE-L *>Subject: RE: Perl DB

RE: Perl DBA Tools

2001-04-23 Thread Patrick Housholder
rom: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Seley, *>Linda *>Sent: Monday, April 23, 2001 2:50 PM *>To: Multiple recipients of list ORACLE-L *>Subject: RE: Perl DBA Tools *> *> *>Well, I'm 75% of the way through creating scripts to automatically clone a

RE: Perl DBA Tools

2001-04-23 Thread Seley, Linda
Well, I'm 75% of the way through creating scripts to automatically clone a database. It's all in the korn shell and yes, I've been thinking 'there must be a better way'! (besides the fact that soon I'm gonna need to put this through end-to-end testing and would like help) Linda -Orig