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?
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.
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.
i'm a trainee for my PFE and i should to implement a physical standby database,i chosed this tuto URL.... but in step 10 when i do SELECT * FROM v$archive_dest where dest_id=2 ; i have i message error.
ORA-12154: TNS: could not resolve the connect identifier specified.
I working on a Production Environment, where our Database is running on a IBM-AIX platform.I need to implement Logical standby database for reporting purposes, in order to improve the performance.Now the transaction and the reporting is done at the same site itself.I want to know that, operating system and platform architecture (RAM size, no. of CPUs, ORACLE_HOME etc..) on the primary and standby systems must be same or can be different. complete configuration for Dataguard. My os version is,
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
My PO notification is showing only 5 lines even PO contains more than 5 lines. new to workflows.
View 1 Replies View RelatedI 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 RelatedI'm in the process of making a list of changes. What database application changes would be classified as standard changes and would not require a CAB meeting and which ones would be deemed critical that a CAB meeting would be required before going ahead with the change.
View 2 Replies View RelatedI 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 RelatedI 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 Relatedthe 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?
how can i change my oracle database language
View 6 Replies View RelatedI 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?
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 "
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 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.
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 RelatedWe 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 ?
Currently my oracle database character set is we8mswin1252 and it is only containing English data as well as spatial data (which is in English of course). I would like to change the Database character set so it could accept Arabic characters.
I have checked the below command on a test DB and it worked fine, but I want to know if it's recommended as a best practice when changing the character set to accept arabic and this won't corrupt my old entered Data ?
SHUTDOWN IMMEDIATE
STARTUP RESTRICT
ALTER DATABASE CHARACTER SET INTERNAL_USE AR8MSWIN1256
SHUTDOWN IMMEDIATE
STARTUP
i have a oracle server installed enterprise edition, for some reation i need to degrade the version from enterprise to standard
i need same tablespace,data's everything same as of now.
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 RelatedI 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.
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]....
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
We are converting WE8ISO8859P1 oracle db character set to AL32UTF8. Before conversion, i want to check implication on PL/SQL code for byte based SQL functions.
What all points to consider while checking implications on PL / SQL code? I could find 3 methods on Google surfing, SUBSTRB, LENGTHB, INSTRB. What do I check if these methods are used in PL/SQL code?
What all other methods should I check? What do I check in PL/SQL if varchar and char type declarations exist in code? How do i check implication of database character set change to AL32UTF8 for byte bases SQL function.
I have two databases called
a) Old Retailer database
b) New Retailer Database
We cant delete old database but we are using and we want to use both of them.
Now problem
Both dbs have a table called retailer.
I want to prevent duplication in them.
I.e it there is a retailer 12 created in old one new one shldnt allowo us to create retailer
id---12
similarly if there is a retailer 13 in new one it shouldnt be created in old table
retailer ids are unique. its not the case that with retailer id for example 5 there is a
different retailer in these two tables of diffferent DBS. Its unique
Now I have to put this criteria
how can i do it?
Second questions===================
if a primary key is auto increment. how can i skip some numbers lets say it is 1,2,3,4
i want that when next record shld be inserted it shld be 6 not 5. i dont want to feed the value 6. i want to know how to change indexing of primary key to skip some numbers when its set to auto increments.
How can we change Port 1521 in forms 6i and oracle database 8.1.7
View 1 Replies View RelatedI want to change database login in report at runtime.
For Example. I have created and run a menu by using database login "ABC/xxx" and want to run a report through this menu directly (Without using form) by different data base login i.e "xyz/ddd".
what is the sol. except passing user id at report call i.e rwrun60 parameter.
I am going to change some parameters on primary database (db cache, java pool etc.). I am not sure, if the changes are automaticallly propagated to standby or if I have to make the changes manually on stanby site too? I couldn't find clear answer in documentation. how parameter changes work in dg physical configuration?
View 2 Replies View RelatedI have restored database with the name DB to another database called DB01
it is in STARTED status (not mounted) and it seems I can not change the name if it is not mounts, and I can not mount it because of the name, how to solve this issue if possible? I have RMAN full backup from DB on my current server which hosting the database DB01 the initdb01.ora is ready and configured with DB01
what can I do next
ORA-01103: database name 'DB' in control file is not 'DB01'
