Oracle Cloud Infrastructure
Coming soon ...
Apps R12.2
  • R12.2 Architecture
  • Cloning Error (RC-50208)
  • Apps R12.1
  • Major changes from 11i
  • R12:HTTP Debug Logging
  • Compile Apps Schema invalid objects in R12
  • Apps 11i
  • Apps Components and Architecture
  • Concurrent managers
  • Patching
  • Using AD Patch
  • Using AD Control
  • FNDCPASS utility
  • Single-node Installation
  • Multi-node Installation
  • Find Apps Version
  • Cloning
  • Upgrade 11.5.9 to 11.5.10.2
  • Upgrade from 11.5.10.2 to R12
  • Upgrading 9i to 10g with 11i
  • 11i/R12 General Topics
  • AppsDBA System Management Utilities Guide
  • Identifying Long Idle Sessions
  • Identifying High Active Sessions
  • Change hostname for EBS
  • Oracle 12c Database
  • Oracle12c PSU Apply
  • Oracle12c Datafile moved Online
  • Oracle 11g Database
  • Upgrade 10g to 11g R1
  • Upgrade 11.2.0.2 to 11.2.0.3
  • Database 9i-10g
  • Top 99 Responsibilities of a DBA
  • General Info
  • Database Patching
  • 10g:ASM
  • 10g:Data Pump
  • 10g:Data Guard Installing
  • 10g:Rollback Monitoring
  • 10g:Flashback Table
  • Tablespace Management
  • Materialized Views
  • 10g:Enterprise Manager
  • 10g:Upgrade
  • Error:Ora-01631
  • DBA Scripts
  • Disk I/O,Events,Waits
  • Tablespace Information
  • Session Statistics
  • Hit/Miss Ratios
  • User Information
  • Rollback Segments
  • Full Table Scans
  • Contention/Locking
  • Redo Log Buffer
  • Data Dictionary Info
  • Oracle10g Application Server
  • Oracle10g Application Installation
  • (Re)Securing OAS Control
  • Oracle AS10g null protocol issue
  • Oracle Backup & Recovery
  • RMAN
  • RMAN Setup
  • Backup Recovery
  • Flash Recovery Area
  • Oracle10g Discoverer with Apps
    Coming soon ..............
    Troubleshooting
  • Discoverer Troubleshooting
  • Access EBS in mozile
  • Linux and Unix Platforms
  • How To configure NFS
  • Unix/Linux Command
  • Change hostname in Linux
  • SENDMAIL configuration
  • This Oracle Application DBA Portal is the biggest knowledge gateway for the people in the world of Oracle...
    Friday, January 29, 2010
    Workflow Notification Mailer Setup
    Workflow Notification Mailer Setup
    NOTIFICATION MAILER ARCHITECTURE

    The main component of the Oracle Workflow Notification Mailer is the executable
    WFMAIL. This is a server side program that queries the database for any pending
    notifications. It then dispatches these notifications by calling sendmail for UNIX and the MAPI APIs for Microsoft Windows NT. The notification mailer also queries the local inbox for incoming messages. These messages are validated and then passed to the database for response processing. To configure Workflow Notification Mailer we have to do OS level setup (Sendmail) and Application level setup.

    1. OS Level Setup
    2. Application level Configuration

    1. OS (Oracle Enterprise Linux 4 update 7) level Setup
    At Os level we need to do bellow setups before configuring Application level
    Sendmail should be installed by default when you install RedHat Linux. If it is not then you need to install the Sendmail RPM’s with the Red Hat distribution
    Sendmail RPM’s (In Oracle Enterprise Linux 4 update 7)




    Note: By default Oracle Enterprise Linux 4 update 7 have above all RPM’s

    A. Configuring Sendmail

    Edit the /etc/mail/sendmal.mc file
    Look for this bellow line in this file
    DAEMON_OPTIONS (`Port=smtp,Addr=127.0.0.1, Name=MTA')dn


    Add 1 line with SMTP port Number and Server IP to this above line

    DAEMON_OPTIONS (`Port=25,Addr=192.168.1.61, Name=MTA')dnl

    Here 25 is SMTP Port Number, 192.168.1.61 is Server IP

    After adding his like file look like this

    DAEMON_OPTIONS(`Port=smtp,Addr=127.0.0.1, Name=MTA')dnl
    DAEMON_OPTIONS(`Port=25,Addr=192.168.1.61, Name=MTA')dnl

    Save the file


    Rebuild /etc/sendmail.cf from the revised /etc/mail/sendmail.mc
    $m4 /etc/mail/sendmail.mc > /etc/mail/sendmail.cf


    Restart the sendmail services
    $ /etc/init.d/sendmail restart
    B.Starting Sendmail
    You can use the chkconfig command to get sendmail configured to start at boot time
    $chkconfig sendmail on
    The services should now be set at the appropriate run levels and then checked to ensure they are correct.

    #chkconfig --level 2345 sendmail on

    To check run level
    #chkconfig --list sendmail
    C. Check the sendmail services
    $telnet
    $telnet 192.168.1.61 25



    Now sendmail is working



    D. Dovecot IMAP Server
    Now that the sendmail server has been setup to allow the sending of emails, we need to configure a means for the user to retrieve any emails that are waiting for them on the server. One of the packages that do this is dovecot, which handles POP and IMAP mailboxes in clear text or with link encryption (POPS and IMAPS); IMAPS is the preferred mail protocol for MUAs.
    Install Dovecot RPM if not installed



    E: Start the Dovecot services
    Start the services from Command

    $ /etc/init.d/dovecot restart
    Or
    Start Dovecot services from Server





    Start the dovecot services then save

    F.Check the Dovecot services
    $telnet 192.168.1.61 143


    G. Check the mails are going to your mail ID from Linux command line
    $ mail –s “Hi this is from WF Server “ yourID@gmail.com
    If u gets this mail to your mail Id It then send mail is working fine
    H. Create DISCARD & PROCESS folders
    Login to the Application User (testappl)
    Under testappl user home it will be one mail folder. Under mail folder you create DISCARD & PROCESS folders




    2. Application level Configuration

    1. We can configure workflow notification mailer from Oracle Application Manager (OAM)


    2. There are two kinds of Notification Outbound & Inbound in Workflow Mailer

    3. For Outbound Notification, CM (Concurrent Manager) node should be able to connect to SMTP (Simple Mail Transfer Protocol) server/relay.

    4. For Inbound Notification (Optional), CM node should be able to connect to IMAP (Internet Message Access Protocol) Server.


    5. Workflow Notification Mailer in background run as Concurrent Manager (Workflow Mailer Service, Workflow Agent Listener Service)






    Enable Workflow Agent Listener and Notification Mailer concurrent



    programs




    Schedule the Workflow Background process, Notification Mailer concurrent requests

    Workflow Mailer Service, Workflow Agent Listener Service should be started

    Configure Workflow Notification Mailer
    Login to Oracle Application Manager
    Go to Site Map








    1. Click on Next



    2. Click on Next


    3. Here give Application User name, password and Test Mail Id
    Give PROCESS and DISCARD folders (which we have created in application server) name in EMail Processing




    4. Click on Next



    5. Give Submit Date and time then click on Next



    6. Click on Next


    7. Here give user name and click on Send Test Message

    Click on Next







    8. Click on finish



    B. STARTUP NOTIFICATION MAILER

    The mailer program can be started from command line or through a concurrent
    Program called "Notification Mailer". When the notification mailer is started as a concurrent request in Oracle Applications, the OS process is run by the Applications Manager (APPLMGR) user.

    To start it from the application, submit the "Notification Mailer" Concurrent request.

    To start it from command line on UNIX, execute the following command:

    Go to FND_TOP/bin/

    $WFMAIL apps/Pass 0 Y $FND_TOP/resource/wfmail.cfg



    Log file for Workflow Mailer Notification are at $APPLCSF/$APPLLOG/






    Happy Learning
    G.Venugopal Achari

    Labels:

    posted by Srinivasan .R @ 1:26 AM  
    3 Comments:
    Post a Comment
    << Home
     
    About Me

    Name: Srinivasan .R
    Home: Chennai, India

    About Me:
    I am working as an Oracle Applications DBA specializing in EBS 11i/R12 with Over 14+ years of experience, mainly in different versions of Oracle Database & Application administration on various platforms like HP-UX, SOLARIS, AIX, Red hat Linux & Windows
    See my complete profile
    High Availability
  • Oracle10g RAC Installation
  • A Quick Reference for Oracle Database 10g RAC on Linux and Unix Platforms
  • Implementing Oracle 10g RAC with ASM on AIX
  • Locked objects for whole RAC
  • Monitor Memory RAC
  • Sessions RAC
  • Install Oracle 11g RAC On Linux
  • Migrating Oracle10g DB to ASM
  • Helpful Links
  • Good Metalink Notes
  • Discoverer:Metalink Notes
  • Logs Scripts:Metalink Notes
  • Support:Metalink Notes
  • Previous Post
  • Data Dictionary Info
  • Redo Log Buffer
  • Contention/Locking
  • Full Table Scans
  • SENDMAIL configuration
  • Rollback Segments
  • User Information
  • Hit/Miss Ratios
  • Session Statistics
  • Tablespace Information
  • Archives
    Download Software
  • Oracle 11g
  • Oracle 10g
  • 10g Express Edition
  • Oracle 9i
  • Oracle Apps
  • Oracle Linux
  • Oracle VM
  • App Server
  • Solaris
  • Fedora
  • Fedora
  • OpenSUSE
  • Ubuntu
  • Advertisement Links
    INTUIT Technology

    MACHS DATA

    Add Ons
    Locations of visitors to this page

    Add to Google Reader or Homepage

    Template by
    Sreene



    Oracle Application DBA Portal