Oracle Database Alert Engine

Mar 15, 2011

I am running Oracle XE . This database collects information about server statistics in my organization ( memory usage, threads running, etc). Now , I need to send alert/ notification emails if the certain thresholds are crossed by server ( ex: if number of threads increase more than 100, send an alert email).

One way to do this is to write stored procedures and schedule them to run every hour and send alert email if conditions are met.

But what I want to do is to use some sort of rule engine where I can specify the rules/conditions which have to be true for alerts to be sent. The reason I want this approach is so that every time there is a new rule, I do not have to write a new stored procedure and I can just specify the condition in the rule engine . So are there any Rule Engines out there that I can use (preferably open source and free to use)?

View 2 Replies


ADVERTISEMENT

Reports & Discoverer :: Oracle Report Engine Error

Jul 4, 2013

I m trying to run reports from my application developed using Oracle FORMS6i but the report engine does not show any job. Platform Information: Microsoft Windows Server 2012 Version 6.2 (64 bit).

View 2 Replies View Related

Is It One Alert Log Per Instance Or One Per Database

Jul 28, 2010

Is it one alert log per instance or one per database? My guess would be per instance, but I have some documentation that indicates per database.

View 4 Replies View Related

LGWR Switch In Database Alert Log Every 3-4 Minutes

Jul 6, 2012

i am seeing (LGWR switch) happening in my databsae alert log every 3-4 minutes. is that appropriate? if not, what measure can i take to reduce this?

View 1 Replies View Related

Version Of PL Engine?

Aug 28, 2008

How to know the version of PL/SQL Engine

View 1 Replies View Related

Forms :: Report Engine Is Not Running

Jul 22, 2010

I am facing a problem while calling a report from FORM.the system gets hang and RWRBE60.EXE is not started.I am using client/server environment and Form 6i.

View 2 Replies View Related

Forms :: Reports Background Engine Stopped Working

Jun 28, 2011

When i run my reports on Windows 7 i receive the following error Reports Background engine Stopped working

When i view the detail of the error it shows

Problem Event Name APPCRASH
Application name RWRBE60.EXE
Application Version 3.0.0.0
Application Timestamp 38a27e49
Fault Module Name rwlib60.dll
Fault Module Version 0.0.0.0

I think it is sufficient information for you experts to resolve this issue reports are designed in developer 6i please view the attached image for report error detail.

View 8 Replies View Related

Application Express :: Views In 4.1.1 Is Crashing Apex Engine

Dec 11, 2012

I have over 27 views in apex and made a column name change in the views and after I compile about 4 or 5 of them, the apex engine crashes. I was compiling the data views first, before moving on to report views. When I upload the views and ran them in the as a script, it said all of the views were created.When I went into object browser most of the views compiled. I recompiled the ones that were marked red. I compiled them in the code window, incase it threw an error, I can fix it there.

I had problems with views, before causing core dumps when I compiled them, but figured I had to compile the views in a certain order.

View 6 Replies View Related

Forms :: Alert Cancel Button Gives Non Oracle Exception

Jan 20, 2011

i've created an alert with 2 buttons and the code for cancel button is as follows:

...
if alert_id = alert_button2
then
raise form_trigger_failure;
end if;
...

this code is in a pll and when called from a form it displays a non oracle exception message. How to do nothing when the user presses cancel on alert pop-up? apart from using null instead of raising the above exception?

View 5 Replies View Related

Networking And Gateways :: ORA-3136 Frequently In Oracle Db Alert Log File

Jan 2, 2011

I am facing below error so frequently in alert log file Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.1.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.1.0.6.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.1.0.6.0 - Production
Time: 03-JAN-2011 02:00:00

[code]....

View 18 Replies View Related

Application Express :: Error When Refreshing Report Region / ORA-20876 - Stop APEX Engine

Mar 26, 2013

I'm using Apex 4.2. On click of a button, I refresh 2 Standard Region Reports with a Dynamic Action. This dynamic action has been working without problems for WEEKS and all of a sudden i'm getting the ORA-20876: Stop APEX Engine error when I click the button.

