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.
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 ?
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.
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
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)?
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?
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.
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""
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.
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;
I'm working on my test db and what I thought to be an easy task is turning out to be very difficult. I am trying to set up a cron job to email me daily the alert log to check for errors. I tested the script and it is not working this is what I have to email me the alert log
mailx -s "Alert Log for Testdb" oracleexample@gmail.com > /testapp/oracle/diag/rdbms/testdb/testdb/trace/alert_testdb.log
I am working on Forms [32 Bit] Version 11.1.1.4.0 (Production). OS is Win 7 (32 bit). Internet Explorer 8. My Requirement is I need to raise an alert when user close the browser window before closing the Form.
I'm trying to set up alert notifications. I have to program it myself, because SE isn't allowed to do it with OEM. As far as I can see from the documentation, this should be all that is necessary:
conn / as sysdba exec dbms_aqelm.set_mailhost(mailhost=>'127.0.0.1') exec dbms_aqelm.set_mailport(mailport=>25) exec dbms_aqelm.set_sendfrom(sendfrom=>'alert@noreply')
[Code]......
but this gives me:
ORA-24940: invalid combination of ANONYMOUS namespace, default presentation and e-mail receive protocol ORA-06512: at "SYS.DBMS_AQ", line 737 ORA-06512: at line 11
I must be missing something! Probably something very basic. There is nothing in any trace files.
where i can find an alert log errors so whenever they occur in my RAC so i can comprehend them very well. I am trying to know that what can be the errors when u have RAC with ASM and SAN .
is there any alarm in moving alert logs generated in the grid infrastructure. The alert log in the grid log directory has grown around 2gb .Our CRS version 11.2.02. on linux. Also pls, Sample script for automating the same.