Perl DBA Tools
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Perl DBA Tools
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: [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 *>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: [EMAIL PROTECTED] *> *>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] *> *>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
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... - * 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: [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 *>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: [EMAIL PROTECTED] *> *>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] *> *>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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in *>the message B
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: [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 *>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: [EMAIL PROTECTED] > *> > *>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > *> > *&
RE: Perl DBA Tools
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Perl DBA Tools
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients 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 >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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists >--
Re: Perl DBA Tools
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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Perl DBA Tools
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 send them, I'm open to anything. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Perl DBA Tools
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 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Toepke, Kevin M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Perl DBA Tools
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, you don't have to stop the listener and you don't loose anything. Remember, in Unix, when you rename a file, any program that has it open still points to it. Regards, John >>> [EMAIL PROTECTED] 04/24/01 10:20AM >>>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 RachelJared-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jared Still INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Perl DBA Tools
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_file listener2.log > mv listener.log $ARCHIVE_LISTENER_FILENAME > mv listener2.log listener.log > lsnrctl set log_file listener.log > gzip $ARCHIVE_LISTENER_FILENAME > > This way, you don't have to stop the listener and you don't loose anything. > Remember, in Unix, when you rename a file, any program that has it open > still points to it. > > Regards, > John > > >>> [EMAIL PROTECTED] 04/24/01 10:20AM >>> > > 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 Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Perl DBA Tools
John, Im my script for managing the listener.log, I copy the listener to an archive area and then cat /dev/null to to current one. Will this have the same effect as moving as in your example ? Do I need also to force the listener to point to a different log file ? 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 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, you don't have to stop the listener and you don't loose anything. Remember, in Unix, when you rename a file, any program that has it open still points to it. Regards, John >>> [EMAIL PROTECTED] 04/24/01 10:20AM >>>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 RachelJared-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jared Still INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso 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.
Re: Perl DBA Tools
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 database (ie: entire db in trace mode), scans through em', figures out who's executing what (uid) and lists the SQL statements by user. - watchdbms.pl Daemon checking database services - check_dbup.pl Tool used by our Unix gang in outages when they restart nodes and need to verify database services. - baseline_main.pl (and various sub-programs) Performance tool that works on deltas (ie: run it once to capture beginning stats and again for end stats. Similar in concept to utlestat/bstat). Nitty gritty detail down to waits, latches, buffer pools, blah blah. Output is in html w/a table of contents. Very handy. Delta info stored into a repository instance. - dbmonitor.pl Takes capacity stats captured by a ksh script (using dbms_space) and creates html tables showing growth for objects and at tablespace level. ksh is cool and we have tons of structured scripts for all else we need - but Perl is just so much more fun. HTH, Casey ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Casey Dyke INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Perl DBA Tools
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 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 database (ie: entire db in trace mode), scans through em', figures out who's executing what (uid) and lists the SQL statements by user. - watchdbms.pl Daemon checking database services - check_dbup.pl Tool used by our Unix gang in outages when they restart nodes and need to verify database services. - baseline_main.pl (and various sub-programs) Performance tool that works on deltas (ie: run it once to capture beginning stats and again for end stats. Similar in concept to utlestat/bstat). Nitty gritty detail down to waits, latches, buffer pools, blah blah. Output is in html w/a table of contents. Very handy. Delta info stored into a repository instance. - dbmonitor.pl Takes capacity stats captured by a ksh script (using dbms_space) and creates html tables showing growth for objects and at tablespace level. ksh is cool and we have tons of structured scripts for all else we need - but Perl is just so much more fun. HTH, Casey ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Casey Dyke INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Hillman, Alex INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Perl DBA Tools
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 this in pipe, but I already went nuts about named pipes in perl (blocking). So, due to lack of time, I gave up on it. Another nice thing would be to have a simple Tk-GUI to "remote control" SQL*PLUS via named pipes. Problem is ... I hardly know Perl ;) That makes things a little bit difficult (I usually stick to Shell and Java right now). Jared Still schrieb: > > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 Mail has been checked for Viruses > Attention: Encrypted Mails can NOT be checked ! > > *** > > Diese Mail wurde auf Viren ueberprueft > Hinweis: Verschluesselte Mails koennen NICHT geprueft werden! > -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM AMS-Gebäude: E6 R08 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Perl DBA Tools
If you are keeping any kind of statistics on connections using the listener.log, you have the potential of missing records between the time you copy it and empty it to /dev/null. With my method, you won't loose any records. The choice is yours. HTH, John >>> [EMAIL PROTECTED] 04/25/01 12:55AM >>> John, Im my script for managing the listener.log, I copy the listener to an archive area and then cat /dev/null to to current one. Will this have the same effect as moving as in your example ? Do I need also to force the listener to point to a different log file ? 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 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, you don't have to stop the listener and you don't loose anything. Remember, in Unix, when you rename a file, any program that has it open still points to it. Regards, John >>> [EMAIL PROTECTED] 04/24/01 10:20AM >>>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 RachelJared-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jared Still INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying 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 computersystem.