tag:blogger.com,1999:blog-5477482922257499491.post8072489432317985133..comments2023-07-13T00:33:27.264-07:00Comments on Oracle DBA tips from Madhu Nair: ORA-24247 when trying To send email using UTL_SMTP in Oracle 11gR2Madhu Nairhttp://www.blogger.com/profile/13553304910994763869noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5477482922257499491.post-92148092222327136132011-03-24T13:01:23.819-07:002011-03-24T13:01:23.819-07:00You need XDB to be installed for ACL to work. So i...You need XDB to be installed for ACL to work. So if you get following error, verify XDB is installed.<br /><br />Duplicate Filename Found for Submission_id: 6011<br />Standard exception<br />VALIDATE Submission: 6011 Step: Duplicate Submission Ch<br />Exception CODE: 1<br />Exception ERRM: User-Defined Exception<br />Stop Time: 21-MAR-2011 08:15:04 AM<br />DECLARE<br />*<br />ERROR at line 1:<br />ORA-24248: XML DB extensible security not installed<br />ORA-06512: at "SYS.UTL_TCP", line 17<br />ORA-06512: at "SYS.UTL_TCP", line 246<br />ORA-06512: at "SYS.UTL_SMTP", line 127<br />ORA-06512: at "SYS.UTL_SMTP", line 150<br />ORA-06512: at "FFLADM.EMAIL_HANDLER", line 36<br />ORA-06512: at "FFLADM.REBATE_PROCESS", line 515<br />ORA-06510: PL/SQL: unhandled user-defined exception<br />ORA-06512: at line 5<br /><br /><br />you can use following script to install XDB<br /><br />SET VERIFY OFF<br />connect "SYS"/"&&sysPassword" as SYSDBA<br />set echo on<br />spool /orasw/app/oracle/admin/scripts/xdb_protocol.log append<br />@/orasw/app/oracle/product/11.2.0/db/rdbms/admin/catqm.sql change_on_install SYSAUX TEMP YES;<br />connect "SYS"/"&&sysPassword" as SYSDBA<br />@/orasw/app/oracle/product/11.2.0/db/rdbms/admin/catxdbj.sql;<br />@/orasw/app/oracle/product/11.2.0/db/rdbms/admin/catrul.sql;<br />spool offMadhu Nairhttps://www.blogger.com/profile/13553304910994763869noreply@blogger.comtag:blogger.com,1999:blog-5477482922257499491.post-58749285273170947262011-02-04T14:49:32.077-08:002011-02-04T14:49:32.077-08:00We need to set ACL for UTL_INADDR package also in ...We need to set ACL for UTL_INADDR package also in Oracle 11g. We could check this by issuing <br />SELECT utl_inaddr.get_host_name FROM dual;<br /><br />If you get ORA-24247, create a acl with privilege=resource.<br /><br />Here is the sql I used.<br />-- rem Create ACL for using UTL_INADDR<br />begin<br /> dbms_network_acl_admin.create_acl (<br /> acl => 'resolve_ipaddr_acl.xml',<br /> description => 'ACL for user to resolv Network names and ip address',<br /> principal => 'ETRADM',<br /> is_grant => TRUE,<br /> privilege => 'resolve');<br /> end;<br />/<br />commit;<br /><br />-- rem Assign ACL to one or more network hosts<br />begin<br /> dbms_network_acl_admin.assign_acl (<br /> acl => 'resolve_ipaddr_acl.xml',<br /> host => '*');<br />end;<br />/<br />commit;Madhu Nairhttps://www.blogger.com/profile/13553304910994763869noreply@blogger.com