How about changing it in one location, and then scp/rcp/ftp the file out to
all the other servers. You could script it to loop through hosts.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message--
Dennis,
Are these unix servers?
We have a directory that includes our monitoring scripts (as well as some
other stuff)
that is cross-mounted across all of our unix servers. We run the same
monitoring
scripts on all of our databases. The scripts need to be made generic to
do so.
We pass in S
Try AlertView, it's free, a gui tool for monitoring as many database
alert.logs as you want. Go to www.zephyrus.com to download it.
HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 07, 2002 1:57 PM
> Hi All,
> Currently
[EMAIL PROTECTED] wrote:
>
> Hi All,
> Currently I am the only DBA for the 15 productin databases in our company.
> I have written shell scripts on all database servers to parse the alert.log
> file and look for Oracle errors and send page/E-mail if problems are found.
> While this works it is so
Dennis,
I'm not sure if you have any NT boxes or not, but for the unix side have
you considered setting up an NFS share? You could store one copy of the
script there and mount that share on the db servers. Then just schedule it
like you normally would (cron,at). Depending how your script works
cc:
Sent by: Subject: Re: Centralized Alert Log
Monitoring
[EM
Sent by: Subject: Re: Centralized Alert Log
Monitoring
; 847-954-8328
>
>
>
> "Brian Haas"
>
> riend.com> cc:
> Sent by: Subject: Re: Centralized
Alert Log Monitoring
> [EMAIL PROTECTED]
>
>
>
pients of list ORACLE-L
<[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: Centralized Alert Log
Monitoring
Wow! Sounds nice, but it seems like a lot of time invested. I imagine for
shops with many DBs (we've got <10 production), this could save time in the
long-run.
We just made a simple Korn script that checks all .log and .trc files in the
$ORACLE_ROOT tree for certain keywords, like "error" and "
ate.vt.us> cc:
> Sent by: Subject: Re: Centralized
Alert Log Monitoring
> [EMAIL PROTECTED]
>
>
> 01/07/02 01:15 PM
> Please respond to
> O
ke a nice rev 2 tool.
Any thoughts on this?
Jared
[EMAIL PROTECTED]
mTo: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED]
Dennis:
I read an article in Oracle Magazine about a technique called
'Do-it-yourself
Views' (called DIY$ views in the article). The article is at
http://www.oracle.com/oramag/webcolumns/2001/index.html?diy_dynamic.html.
If you have 8i or above this would work for you. Basically, it allows
you
I like your plan a lot. I'd like to hear about you accomplish step 2.
I already use a centralized monitoring database to store statistical data
and use Excel to graph the results (or I was doing this last time I worked
with Oracle - still looking for my next position!).
Randy
-Original Mes
I'm working on a complete monitoring system written in Python. I made a list
of all the things I want to check for and am working my way through the list
as I find time. I chose Python because I really enjoy programming in the
language and find that it does everything I need with few issues.
While the script approach is excellent, and you have gotten several
good answers on how to use it, might I suggest looking into event
triggers? If you are running 8i or above (not 8.1.5, it's buggy on
this), you can create a database level trigger ON ERROR. If you
have Java turned on for your
16 matches
Mail list logo