| 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
I've written Perl scripts that telnet to another host and run a command remotely using the Expect module. I haven't programmed in oracle forms but that part should be doable (most gui's let you execute external programs). I can send you a sample perl script if you like.
Gerardo
-----Original Message-----
Sent: Monday, April 23, 2001 5:26 PM
To: Multiple recipients of list ORACLE-L
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...
-
patrick
*
*>-----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: Patrick Housholder INET: housholder_at_ualfltctr.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: Molina, Gerardo INET: Gerardo.Molina_at_schwab.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 Mon Apr 23 2001 - 19:38:47 CDT
 |
 |