R12.2 Apps DBA. Powered by Blogger.

Ora-24247: Network Access Denied By Access Control List (Acl) Using localhost as SMTP Server Name (Doc ID 1348855.1)

No comments :
Solution:
Don't use "localhost" as the name of the SMPT server name, use the physical name or IP address instead.
Solution:
This is a known issue which also occurred in Dev environment, We have followed these steps to fix it. Hence please co-ordinate with DBA team to fix the ACL error followed by SMTP configuration in EBS
Set the smtp_out_server parameter value to smtpvip.apdbablog.com at the database level
     Run the following pl/sql block from db server (as sysdba) to clear ACL related errors
BEGIN
dbms_network_acl_admin.assign_acl (
acl => '/sys/acls/OracleEBS.xml',
host => 'smtpvip.apdbablog.com',
lower_port => 25,
upper_port => 25
);
END;
/
    Set the Notification Mailer values as following.
a.Applications System:apdbadev  -->   Service Components -->   Edit 
b.Outbound EMail Account (SMTP) = smtpvip.apdbaidec.com
c.Inbound EMail Account (IMAP) = imap.apdbaidec.com
d.Username Username for the Inbound Server = svc-applpdhd
e.Reply-To Address  = apdbadev@apdba.com
f.Checked "Inbound SSL Enabled"
Asked the User to run the conc prog and check the email in APDBA Email box (smb-outlook-erp@apdba.com)
=========================
Run Below command on Database Tier.
exec dbms_network_acl_admin.create_acl(acl=>'OracleEBS.xml',description=>'OracleEBS.xml',
principal=>'APPS',privilege=>'connect',is_grant=>true,start_date=>null,end_date=>null);
exec DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl=>'OracleEBS.xml',principal=>
'APPS',is_grant=>true,privilege=>'connect',position=>1,start_date=>null,end_date=>null);
exec DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl=>'OracleEBS.xml',principal=>
'APPS',is_grant=>true,privilege=>'resolve',position=>2,start_date=>null,end_date=>null);
exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'OracleEBS.xml',host=>
'ebsint2',lower_port=>80,upper_port=>80);
exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'OracleEBS.xml',host=>
'ebsx01appd10',lower_port=>8080,upper_port=>8080);
exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'OracleEBS.xml',host=>
'ebsx01appd11',lower_port=>8080,upper_port=>8080);
exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'OracleEBS.xml',host=>
'ebsx01appd12',lower_port=>8080,upper_port=>8080);
exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'OracleEBS.xml',host=>
'ebsx01appd13',lower_port=>8080,upper_port=>8080);
exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'OracleEBS.xml',host=>
'ebsx01appd14',lower_port=>8080,upper_port=>8080);
exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'OracleEBS.xml',host=>
'ebsx01appd15',lower_port=>8080,upper_port=>8080);
exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'OracleEBS.xml',host=>
'dev2osbadminvhn.apdbablog.com',lower_port=>80,upper_port=>8040);
exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'OracleEBS.xml',host=>
'dev3eip.apdbablog.com',lower_port=>80,upper_port=>80);
exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'OracleEBS.xml',host=>
'dev4eip.apdbablog.com',lower_port=>80,upper_port=>80);
exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'OracleEBS.xml',host=>
'dev4soaeip.apdbablog.com',lower_port=>80,upper_port=>80);
exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'OracleEBS.xml',host=>
'smtpvip.apdbablog.com',lower_port=>25,upper_port=>25);
exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'OracleEBS.xml',host=>
'dev2eip.apdbablog.com',lower_port=>25,upper_port=>25);
exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'OracleEBS.xml',host=>
'dev2osbadminvhn',lower_port=>80,upper_port=>80);
exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'OracleEBS.xml',host=>
'*',lower_port=>null,upper_port=>null);

No comments :

Post a Comment

Note: only a member of this blog may post a comment.