OraFAQ Forum: Server Administration » How can i email Database status/user logon info after every 40 min

Home » RDBMS Server » Server Administration » How can i email Database status/user logon info after every 40 min

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can i email Database status/user logon info after every 40 min [message #155706]

Wed, 18 January 2006 01:40

AsimAli_5
Messages: 4
Registered: December 2005
Location: PAKISTAN

Junior Member

Q-1.
This task is assigned by my senior DBA that
i must configure oracle server to email him
status of database (statistics)and user logon
information after every 40 minutes.
my senior DBA is out of city and he want to aware of
database condition.
How can i do this in 9i-release.2

Q-2.
How can i make my database available on net.I mean
our head office is in other city and they wanted
to access our database,what should i do to do this.
Thanks in advance.
Asim

Attachment: ABC.txt
(Size: 0.47KB, Downloaded 967 times)

Report message to a moderator

Re: How can i email Database status/user logon info after every 40 min [message #155722 is a reply to message #155706]

Wed, 18 January 2006 02:55

suryaevl
Messages: 8
Registered: October 2005
Location: Chennai

Junior Member

For Your Q2.

First find and establish connection between Your HO and
your place. Leased line Connectivity kind of thing will work.

Then it is as good as configuring your local machines.
If you want to put your DB on net, then you have to take more
precautions. What is the OS , on which your DB is residing.

Better the above kind of connectivity will be best,as
only your HO is going to access.

For Q1 - will come back to you soon

Report message to a moderator

Re: How can i email Database status/user logon info after every 40 min [message #155724 is a reply to message #155722]

Wed, 18 January 2006 03:27

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

And for Question 1:

Look into Oracle's manuals for UTL_SMTP package. It provides the facility to send e-mails.

Report message to a moderator

Re: How can i email Database status/user logon info after every 40 min [message #155741 is a reply to message #155706]

Wed, 18 January 2006 04:40

Gerardo Fernandez Herrera
Messages: 58
Registered: January 2006
Location: Montevideo, Uruguay

Member

Q1 - Oracle Enterprise Manager can do that.
You do not have to code a single line. It has an email alert system, where you can easily set many different conditions that fires the alert or a status report.

Regards.

Report message to a moderator

Previous Topic:	small database
Next Topic:	Resetlogs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 10:43:58 CST 2025