Email Notification To DBA When Threshold Of 80% Reached For Archive Log?

Jul 10, 2013

 11.2.0.3 I want the database to email me when the threshold of 80% is reached for the archivelog and backup piece at recovery_dest folder how to do this. Is this the dict table  I will check for threshold? 

select * from v$recovery_area_usage;

 FILE_TYPE            PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES -------------------- ------------------ ------------------------- --------------- CONTROL FILE                          0 0               0 REDO LOG                              0 0               0 ARCHIVED LOG                       2.02 1.06              21 BACKUP PIECE                       4.76 0              11 IMAGE COPY                            0 0               0 FLASHBACK LOG                         0 0               0 FOREIGN ARCHIVED LOG                  0 0               0  7 rows selected.

View 11 Replies


ADVERTISEMENT

SQL & PL/SQL :: Dbms_scehduler Email Notification

Sep 13, 2012

I have set up my dbms_scheduler schedule and all run fine. I have set up the smtp server for outgoing email and it all looks good just like multiple of our other boxes here.The problem is that the event (SUCCESS) for a job is raised yet the email notification is not sent. My question is this: Is there somewhere where the actual log of email notifications sent (and/or failure there-of) is actually kept?

View 6 Replies View Related

SQL & PL/SQL :: Email Notification Using Oracle Advance Queue

Nov 28, 2012

I want to send an email notification using oracle aq for events like when a message goes to error queue. Similarly,Can I send an email notification when I create a queue or drop a queue?

How can I do this?

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

Workflow :: How To Get Response Of Notification Email From MS Outlook Express

Oct 20, 2012

I have two questions:

1. Our business users had a requirement to approve or reject the Workflow Notification Emails form their Email account on MS Outlook Express. When they perform action from MS Outlook Express it sends email to wfmailer but no action perform in application. The notification inbox in application shows this notification as OPEN notification and the requested function also shows 'Waiting for Approval'.

2. I need to hide Request Information button/link from the email notification send through Workflow mailer to user. There are three actions button available in email notification Approve, Reject and Request Information. I need to have only two button Approve and Reject. How to hide Request Information button.

View 3 Replies View Related

Scheduler :: Email Notification For Chain Job In Standard Edition One?

Jan 2, 2013

Oracle version :11.2.0.2 standard edition one

I'm trying to enable Email Notification for Chain Jobs, Jobs are running successfully, but i'm not getting email Notification.

i have done necessary SMPT setting in the Enterprise manager and i'm receiving test email from EM.

Below are steps followed:

1) i have created two Program
2)Add this program to a Chain
3)Created a Scheduler Job using this chain
4)Enable Email notification

Code for Email Nitrification:

