Email Alert Log Daily Script Cron Job

Jun 10, 2013

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

View 3 Replies


ADVERTISEMENT

Develop Shell Script Which Will Do Monitoring Of Alert Log Daily

Nov 29, 2012

Oracle on 11gR2 on hp-ux 11.23.Need to develop a shell script which will do a monitoring of the alert log daily.

It should do a audit trail (only check for warnings/errors) for the last 1 day daily till collection time and output to a file.if no errors should output "No Errors/Warnings", else ouput the relevant.

View 12 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

Server Administration :: Alert Email Notifications?

Mar 20, 2011

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.

View 2 Replies View Related

How To Change Port Number Of Email Alert Notification

Nov 24, 2010

I want to configure the Email Alert Notification in OEM.

In OEM --> Setup --> Notifications Methods --> I am able to see a provision to enter SMTP Address, but there is no port number.

Due to some security policies, my company has opened only Port Number : 9925 for SMTP and blocked Port number : 25.

When I click on "TEST MAIL SERVERS" button, it gives me a error that :

"Test failed with message : Could not connect to SMTP Host , Port No. 25" .

Now I want to change this port number 25 to 9925.

View 5 Replies View Related

How To Get Daily Max (Value) Query

Dec 18, 2012

I am looking to get the maximum value for every 24 hour period for a month. So for example my date range can be defined by...

select to_date('&date','mm yyyy')-1 + level as DateRange
from dual
connect by level <= '&days'

...where I can provide the first date of the month and number of days in the month or a lesser value if less time is required. So, the results of the above query plus 24 for the range. I thought a some Googling would provide me what I needed, but my search came up empty.

I was hoping to do something like this...

select utctime, max(value) from table where utctime between.

View 3 Replies View Related

PL/SQL :: Set Daily Currencies?

Apr 25, 2013

CREATE OR REPLACE
PROCEDURE Set_Daily_Currencies
İS
incoming_data_ UTL_HTTP.html_pieces;
received_page_ NUMBER;
incoming_data_textclob_ CLOB;

[code]...

View 2 Replies View Related

SQL & PL/SQL :: To Run Procedure In Oracle Automatically At 5 Daily

Sep 17, 2011

i want to run the salary posting procedure automatically at mid night every day. i have created a job in toad and defined the required information but it is not working.

View 13 Replies View Related

SQL & PL/SQL :: Sum Daily Total To Weekly In Oracle?

Feb 17, 2010

I need to sum the below daily total to weekly with the week starting day of Saturday Jan 3 2009 for the 52 weeks in 2009. The below query provides me the weekly total with the week starting day MONDAY. But I need the week starting day to be SATURDAY instead of MONDAY.

select to_char(report_date, 'YYYYIW'), sum(total)
from report_table
where to_number(to_char(report_date,'YYYYIW')) >=
to_number(to_char(to_date( '&one_year_ago'),'YYYYIW'))
group by to_char(report_date, 'YYYYIW')

Here is a query I used to generate the Daily Sample Data:

SELECT DISTINCT A.PRODUCT, TO_CHAR(B.BEGIN_DT,'YYYY-MM-DD') as post_date,'RCSL', A.DEPTID, A.ACCOUNT, SUM( A.POSTED_TOTAL_AMT) as Amount_Posted
FROM A, B, C
AND B.BEGIN_DT BETWEEN TO_DATE('&StartDate','YYYY-MM-DD') AND TO_DATE('&EndDate','YYYY-MM-DD')
GROUP BY A.PRODUCT, TO_CHAR(B.BEGIN_DT,'YYYY-MM-DD'), A.DEPTID, A.ACCOUNT

For the below sample data I would need to add data starting 2010-01-02 - 2010-01-08 to get my weekly total.

7777,2010-01-01,RCSL,0170,331062,-85
7777,2010-01-02,RCSL,0170,331063,-190
7777,2010-01-03,RCSL,0170,341413,170.18
7777,2010-01-04,RCSL,0170,347103,-880
7777,2010-01-05,RCSL,0172,331050,-116
7777,2010-01-06,RCSL,0172,331053,-50
7777,2010-01-07,RCSL,0172,331061,-63
7777,2010-01-08,RCSL,0172,331061,-63

View 16 Replies View Related

Run Three Scripts One After Another Automatically For Daily Basis?

Mar 22, 2013

How do i run three scripts one after another automatically for daily basis. Say i have three scripts A,B,C and i want to run the three scripts A followed by B followed by C.

View 7 Replies View Related

Oracle Machines - Develop A Daily Replica From A To B?

Mar 13, 2011

The Oracle machine A (11R1) is placed in San Jose.
The Oracle machine B (10R2) is placed in Sydney.

I need to develop a daily replica from A to B. I don't need the entire db, but only some single schema.

The entire DB size is 1TB.The exp pump gzipped dump size will be 5+GB.Tnsping from A to B takes 500+ ms.The regular A exp pump -> ftp -> B imp pump will be too slowly because of the poor network.Which way it would be the best to implement it?

View 2 Replies View Related

Replication :: Update Database On Daily Basis?

Feb 7, 2013

There are 2 databases, database A and database B. Database A is Oracle 11.2.0.2 which runs on linux and Database B is Oracle 11.2.0.2 which runs on windows xp machine. In database A, there are 100's of tables which are being updated every 10 minutes or 15 minutes. For reporting purpose, the developer wants to run report for the tables. But since database A is being updated every now and then, generating reports takes almost 15 to 20 minutes. So the reports can be generated in Database B. Once in a day the database B should have the updated data from database A so that the reports can be generated in database B with less time. What could be the best solution for the database B to have the updated data on daily basis from database A in oracle?

View 3 Replies View Related

Replication :: Daily Refresh At Particular Hour / Minute?

