Re: Windows scripts requirement!!!
From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Sun, 15 Mar 2009 21:40:32 -0300
Message-ID: <172762180903151740o205ef52mf0d53f83863a22d1_at_mail.gmail.com>
look for services... instance services are OracleService<SID> and listener is <OH_NAME>Listener<LISTENER_NAME> (except when LISTENER_NAME is LISTENER), for alert log scan, you can use a third party monitoring tool, or use windows equivalent of more (which really sucks) and some sort of regular expression filter (perhaps you'll need python). Alert log rename, this can be done with WinAPI32, perhaps there is a program out there that already does that, but if you are a bit savvy with C or VB (pfff) you could do something yourself.
Date: Sun, 15 Mar 2009 21:40:32 -0300
Message-ID: <172762180903151740o205ef52mf0d53f83863a22d1_at_mail.gmail.com>
look for services... instance services are OracleService<SID> and listener is <OH_NAME>Listener<LISTENER_NAME> (except when LISTENER_NAME is LISTENER), for alert log scan, you can use a third party monitoring tool, or use windows equivalent of more (which really sucks) and some sort of regular expression filter (perhaps you'll need python). Alert log rename, this can be done with WinAPI32, perhaps there is a program out there that already does that, but if you are a bit savvy with C or VB (pfff) you could do something yourself.
HTH
Alan Bort
Oracle Certified Professional
On Sun, Mar 15, 2009 at 11:28 AM, edwin devadanam
<edwin_kodamala_at_yahoo.com> wrote:
> Hi,
>
> I need windows scripts to monitor 9i database(win 2003 server)
>
> 1)database and listener up and down status
> 2)alert log scan
> 3)alert log rename
>
> Thanks for any help
>
> Reg,
> Ed
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Mar 15 2009 - 19:40:32 CDT