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