In the dynamic action, I removed the refresh of the second report and now the error does not occur. If I add the second refresh action back in, it throws the above error. I've even tried making the second report identical to the first and the refresh action fails. why this is failing on the second refresh action since the second report & region is IDENTICAL to the first report now.

View 3 Replies View Related

Multiple Alert Log In 10g RAC

Jan 9, 2013

We have Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit RAC in Linux and syslog server also in Linux.

syslog server is a centralize server to monitor all the system and database log.

is there any way to create a multiple alert log file. so that we can keep one alert log file in default location and another alert log file in centralize syslog server for monitoring purpose.

View 3 Replies View Related

Alert Log Monitoring?

Jul 23, 2012

I'm using this logic to avoid specific error.Does not seem to be working fine. Any other method to exclude perticular error from monitoring.

if [ -n "$line_no1" -o -n "$line_no3" ] ; then
cat $script_loc/alrt_chk.log | grep -i "ORA-" > $script_loc/ora_alert_only.log
#----
echo "Entering in while Loop"

[code]...

View 2 Replies View Related

XML - Formatted Alert Log?

Jul 7, 2013

 My database version is 11.2.0.3  Is there any added advantage using XML-formatted alert log file over text format alert log?

View 4 Replies View Related

How To Access Alert Log Using Sql

Aug 21, 2012

How can we access Alert log using sql, without sys privilege in oracle 11g ?

View 17 Replies View Related

How To Set Tablespace Alert Message

Aug 11, 2012

How can i set alert message for users tablespace.

for ex

My users(tablespace) data file size is 100m . If 90m reached , i need some alert message through email or mobile.

Os : linux 4
version :10.2.0

View 2 Replies View Related

Finding Alert Log File

Dec 23, 2011

How can i come to know that which current alert log file is being used for database? Is their a command at database level to find out the current alert log file to which database is using ?

View 2 Replies View Related

Server Administration :: Sys To See Alert Log?

Oct 18, 2011

one can only see the alert log, trc ...with sys log in?

View 12 Replies View Related

Server Administration :: Alert Log For ASM

Jul 13, 2010

Is there any separate alert.log for ASM instances?

SQL> show parameter BACKGROUND_DUMP_DEST

The above will give the dest of the alert.log for DB only?Is is the same for ASM instances? If different then where to look for.

View 2 Replies View Related

Forms :: Pop-up Or Alert On Desktop?

Nov 10, 2012

i am using .dot net frame work to show a pop up on desktop like reminder , can i do that using any oracle tools i am using oracle 10g along with forms 6i , i am using one query for this.

View 4 Replies View Related

Script To Email Alert Log

Aug 24, 2013

I have been looking for a script to email me a daily log of my alert log. I have tried mailx -s command,

View 1 Replies View Related

Send ORA-error Alert Through Mail?

Feb 20, 2011

how to create trigger or procedure for send all ORA- error alert mail from database. if any ORA - error comes in ALERT_SID.log then after trigger send the mail to my mail id

View 4 Replies View Related

Forms :: Alert While Deleting The Record

Mar 20, 2013

I want to create one alert while deleting the record from the custom form. So i have written the below code in the when-remove-record trigger.

DECLARE
alert_button NUMBER;
BEGIN
IF :XXWIPRELFRM.PRINTED = 'Yes' THEN
alert_button := SHOW_ALERT ('DELETE_ALERT');

[Code]..

When i click on the delete(X) symbol in the form, it is showing alert but when i click on "No" also its removing the record..what i need to write.

View 7 Replies View Related

SQL & PL/SQL :: Sending Alert Mail Based On Value?

Sep 21, 2012

I have a table with 4 columns

select * from temp

A B C D <- columns.

I have to send an alert mail based on the value of column C when its value is 50. It should be able to send mails 24x7

View 4 Replies View Related

Server Administration :: Outdated Alert Log?

Mar 4, 2010

Our dev server has 7 instances on it (in one box). I noticed that most of it's alert logs are not up-to-date (generation is delayed by almost 1 week). What should I supposed to do with it?

