| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Perl DBA Tools
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....
>From: "Mark Leith" <mark_at_cool-tools.co.uk>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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
>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 - 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? :-)
>
>Cheers
>
>Mark
>
>-----Original Message-----
>Sent: Tuesday, April 24, 2001 09:46
>To: Multiple recipients of list ORACLE-L
>
>
>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 use Perl or would like to use Perl for your
>regular DBA tasks, I have a request.
>
>Do you have any tasks you perform with a series of SQL scripts,
>shell scripts, etc, that you feel are somewhat of a kludge?
>
>Have you every asked yourself " There must be a better way to
>do this?"
>
>Or do you just have a wishlist of tools that would make day to day
>DBA life easier, but feel that it's too complex or unwieldy to tackle
>with PL/SQL and SQL*Plus?
>
>I'm looking for just those kinds of ideas for a project I'm working on.
>
>No ideas too silly or complicated. Granted, they may be too silly or
>complicated to actually implement, but you never know. No idea is
>a bad idea until it's thought through.
>
>Come to think of it, the same holds true for good ideas also.
>
>Anyway, let's hear it!
>
>Some examples of tools that I have used in Perl:
>
>* Create multiple users from a CSV file generated from MS Excel. Works
> great when someone asks for 100 users to be created.
>
>* Monitor databases for SNIPED sessions then KILL them.
>
>* Monitor the alert.log for Errors and mail to DBA's and or selectect
> other individuals. Errors can be filtered by type and selectively
>mailed.
> I've used this for duhvelopers that don't want to be bothered with
> error trapping and send hundreds of emails to the DBA's due to their
> error messages. Que's up messages for 5 minutes or 100 messages,
> whichever comes first ( avoids swamping the mail server in a crisis )
>
>* How about a way to serve up passwords to users for use with command
> line utilities in a secure manner? Oh wait, I don't have that one yet.
>
>As you can see, I have a wishlist too. Lemme hear what you would like!
>
>TIA
>
>Jared
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jared Still
> INET: jkstill_at_cybcon.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_at_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).
>**********************************************************************
>This email and any files transmitted with it are confidential and
>intended solely for the use of the individual or entity to whom they
>are addressed. If you have received this email in error please notify
>the system manager.
>
>This footnote also confirms that this email message has been swept by
>MIMEsweeper for the presence of computer viruses.
>
>www.mimesweeper.com
>**********************************************************************
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Lord David
> INET: dlord_at_haysits.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_at_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: Mark Leith
> INET: mark_at_cool-tools.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_at_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: Rachel Carmichael INET: carmichr_at_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_at_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).Received on Tue Apr 24 2001 - 08:53:35 CDT
 |
 |