-
I have Oracle 8.1.6 on Sun Solaris. I want to implement the messaging. If there is any problem in the database, I want to send an alert either on the mobile or the pager. How can I implement this?
Agasimani
OCP(10g/9i/8i/8)
-
Hey
i have implemented such as an email will send me and my provider send it to my phone.
If you are interested in such give me our email and i will send it to you.
I'm also interested in an procedure that send a sms to my phone or pager. Gives there a solution ????
Regards
Thomas Schmidt
-
Can you please send me the details on agasi123@hotmail.com? I have no idea as how to send the SMS to the mobile. If somebody out here can help us, That would be great.
Thanks and Cheers
Agasimani
OCP(10g/9i/8i/8)
-
Could you please also send me the same script at
r_sonakiya@hotmail.com
Thanks
-
Thomas,
If you don't mind and if the script that you proposed is small, could you post it on this forum, that way you could reduce the hassel of sending the emails to each and every request and keep this thread under control.
BTW, folks if you are using the OEM, it has the feature that enables you to send any alerts to your pager. Check the gate way configuration under preferences in OEM.
Thanx for the corporation.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
#!/usr/bin/ksh
# Created by: Tamilselvan
# Date: 11-Aug-2000
# Sun Solaris 2.6
# File: db_running.sh
#
# Description: This script checks all the background
# processes are running and also
# tnslsnr
# If not, send page to DBAs
#
###################################
#Set Parameters
###################################
ORACLE_SID=XXXX
export ORACLE_SID
####################################
# Test To Verify Database Is Running
####################################
PMON=`ps -fu oracle | grep ora_pmon_"$ORACLE_SID" | grep -v grep`
DBW0=`ps -fu oracle | grep ora_dbw0_"$ORACLE_SID" | grep -v grep`
LGWR=`ps -fu oracle | grep ora_lgwr_"$ORACLE_SID" | grep -v grep`
SMON=`ps -fu oracle | grep ora_smon_"$ORACLE_SID" | grep -v grep`
CKPT=`ps -fu oracle | grep ora_ckpt_"$ORACLE_SID" | grep -v grep`
RECO=`ps -fu oracle | grep ora_reco_"$ORACLE_SID" | grep -v grep`
ARC0=`ps -fu oracle | grep ora_arc0_"$ORACLE_SID" | grep -v grep`
TNSL=`ps -fu oracle | grep tnslsnr | grep -v grep`
if [ -n "$PMON" -a "$DBW0" -a "$LGWR" -a "$SMON" -a "$CKPT" -a "$RECO" -a "$ARC0" -a "$TNSL" ]
then
echo " " >/dev/null
else
echo "!!! URGENT !!! One of the background processes failed for $ORACLE_SID database."|mailx
-s "ATTENTION DBAs" 877101010@skytel.com 877101020@skytel.com
exit 1
fi
exit 0
-
hi there,
for install send mail following must be installed.
1) connect as sys user
2) run %Oracle_Home/javavm/plsql/jlib/initjvm.sql
3) run %Oracle_Home/rdbms/java/install/initplsj.sql
4) Configure the smtp-server
5) look that package utl_smtp is installed
6) For all big problems i call the procedure and give so me an info whats wrong in the db
CREATE OR REPLACE
PROCEDURE sendmail (
mail_server IN VARCHAR2,
sender IN VARCHAR2,
recipient IN VARCHAR2,
subject IN VARCHAR2,
message IN VARCHAR2)
IS
c utl_smtp.connection;
mesg VARCHAR2( 4000 );
crlf VARCHAR2( 2 ):= CHR( 13 ) || CHR( 10 );
BEGIN
c := utl_smtp.open_connection(mail_server);
utl_smtp.helo(c, mail_server);
utl_smtp.mail(c, sender);
utl_smtp.rcpt(c, recipient);
mesg:= 'Date: ' || TO_CHAR(SYSDATE, 'dd Mon yy hh24:mi:ss');
mesg:= mesg || crlf;
mesg:= mesg || 'From: ' || sender || ' <' || sender || '>';
mesg:= mesg || crlf;
mesg:= mesg || 'To: ' || recipient || ' <' || recipient || '>';
mesg:= mesg || crlf;
mesg:= mesg || 'Subject: ' || subject;
mesg:= mesg || crlf;
mesg:= mesg || '' || crlf || message;
utl_smtp.data(c, mesg);
utl_smtp.quit(c);
EXCEPTION
WHEN utl_smtp.transient_error OR utl_smtp.permanent_error THEN
utl_smtp.quit(c);
raise_application_error(-20000,
'Failed to send mail due to the following error: ' || sqlerrm);
END;
/
Regards
Thomas
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|