View 6 Replies View Related

Thread 1 Cannot Allocate New Log / Sequence In Alert Log

Jul 11, 2012

I am getting the below message in my alert log

System: AIX6.1 - Oracle 11r2

GROUP#     THREAD#     MEMBER                                  ARCHIVED     STATUS             MB
1     1     +DATA01/mydb/redolog_group1_member1     NO         INACTIVE             1536
1     1     +DATA01/mydb/redolog_group1_member2     NO         INACTIVE             1536
2     1     +DATA01/mydb/redolog_group2_member2     NO         CURRENT          1536
2     1     +DATA01/mydb/redolog_group2_member1     NO         CURRENT          1536
3     1     +DATA01/mydb/redolog_group3_member2     NO         INACTIVE             1536
3     1     +DATA01/mydb/redolog_group3_member1     NO         INACTIVE             1536Tue Jul 10 18:37:48 2012
[code]....

Could an increase on the redo log file sizes solve this problem? Unfortunately I do not have a test platform, where I could have tested this.

View 14 Replies View Related

Does Every ORA-XX In Alert.log Generates Incident On Adrci

Jan 31, 2013

I'm looking for errors in alert.log, I thought that every "ORA-XX" would be a incident in adrci, but "i have missed" some ORAS-XX

I have a wrong job in my test environment which generates an ORA-12012 every 5 minutes. If we chech the alert.log trace we can see that there is a recor every five minutes (more of less)

oooo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo
adrci> show alert -tail 2
2013-01-31 12:59:01.901000 +01:00
SMCO started with pid=23, OS id=20719
2013-01-31 13:00:23.033000 +01:00
Errors in file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_j000_20765.trc:
ORA-12012: error on auto execute of job "TEST"."WRONG_JOB"
ORA-04063: package body ""TEST"."WRONG_JOB"" has errors
ORA-06508: PL/SQL: could not find program unit being called: ""TEST"."WRONG_JOB""

[code].....

But, if we look for for incidents

oooo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo

adrci> show incidents

ADR Home = /opt/oracle/diag/rdbms/xe/XE:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
23393 ORA 600 [kzsviver:1] 2012-09-27 09:19:55.054000 +02:00
23394 ORA 600 [kzsviver:1] 2012-09-27 09:20:13.540000 +02:00
23409 ORA 600 [kzsviver:1] 2012-09-27 09:56:35.688000 +02:00

[code].....

This ORA-12012 doesn't appears.

View 8 Replies View Related

Forms :: How To Display First Canvas Before Alert

Aug 31, 2010

I need to display my alert prompt right after I detect the discrepancy on amount. I place my code on POST-BLOCK. The problem is, after the query, the alert pops out right before the new canvas where the block with POST-BLOCK trigger shows.

I need to display first the canvas before the alert but seems like the process of displaying canvas is the last job oracle does. So even if I place my code on post-record or any other trigger it will be the same.

View 1 Replies View Related

Alert Log And Listener Log File Purging In 11g?

Mar 6, 2013

how to purge the alert log and listner log file in 11g.

OS:IBM/AIX RISC System/6000
DB version: 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

View 8 Replies View Related

Alert Log Not Displaying Timestamp Correctly

Oct 25, 2012

I am using Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production installed in IBM AIX 6.1.0.0

I find this peculiar situation that the alert log is not getting update with proper timestamp for example i see an update now under my alert log of this fashion

Tue Oct 23 08:38:46 2012
ARC2 started with pid=37, OS id=50
Tue Oct 23 08:38:46 2012
ARC3 started with pid=38, OS id=178
Tue Oct 23 08:38:46 2012

[Code]...

But the current system time is

Tue Oct 23 18:40:20 GMT+05:30 2012

My memory_target parameter value is 2GB

SQL> SELECT TZ_OFFSET(SESSIONTIMEZONE), TZ_OFFSET(DBTIMEZONE) FROM DUAL;

TZ_OFFS TZ_OFFS
------- -------
+05:30 -05:30

I am clueless.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved