- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Tool to alert when database has error
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2007 05:22 PM
тАО11-26-2007 05:22 PM
Tool to alert when database has error
Please let me know if you know of any tools that can call or page the DBA when oracle database has errors.
Thanks in advance.
Regards,
Tom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2007 06:44 PM
тАО11-26-2007 06:44 PM
Re: Tool to alert when database has error
Which version of Oracle are you using?
In Oracle 10g, you have the Oracle Enterprise Manager Database control tool which is browser based. This tool gives you alerts about both performance and Errors.. and lot more.
You can also configure UTL_MAIL to help you configure custom messages.
Please post more information on your environment and requirements.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2007 07:17 PM
тАО11-26-2007 07:17 PM
Re: Tool to alert when database has error
what i am looking for is some tools to send my cell phone a message or call me when there is oracle error.
as sample below.
Errors in file /u10/app/oracle/admin/SUN/bdump/sun2_arc0_6636.trc:
ORA-00313: open failed for members of log group 9 of thread 2
ORA-00312: online log 9 thread 2: '+FLASHBACK/sun/onlinelog/redo099.log'
ORA-17503: ksfdopn:2 Failed to open file +FLASHBACK/sun/onlinelog/redo099.log
ORA-00020: maximum number of processes () exceeded
Thanks,
Tom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2007 07:19 PM
тАО11-26-2007 07:19 PM
Re: Tool to alert when database has error
i am using oracle RAC 10gR2 10.2.0.3
on HPUX 11.11
Thanks,
Tom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-29-2007 06:40 PM
тАО11-29-2007 06:40 PM
Re: Tool to alert when database has error
Sorry for this late followup.
If you have metalink access, please read the metalink note: 250657.1 with subject: How to set up 9i Oracle Enterprise Manager (OEM) to Send an SMS Notification to a Mobile Phone.
Normally, OEM will just sending a 'normal' email, but this will be converted to SMS by the Network provider's email/sms gateway.
In general, most mobile phone networks, provide an SMS email gateway facility which can translate emails into SMS messages. This is an option that needs to be enabled.
if you have more queries, do let us know.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-30-2007 04:51 AM
тАО11-30-2007 04:51 AM
Re: Tool to alert when database has error
I did manage to setup and send out email from outlook to cell phone as text message. and also send out alert from OEM to outlook. But somehow , i could not manage to send out alert from OEM to cell phone event i set it up as SMS. from the cell phone, i could see the message "could not receive the image".
is there a way to send alert as text and not images.
Regards,
Tom