Apr 28, 2009

However, I need to refresh the group manually sometimes. Therefore, I cannot set the interval as sysdate+1.have tried setting the interval as follows. However, they are not correct

Quote:trunc(sysdate+1) +4/24
The next interval will show 9:25:20pm.

Quote:trunc(sysdate+1) + interval '4' hour
Incorrect syntax

View 7 Replies View Related

Database Script Take Backup On Daily Basis

Sep 30, 2012

DB 10.2.0.2
OS Window Server

I need to create a script to take the oracle database backup on daily basis for windows. Which method will be good exp imp, rman or coldbackup?

In our case mostly chance system will crash and we need to OS install first and then restore the oracle home and full database.

View 8 Replies View Related

How To Find Tablespace Growth On Daily Basis

Feb 15, 2013

How can we find a tablespace growth on a daily basis for a 11.2.0.2 database?

OS: AIX 6.1

View 8 Replies View Related

RAC11g Private Connection Disconnected On Daily Basis

Sep 18, 2012

We have a 2-Node RAC11g R2.0.3 installed on Linux 5.5.

My problem to have a private connection disconnected on daily bases at 12:00 PM and 3:00 PM ONLY,and come back life within 2 minuets,I am using cross-over cable to connect those private interface , So in the ocssd.log Stating :-

2012-09-18 15:06:43.735: [ CSSD][1096161600]clssnmPollingThread: node racmain1 (1) at 50% heartbeat fatal, removal in 14.340 seconds
2012-09-18 15:06:50.752: [ CSSD][1096161600]clssnmPollingThread: node racmain1 (1) at 75% heartbeat fatal, removal in 7.330 seconds
2012-09-18 15:07:19.821: [ CSSD][1096161600]clssnmPollingThread: node racmain1 (1) at 90% heartbeat fatal, removal in 2.480 seconds, seedhbimpd 1

And the instance is restarted accordingly.

View 5 Replies View Related

Forms :: Data Copy Into Other Location On Daily Basis

May 22, 2010

I need any good suggestion basically I have two different location

1- Factory
2- Head office

I have developed PRODUCTION module in factory and it is working fine and now I want to send data on daily basis to head office therefore I develop a form which will create backup in export format (.dmp) then user will send via email to head office.

Backup file should be save in pre-defined location then user will use a form which I developed for loading data into head office there are two different buttons in this form;

First is used to load data, actually first I load data in a temporary user which creates whenever user will press this button. Second is used to copy data in application user but first it checks if data exists then update otherwise insert.

View 1 Replies View Related

SQL & PL/SQL :: Function To Find Max Last Logout Date For Each Agent Daily

Jun 3, 2010

I have to create a function. I need to find the max last logout date for each agent daily. For example, if an agent logged in for the first time at 9:00 and he logged out at 12:00 and he logged in again in 14:00 and he logged out at 15:00 the time I need my report to show is 15:00. How can I do that?In order to make it easiest for you to understand I am sending you this query:

select
a.login as login2,
To_Char(max(s.endtime), 'dd/MM/yyyy, HH24:MI:SS') as lastLogout
from cti.agent a
inner join cti.agentsessionlog s
on s.agentid = a.agentid and To_Char(s.endtime) != '31-DEC-99 11.59.59.000000 PM'
group by a.login;

This query returns the agent's login and the agent's last logout time. It works fine if I enter a date between but I cannot do that. If a use this query as it is and I try to export a report for 31/5 it shows as lastlogout the logout for 01/06 or 2/06. Is there a function I can use? I have a deadline.

View 7 Replies View Related

Server Utilities :: Daily Base Backup File

Apr 11, 2012

I made small Inventory software for Medical store. Now I want daily base data in DMP file. How to make current date in DMP file don't need all.

I mean I have 30 tables in oracle sql . They are daily update with new entry and some table has date column and some not. Actually I want to send daily Data via mail.

View 13 Replies View Related

Real Application Clusters :: DBA Daily (Routine) Tasks

Dec 17, 2012

What are the RAC DBA daily(routine) tasks?

View 6 Replies View Related

Server Utilities :: Data Pump Expdp To ASM Daily?

Jun 16, 2011

i succeeded to expdp to ASM diskgroup such as

create directory asmexpdir as '+RECO/FILTDB/EXPDP';
grant read,write on directory asmexpdir to oraasfs;
expdp oraasfs/oraasfs2301 directory=asmexpdir dumpfile=SBSR_EXP.dmp tables=TM_SFS_CUST_01 logfile=EXPDP_LOG:SBSR_EXP.log

SUCCESS MESSAGE

. . exported "ORAASFS"."TM_SFS_CUST_01" 387.2 MB 817684 rows
Master table "ORAASFS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for ORAASFS.SYS_EXPORT_TABLE_01 is:
+RECO/filtdb/expdp/sbsr_exp.dmp
Job "ORAASFS"."SYS_EXPORT_TABLE_01" successfully completed at 03:34:59

And I like to run this daily and delete after 14 days. but it show error, what can be the solution to run this script?

#!/bin/bash
#Script to Perform Datapump Export backup Every Day
################################################################
#Change History

[code]...

View 9 Replies View Related

PL/SQL :: Sync Data From Emp To Emp_target Table Daily (sysdate - 1) Records

May 8, 2013

Think that emp as an oltp table i want to sync the data from emp to emp_target table daily(sysdate - 1) records

SQL> create table emp_target as select * from emp where 1=2;

Table created.

View 9 Replies View Related

Recovery Manager (RMAN) :: Script / Daily Incremental Backups With Configure Commands For Oracle 11g Database

Aug 29, 2012

the rman backup script for weekly full backup and daily incremental backups with configure commands for oracle 11g database.

View 10 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

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







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