I won't comment on the Perl side of things but will give some alternatives (& reasons).
Does the DBA team or system admins already know any Windows scripting tools - if so I would consider using them?
What are you trying to script - this will affect which tool is appropriate?
Are you going to be using OEM?
Perhaps more important than the scripting language what are you going to use as a scheduler - AT, Scheduling service, OEM or some other product?
As for scripting tools:
NT's CMD / batch language - you can do lots of things in it - but many are obscure to achieve.
It has the advantage of being free but more importantly it is on every machine and you don't need approval to install it.
What about VBScript, Kixx or WSH - your Windows admins may be using some of these already.
Also, if trying to script a GUI application, consider Microsoft's scripit tool that lets you input into windows.
If you want some links on batch / CMD programming then ask.
We use OEM events to monitor, OEMs scheduler, OEM to automate RMAN backups & exports.
A few utilities from Windows resource kits and some batch files (eg restart listener log, monitor listener log size, delete old files and so on)
HTH,
Bruce Reardon
-----Original Message-----
Sent: Thursday, 15 August 2002 11:23
readable. uh huh. sure
how does this create a csv file?
- Jared.Still_at_radisys.com wrote:
> How many of those "non-cryptic" languages can dump a table
> to a CSV file in 2 lines of (readable ) code?
>
> while ( my $ary = $sth->fetchrow_arrayref ) {
> print q{"} . join(q{","},@{$ary}) . qq{"\n};
> }
>
> Come over to the dark side Chris. ;)
>
> Jared
>
>
>
>
>
> "Grabowy, Chris" <cgrabowy_at_fcg.com>
> Sent by: root_at_fatcity.com
> 08/14/2002 07:28 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: RE: RE: Dba tools on NT
>
>
> Spaghetti code is easy to write...just throw some GOTOs in there.
>
> I just have some issues with a language that has more special
> characters
> in
> it then alpha characters.
>
> Sigh. I miss the good ole days, COBOL, Fortran, Pascal, and even a
> little
> bit of BASIC...I guess that's why I enjoy PL/SQL.
>
> -----Original Message-----
> Sent: Tuesday, August 13, 2002 5:32 PM
> To: Grabowy, Chris; Multiple recipients of list ORACLE-L
>
>
> I'll agree with Jared. Given any programming or scripting language
> and
> there's
> some duhveloper out there who can make a completely obfuscated mess
> out of
> it.
> I was once told that it was impossible under Ada, boy did that ever
> get
> retracted by the author in a hurry!!
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: "Grabowy; Chris" <cgrabowy_at_fcg.com>
> Date: 8/13/2002 2:06 PM
>
> DOH!!!! Ouch...(limping along)...come on now. Perl has won "awards"
> for
> it's "readability" and "maintainability". I'm not slamming Perl, it
> has
> saved my behind on W2K platforms, which has no real scripting
> language.
> And
> I did advance order a copy of your book. Not that I want to be a
> Duhveloper...
>
>
>
> -----Original Message-----
> Sent: Tuesday, August 13, 2002 4:42 PM
> To: ORACLE-L_at_fatcity.com
> Cc: Grabowy, Chris
>
>
> > And it's difficult to write, looks like scrambled eggs when your
> done,
> and
> > impossible to maintain...
>
> Of course, you can say this about any programming or scripting
> language.
>
> It all depends on the ability of the programmer.
>
> Jared
>
>
>
>
>
>
> "Grabowy, Chris" <cgrabowy_at_fcg.com>
> Sent by: root_at_fatcity.com
> 08/13/2002 10:24 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: RE: Dba tools on NT
>
>
> And it's difficult to write, looks like scrambled eggs when your
> done, and
> impossible to maintain...
>
> On the other hand, you could write the entire Windows XP operating
> system
> in
> one line of Perl...including Internet Explorer.
>
> -----Original Message-----
> Sent: Tuesday, August 13, 2002 12:49 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Without a doubt - perl - get it free from www.activestate.com. Why
> use it?
> Well, it is so flexible compared to other NT/DOS scripting tools
> you'll
> wonder why you never had it before! It's also portable meaning all
> those
> scripts you write should work on multi platforms with just a little
> tweak!
>
> Lewis Bishop
> ---
> Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
> Phone - 020 8298 3418
> Mobile - 07950 380857
> Email - lewis.bishop_at_woolwich.co.uk
>
>
> -----Original Message-----
> Sent: 13 August 2002 17:25
> To: Multiple recipients of list ORACLE-L
>
> This header confirms that this email message has been swept for the
> presence of computer viruses.
>
> Corporate IT
> THE WOOLWICH
>
>
> Hello all
>
> We are looking on programming and scripting tools
> for DBA team on NT.
>
> Can you, oracle DBA's on NT, tell me off the list
> what tools you are using for these functions
> and, if you be so kind, why you choose them.
>
> TIA
>
> Yechiel Adar
> Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
INET: Bruce.Reardon_at_comalco.riotinto.com.au
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 Wed Aug 14 2002 - 20:48:22 CDT