BEGIN
DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION (
job_name => 'ChainJob',
recipients => 's.sankar@test.com',
sender => 'sankars@test.com',
subject => 'Scheduler Job Notification-%job_owner%.%job_name%-%event_type%',

[code]....

View 3 Replies View Related

Workflow :: R12.1.3 Sourcing Award Approval Notification - Email Attachment

Oct 9, 2013

I have a requirement where I have to show attachment in R12.1.3 Sourcing Award Approval Notification.I am able to achieve this by adding #ATTACHMENTS attribute in the message and Attachment appears in the Notification in the E-Business work list but somehow its not appearing in "e-mail notification". 

View 0 Replies View Related

Setting Threshold Value Without Using Grid

Jun 13, 2012

if I create manual database how to set threshold value? is there any other tool to set threshold value?

View 4 Replies View Related

PL/SQL :: Space Required To Reduce Threshold?

Jul 3, 2013

There are tablespaces where the current usage is crossed 90% and we are getting alerts.I want to know how much space required to add for these tablespaces ( datafiles) so that  current usage can be reduced to 80 %. or 70 % Is the any SQL query to find this information . oracle 10 g database.  . 

View 5 Replies View Related

SQL & PL/SQL :: ORA-29266 - End-of-body Reached

Apr 11, 2010

I am getting the error (ORA-29266: end-of-body reached) at utl_http.read_text. below is a code

create or replace procedure sendMail(p_fromaddress IN VARCHAR2, -- Optional
p_toaddress IN VARCHAR2,
p_bcc IN VARCHAR2, -- Optional
p_cc IN VARCHAR2, -- Optional
p_subject IN VARCHAR2,
[code]....

View 6 Replies View Related

Server Administration :: USERS Tablespace Reached 96 Percent After Manual DB Creation?

Mar 14, 2011

I created manually a database in 10g, after succesfully creating the dB, I created a single user re: LAMS. Now, I noticed that my USERS tablespace is currently at a 99.96% usage:

SQL> @check_space_used.sql
Monday, March 14, 2011 2:46:22 PM SGT

TABLESPACE_NAME TOTALSPACE TOTALBYTES PERCENTUSED
------------------------------ -------------------- -------------------- --------------------
SYSTEM 1073741824 239599616 23
UNDO 268435456 16449536 7

[code]...

View 5 Replies View Related

Application Express :: Script Output Reached Maximum Workspace Result Size Limit

Oct 18, 2013

I have created a workspace to use oracle apex, after a while I tried to run a script, the following message has been displayed to me,  The script output reached the maximum workspace result size limit. Delete existing results or contact your administrator to increase the maximum workspace result size.

View 3 Replies View Related

Notification In Workflow

Jun 6, 2011

My PO notification is showing only 5 lines even PO contains more than 5 lines. new to workflows.

View 1 Replies View Related

PL/SQL :: How To Get Database Notification To C++ Application

Dec 3, 2012

We are developing a C++ server which will process based on time based events. For example if a particular user has configured a particular task that has to be processed at a particular time, then an event or notification needs to be sent to the C++ server from the database, to initiate the task. The timming configuration is stored in the database, and the C++ server shouldnt poll the database at an interval, but event should be notified from the database at the configured timming.

We are using odatabase and odynaset libraries to connect and access the oracle database 11g.

View 8 Replies View Related

How To Implement Change Notification Database

Sep 3, 2013

how to implement change notification database in oracle forms?

I want to display some data to user،when change a table in database . now Can i do this work with change notification database in oracle form10g?

View 1 Replies View Related

Create Notification For Blocking Session

Aug 1, 2013

I want to create notification/ or triggered mail to my client and my dba group which will occur while session and user has been blocked. I want to create this procedure in 12c OEM.

View 3 Replies View Related

Enterprise Manager :: OEM 10g Backup Notification

Oct 16, 2007

I have been starting to use OEM 10g and am configuring backups through the maintenance portion. Is there a way to get backup success / failure notification sent to an email address?

View 8 Replies View Related

Loader Throughput (rows Per Second) Gives Out A Notification?

Feb 22, 2013

the Metric "Loader Throughput (rows per second)" gives out a notification on my Oracle 11gR2 instance:

Loader Throughput (rows per second) for <hostname>:1158_Management_Service,XMLLoader0 exceeded the critical threshold (3000). Current value: 3695.652173913043478260869565217391304348My problem is, that I can't interprete this value and don't know, if that is really terrible so I have to do something.

which and what this value belongs and what does that mean?

View 3 Replies View Related

Enterprise Manager :: Configure Gmail ID For Notification?

Aug 25, 2010

how to configure gmail id in enterprise manager.

it has smtp address but still i'm getting a error message

smtp.gmail.com: Test failed with message: "Sending failed; nested exception is: javax.mail.MessagingException: 530 5.7.0 Must issue a STARTTLS command first. t18sm1156251qco.20 "

View 1 Replies View Related

RAC & Failsafe :: Fast Application Notification With OCI Based App

Feb 14, 2006

We have an application that is written in C/OCI, and we want to use FAN on the database. Can we write C APIs that will work with FAN (monitoring)?

View 2 Replies View Related

Application Express :: Exit Icon On The Notification

Jan 24, 2013

I am using the notification from COM.ORACLE.APEX.GRITTER_NOTIFICATION but i am trying to make the exit button/icon be displayed all time. By default the exit / close button only appears when mouse over it what about if i want the icon to be displayed all time?

View 1 Replies View Related

Workflow :: Notification Timeout When Requested For Information?

Feb 21, 2013

We have implemented a approval notification for our customer which on a high level is as follows

requester -> Approver 1-> Approver 2

Once a request is submitted, the 'approval' notification goes to Approver 1 followed by Approver 2. The request is approved when both approves approve the request. If no action is taken by the approvers, the original notifications are cancelled and escalation notification is sent to supervisor of approver 2.

We have a timeout of 48 hours set for the initial approval notifications sent to the approvers (1 & 2). In case Approver 2 requests for more information using the 'Request information' button, the TIMEOUT clock does not seem to reset and the notification is cancelled after 48 hrs even if the notification is in the queue of the requester.

This is causing the escalation notification to be supervisor of approver 2.

The question here is why does the timeout clock not reset when the notification goes back to the requester for additional information. Is this how the standard oracle workflow notification behaves ? Is there a way to customize and achieve this ?

View 2 Replies View Related

How To Find Detail Of Failure Notification With Enterprise Manager

Apr 25, 2013

I use Oracle 9i and I created DBMS Job for run Procedure. when job run by scheduled I found Failure notify but I can not find where the detail of it. How do I find path or detail of Failure notify? I use oracle enterprise manager console.

View 1 Replies View Related

Workflow :: How To Find Actual Responder Name Displayed In Notification

Feb 13, 2013

Where are the details of the Actual Responder Details stored in the case of the below scenario

If a notification for one user was closed by another user through access to the first user's worklist, the name of the second user, who actually took the action, is displayed as the responder.

I am only able to find the Original Recipeint username in the wf_notifications table.But where will the details of the Actual Responder name displayed in the notification be stored.

When I use the "wf_notification.Responder" function, I get the Original Recipeint username of the user but not the one who acted on the notification. Is there ANY way by which I can get the Actual responder user name who acted on the notification

select responder from wf_notifications where notification_id = <nid> also gives me the Original Recipeint username of the user but not the one who acted on the notification

View 5 Replies View Related

Precompilers, OCI & OCCI :: Client Don't Receive Notification Upon Successful Registration

Feb 7, 2011

I am trying to understand on how ORACLE Continuous Query Notification works. I used the sample code from the ORACLE site:

//download.oracle.com/docs/cd/B28359_01/appdev.111/b28395/oci10new.htm#LNOCI13111

created employees and departments table under my schema.When I executed the sample code. I received an error

"ORA-24912: Listener thread failed. Failed to get IP address of host." that was generated from OCISubscriptionRegister.

Upon setting the client IP address through calling OCIAttrSet, the client can register successfully. I can see the registration entry in USER_ CHANGE_ NOTIFICATION_REGS.

I tried to trigger the notification by updating employee table as recommended. However, the client never received the notification.Is there a way to check if the server created notification and tried to send it out to the client?

View 3 Replies View Related

SQL & PL/SQL :: How To Get Email Address From Xml

Dec 27, 2011

I want to know how can I find/take from In parameter who is xmltype an email address ?

My function: (clob is cast to xmltype)

function submit(session_id in number, claim in clob) return xmltype

For example - I have more e-mail addresses in this:

<emails>
wtfn00b1@yahoo.com
wtfn00b2@inbox.com
wtfn00b3@mail.com
...
</emails>

I know that there is `extract` function for xml. How can I know if there is break or space between the emails ?

View 9 Replies View Related

How To Setup Email In 11g

Aug 1, 2012

I migrated a server + data + APEX application from 10g to 11g. Now my email sending is all messed up because of the ACL in 11g. I can't seem to figure out how to appease it. I have the smtp server correctly set in the parameters. Here is the procedure I'm trying to use (from [URL]):

CREATE OR REPLACE PROCEDURE send_email(
  pFromUser IN VARCHAR2,
  pToUser IN VARCHAR2,
  pSubject IN VARCHAR2 DEFAULT NULL,
  pBody IN VARCHAR2 DEFAULT NULL)

[code]....

View 8 Replies View Related

Getting Name In Email Address (Oracle SQL Plus)

Nov 6, 2007

How do I select the name in an email address. I would like to be able to order a list of email addresses by the name of the person ie. what comes before the @ sign.

So is there a query I could use to get everything before the at line . So in pseudocode I would need to be able to do something like this.

select substr(email, indexOf(@)+1,email.length) from table order by email

So I how could I go about doing that?

View 2 Replies View Related

SQL & PL/SQL :: Send Email In Oracle?

Apr 24, 2013

what is the best way to send an email in oracle?

1.utl_smtp
2.utl_mail
3.utl_tcp

View 6 Replies View Related

SQL & PL/SQL :: Email With Excel Attachment

Aug 4, 2011

I need the pl/sql procedure that sends email with excel attachment using utl_smtp.The email procedure should take the excel attachment file from my local directory.

View 6 Replies View Related







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