Re: Perl DBA Tools

While that would be a worthwhile endeavor, I'm looking for stuff that is specific to Oracle operations, internal or external, as it relates to DBA tasks.

Jared

On Monday 23 April 2001 17:25, Patrick Housholder wrote:
> I just am starting into the perl land.
> *
> my project/tool:
> From oracle forms, call perl to remote login into a HOST(vms, sun,
> whatever)
> once i've login, run a script on the host with args.
> exit back to forms.
> -
> scan the host "when-timer-expire" to see the state of a host...
> -
> *
> os: window nt 4.0 sp6a
> *
> can this be done? or should i go w/pathwork?
>
> patrick
> *
>
>
> ===============================
> Patrick Housholder
> Sr. Staff Anl Tech Spt Design
> United Airlines Flight Training Center
> Denver CO
>
>
> *>-----Original Message-----
> *>From: root_at_fatcity.com [mailto:root_at_fatcity.com]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 *>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
> *>
> *>-----Original Message-----
> *>Sent: Monday, April 23, 2001 1:02 PM
> *>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).
> *>--
> *>Please see the official ORACLE-L FAQ: http://www.orafaq.com
> *>--
> *>Author: Seley, Linda
> *> INET: LSeley_at_IQNavigator.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).

-- 
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).