SMTP server - POiSON WORLD

Posts Tagged ‘SMTP server’

PLS-00201: identifier UTL MAIL.SEND must be declared

January 9th, 2022, posted in Oracle Queries

PLS-00201: identifier ‘UTL_MAIL.SEND’ must be declared

During execution of the package use UTL Mail package for send the mail may give the error PLS-00201. It may be caused due to in configured of UTL Mail package in the database. You may configure the UTL Mail package with following script:

Error:
ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier 'UTL_MAIL.SEND' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Solution:

1. Set the Oracle Home Environment Variable
Set ORACLE_HOME=D:\Oracle\12.1.0\dbhome_1 set PATH=%ORACLE_HOME%\bin;%PATH%
2. Connect with sqlplus / as sysdba
@?\rdbms\admin\utlmail.sql; @?\rdbms\admin\prvtmail.plb;
3. Set up the Parameter SMTP server.
ALTER SYSTEM SET smtp_out_server='address:25' SCOPE=BOTH;
4. Grant the user with required permission.
GRANT execute ON utl_mail TO NEWUSER;

read more no comments

Workflow Notification Mailer Setup in Oracle Apps R12/12i

May 16th, 2021, posted in Oracle EBS Application

On popular demand from readers, I am going to cover Workflow Notification Mailer in Oracle Applications R12/12i.
Workflow notification mailer setup in R12 is similar to 11i ( In both release 11i (OWF.H and higher in 11i) & R12 are Java Mailer)
* Previous version of Notification Mailer in 11i was based on C also called as C Mailer

Things To Note :
1. You use Oracle Application Manager (OAM) to configure Workflow Notification Mailer.
2. There are two kind 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. Log file for Workflow Mailer Notification are at $APPLCSF/$APPLLOG/FNDC*.txt
6. Workflow Notification Mailer in background run as Concurrent Manager (Workflow Mailer Service, Workflow Agent Listener Service)
7. If you don’t wish to send mail notification to end user (from Dev/Test instance) then configure Test Address in configuration screen.

Step to configure Workflow Notification Mailer :
1. Login to Apps R12 with System Administrator Reponsibility
2. under Workflow : Oracle Applications Manager click on Workflow Manager

oracle apps,Oracle dba,Oracle application,oracle mail setup.oracle apps dba,

If this is first time you are configuring Workflow Notification Mailer in Oracle Apps R12/12i you will see Notification Mailers as unavailable as shown in screenshot

Click on Notification Mailers

oracle apps,Oracle dba,Oracle application,oracle mail setup.oracle apps dba,

In next screen (as shown below, click on Edit Button)

oracle apps,Oracle dba,Oracle application,oracle mail setup.oracle apps dba,

Here you have option to select Inbound notification setup or Just outgoing Notification Setup.

oracle apps,Oracle dba,Oracle application,oracle mail setup.oracle apps dba,

Provide SMTP Server Name (ensure that CM node should be able to connect to SMTP Server or SMTP Relay)

oracle apps,Oracle dba,Oracle application,oracle mail setup.oracle apps dba,

Uncheck Inbound Processing (from above screen), if you don’t wish to configure Inbound Notification Mailer.

If you wish to configure Inbound Notification as well then ensure IMAP Server should be configured with a valid user (create Inbox, Processed & Discard folder for this User)

Click on Apply button to finish configuration, at this stage Notification Mailer will test SMTP Server & IMAP Server connectivity.

For Advanced setup, click on Advanced at top right of configuration screen.

Metalink Notes for Notification Mailer
1. 453137.1 Oracle Workflow Best Practices Release 12 and Release 11i
2. 274764.1 Oracle Workflow Cartridge Workflow Java Mailer Setup Test
3. 433359.1 Tracking Workflow Notification Event Messages
4. 456921.1 Queries Related to Alert and Mailer Integration Post RUP4
5. 454706.1 How to Stop mails from Workflow Notification Mailer

read more no comments

What is an SMTP port

November 22nd, 2013, posted in PHP

What port should you chose for your SMTP server when you’re setting it on a mail client?

Simply put, computer ports are the communication endpoints of a computer connected to a network. They are separated to differentiate the several processes and make it easier to handle them: so each one has a particular purpose and is associated to a specific protocol.

Usually an outgoing server employs port 25: it’s the default SMTP port. However, some IPs deny its use because of the massive spam and malware traffic by which is affected. This issue is raised in particular when you need to switch to another ISP – for instance, when you’re travelling and connecting to a new provider. In this case you can try to use port 587 or port 465 to avoid the block.

More in detail: port 587 is supported by almost every outgoing SMTP server and it’s useful for unencrypted or TLS connections; while port 465 is the right choice if you need to connect via SSL.

turboSMTP can work both on port 587 and 465, but also on 2525 and 25025. Moreover, it completely avoids the “another ISP” issue: in fact, once you have set our SMTP as default you don’t need to configure it again or switch to other ports.

read more no comments