Workflow Diagnosting: checking SMTP server connection from server through command line.

-
Hi,

 Workflow Mailer in oracle EBS needs your special attention as an administrator, as on the same time it is a critically important and highly unstable ( with poor monitoring and configuration ). However it could be smooth with regular maintenance, and monitoring.
I decided to share some of experiences with WF notification one by one in my different posts; meanwhile you are always welcome to ask any query but after googling it.

In this post i will share how to check  your SMTP server, if its working fine by sending the email through command line from your linux server.



IMPORTANT: Please run these commands from the concurrent tier node as owner of concurrent manager.

telnet <...> 25
Replace the <....> with the SMTP server name
EHLO <.....>
Replace <.....> with the server where the Java Mailer(concurrent processing tier) runs.
MAIL FROM: <.....>
Replace the <.....> with value of reply-to parameter
RCPT TO: <.....>
Replace <.....> with email address where you want to send email - Soban.dba@gmail.com

DATA
here you enter subject, body, and finish with single dot on new line

QUIT

Check if email test is received

 

 If you are able recieve an email it means your SMTP server is all good, now you need to check your application configuration, I will post further diagnostics time to time.
keep in touch.

 Take care

Comments

Post a Comment

Popular posts from this blog

RMAN backup Status (Remaining Time and Percentage)

-
On Running a huge database backup we often need to know the status of backup. 1) How much backup is taken. 2) How much is remain. 3) Estimate time to complete the backup. After lot of search i find out this amazing query below. col dbsize_mbytes for 99,999,990.00 justify right head "DBSIZE_MB" col input_mbytes for 99,999,990.00 justify right head "READ_MB" col output_mbytes for 99,999,990.00 justify right head "WRITTEN_MB" col output_device_type for a10 justify left head "DEVICE" col complete for 990.00 justify right head "COMPLETE %" col compression for 990.00 justify right head "COMPRESS|% ORIG" col est_complete for a20 head "ESTIMATED COMPLETION" col recid for 9999999 head "ID" select recid , output_device_type , dbsize_mbytes , input_bytes/1024/1024 input_mbytes , output_bytes/1024/1...
Read more

EBS R12.2 Autoconfig Failed. Resolved

-
Hi, Please do the following and retest the issue: Due to the method required for "cleaning out" / "re-synchronizing" the following tables, it is EXPECTED / REQUIRED that the Applications have been shutdown. The only thing running should be the Database Tier. Note: A full backup should also be taken before any testing begins. Test the following steps in a development instance, and then migrate accordingly once the desired result is confirmed: 1. Backup the fnd_oam_context_files, fnd_nodes, and adop_valid_nodes tables in the EBS env: sqlplus applsys/pwd create table fnd_oam_context_files_bkp as select * from fnd_oam_context_files; create table fnd_nodes_bk as select * from fnd_nodes; create table adop_valid_nodes_bk as select * from adop_valid_nodes; 2. Truncate the following tables: truncate table fnd_oam_context_files; truncate table fnd_nodes; truncate table adop_valid_nodes; 3. Run AutoConfig on the DB tier ...
Read more

Cleaning nodes in EBS databae.

-
Cleaning EBS nodes with EXEC FND_CONC_CLONE.SETUP_CLEAN; . EBSapps.env run   $ sqlplus apps/<PASSWORD> SQL> create table fnd_nodes_22ep14 as select * from fnd_nodes; SQL> exec fnd_conc_clone.setup_clean; PL/SQL procedure successfully completed. SQL> commit; Commit complete. After that run autoconfig in below order to populate the FND TABLES properly. 1) Stop application services ( optional but  recommended )  2) Run autoconfig on dbTier 3) Run autoconfig on appTier
Read more