RE: Need Script!!
There's great freeware smtp client called BLAT that you can use. You can probably google search for it or find it on www.download.com HTH. -Original Message- Sent: Tuesday, July 01, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Hi Group, In one of our client place we are having Oracle 8.1.7 (std Ed) on NT. Here we need to send mails if the DB is down or if the listener is down or any errors in the alert log is found. In Unix we can use shell scripts and awk to do this. What about in NT/ Guru's do you have any scripts to do the same. Please help me in this. TIA, Senthil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar D INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Need Script!!
you can use perl from activestate.com. run your awk script through a2p and see if it works. there are many mail modules... Mime::Lite, Mail::Send to name a couple. On Tue, 1 Jul 2003, Senthil Kumar D wrote: Hi Group, In one of our client place we are having Oracle 8.1.7 (std Ed) on NT. Here we need to send mails if the DB is down or if the listener is down or any errors in the alert log is found. In Unix we can use shell scripts and awk to do this. What about in NT/ Guru's do you have any scripts to do the same. Please help me in this. TIA, Senthil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar D INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Need Script!!
For the mail part use... On this page - http://www.interlog.com/~tcharron/blat.html Download and install his file - http://www.interlog.com/~tcharron/blat194.zip To send mail from a *.bat script- blat %myfile.log% -subject %mysubject% -to %toaddress% -f %fromaddress% For the scripting part you can do it all in simple dos bat files (really U can), perl (use ActivePerl from http://www.activestate.com), or you can do the Unix thingy by searching Google for Windows ports of Unix commands, they are easy to find, start here - http://www.weihenstephan.de/~syring/win32/UnxUtils.html Senthil Kumar D [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tworks.com cc: Sent by:Subject: Need Script!! [EMAIL PROTECTED] m 07/01/2003 08:19 AM Please respond to ORACLE-L Hi Group, In one of our client place we are having Oracle 8.1.7 (std Ed) on NT. Here we need to send mails if the DB is down or if the listener is down or any errors in the alert log is found. In Unix we can use shell scripts and awk to do this. What about in NT/ Guru's do you have any scripts to do the same. Please help me in this. TIA, Senthil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar D INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Need Script!!
Hi Senthil... I think you can get software from the internet... but... if you need to do it at command level... I would try a telnet to the 25 port... If you need assistance, I can create something similar here at work... and send it to you, just for sending mails... HTH JL --- Senthil Kumar D [EMAIL PROTECTED] wrote: Hi Group, In one of our client place we are having Oracle 8.1.7 (std Ed) on NT. Here we need to send mails if the DB is down or if the listener is down or any errors in the alert log is found. In Unix we can use shell scripts and awk to do this. What about in NT/ Guru's do you have any scripts to do the same. Please help me in this. TIA, Senthil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar D INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Need Script to Trigger Archive Log Cleanups
I need a routine which removes archive logs via RMAN tape backups if the
archive log destination exceeds half full. I already have the RMAN part
which we can kick off manually but I'm looking for something like a basic
cron job monitoring script which triggers this based on the half full
condition. Before I get started on this, does anyone have a script like
this which they'd be willing to share? I figured I'd do a df with awk or
Perl... but I'd rather just piggyback on someone else' fine script. :-)
Other ideas?
Simple enough to do in perl with a regex:
my $mountpoint = /some/dir;
my $cutoff = 50;
my ($used) = qx( df $mountpoint ) =~ /(\d+)%/;
if( $used $cutoff )
{
print $$: Disk use on $mountpoint: $used $cutoff;
# whatever you want down here
}
else
{
print $$: $mountpoint below $cutoff;
}
For multiple mountpoints iterate on df:
my mountz = qw( /foo /bar /bletch );
my $cutoff = 50;
my overz =
map
{
my ($used, $dir) = /(\d+)%\s+(.+)/;
$used $cutoff ? $dir : ()
}
qx( df mountz );
for my $dir ( overz )
{
print $$: Cleaning up $dir...;
# whatever
}
the map combines the extraction with a grep to remove
items that are blow the threshold. overz is syntatic
sugar, since the map could have cleaned everything up
for itself:
my roadkill =
map
{
my( $u, $d ) = /(\d+)%\s+(.+)/;
if( $u $cutoff )
{
# cleanup $d...
eval{ blah blah };
$ ? $ : ()
}
}
qx( df mountz );
print STDERR $$: Bad news, boss, cleanups failed:, roadkill
if( roadkill );
The eval leaves any messages from die in $, which then
get passed up to roadkill. That or pass on a was clean
message and change the array to results or something.
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
diskfrie
Description: Binary data
RE: Need script to generate DDL for snapshot/materialized view re
!! Please do not post Off Topic to this List !!
quick and dirty;
select 'create snapshot '||owner||'.'||name||' as ',query,';'
from dba_snapshots where owner = upper('ownernm')
order by name;
Join to dba_tables for storage params...
-Original Message-
Sent: Thursday, September 13, 2001 10:25 AM
To: Multiple recipients of list ORACLE-L
recrea
!! Please do not post Off Topic to this List !!
Hello all,
I need to regenerate the DDL to recreate a snapshot/materialized view in an
8.1.6 database, but I don't want to reinvent the wheel. Can anyone help me
out with a script?
Thanks in advance,
Jim
__
Jim Hawkins
Oracle Database Administrator
Data Management Center of Expertise
Pharmacia Corporation
800 North Lindbergh Blvd.
St. Louis, Missouri 63167
(314) 694-4417
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, September 12, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L
--- Forwarded message follows ---
To:
[EMAIL PROTECTED],[EMAIL PROTECTED]
Send reply to: [EMAIL PROTECTED]
Date sent: Wed, 12 Sep 2001 11:28:23 -0700
Indeed.
Hopefully people will be motivated to seek truth.
For your further consideration:
http://www.tikkun.org/index.cfm/action/current/article/40.html
-
http://www.tikkun.org/index.cfm/action/current/article/50.html
(excerpted below)
regards,
ep
On 12 Sep 2001, at 13:53, Erik J. Varney scribbled with alacrity and
cogency:
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
r
Date sent: Wed, 12 Sep 2001 13:53:32 -0400
Organization: Central Security Alarm, Inc.
I just have to say that the shining moment that has come out this horrible
tragedy is this We as Americans have been UNITED
EJV
--
AntiSemitism at Durban
Israel's Best Protection is a World Without Racism
Rabbi Michael Lerner | 09.07.2001 New York Times Op-Ed
September 5, 2001
By MICHAEL LERNER
AN FRANCISCO -- The walkout by the United States and Israel from the United
Nations
conference on racism in Durban, South Africa, was a predictable and
unfortunate
consequence of the irresponsibility of those in the Arab world who sought to
make
Israel a central issue. In supporting this shortsighted choice, the Arab
states have
played into the hands of right-wing politicians, in both Israel and the
United States,
who will benefit from the moral discrediting of the antiracist efforts that
many had
hoped would be the center of the conference.
American right-wingers who resist confronting the damaging legacy of slavery
and
segregation in the United States and the issue of reparations for slavery
can hide
behind the claim that in repudiating the Durban conference, they were
standing up
against racist anti-Semitism. Israeli right-wingers can use the record of
intolerance
at the conference to discredit criticism of the violence inherent in the
occupation of
the West Bank and Gaza, the bulldozing of Palestinian homes, and
stonewalling on the
issue of Israeli responsibility for the fate of Palestinian refugees. See,
they can
now say, all these criticisms are merely the latest attempt to label
Zionism as
racism, another episode in the eternal history of anti-Jewish sentiments and
double
standards among the nations.
On its face, the charge against Israel is ludicrous. Anyone visiting Israel
is
immediately struck by the fact that it is one of the most multiethnic
societies in the
world. It is, to be sure, a state for those who have accepted Judaism. But
that
includes black Jews from Ethiopia, Jews from India and China who bear all
the racial
characteristics of people in those societies, Jews who escaped persecution
in Arab
lands and are racially indistinguishable from Arab Muslims. The fact is that
whatever
your racial background, you can convert to Judaism and be accepted with full
rights in
Israel.
Moreover, unlike South Africa under apartheid, which targeted anyone born of
a certain
race, regardless of religion, Israel has given its largest minority, the
Israeli
Arabs, the vote and the right to representation in the Knesset. Israeli
Arabs have an
easier time having their votes counted than blacks in some parts of Florida
do. Israel
has no segregated movie theaters or beaches. And the patterns of segregation
in
housing are not sanctified by the law.
Israel, of course, gives special privileges to Jews - but this has nothing
to do with
race. It has a great deal to do with the history of the Jewish people, who
have been
persecuted for thousands of years for being part of a particular religious
community.
It was in light of that history that Israel was created by the United
Nations - as a
kind of international affirmative action to rectify a long history of abuse
by other
nations. Like all such programs, the special privileges for Jews should be
phased out
over time as anti-Semitism in the world becomes less of a
