2 Replies Latest reply: Feb 15, 2013 5:54 AM by Rob_J RSS

    Error ORA-24247 after migrating from 10g to 11g

    Fabricio_Jorge
      Hi all,

      After a migration from a 10.2.0.3 (32bits) database to a 11.2.0.3 (64bits) database, we are facing a problem related to the UTL_SMTP package. I vale already created a ACL, as you can see below:
      -- create acl
      BEGIN
          DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (acl => 'user_processos.xml',
                                                                           description => 'abc',
                                                                       principal => 'PROCES',
                                                                       is_grant => TRUE, 
                                                                       privilege => 'connect');
      END;  
      
      -- assign acl
      BEGIN
          DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (acl => 'user_processos.xml'
                                                                      host => 'rac-abc',
                                                                   lower_port => 1521,
                                                                   upper_port => NULL);
                END;
      The problem is: After we try to execute a procedure that calls UTL_SMTP, with user PROCES the error ORA-24247 is raised. I did some research and they all point to the it is necessary to create an ACL to solve this probles, but the ACL already exists, as you can see above.
        • 1. Re: Error ORA-24247 after migrating from 10g to 11g
          ursusca
          It's a permission issue. Try this:

          ORA-24247 Using UTL_TCP, UTL_HTTP, UTL_SMTP And UTL_MAIL With 11gR1 Or Later [ID 1209644.1]
          • 2. Re: Error ORA-24247 after migrating from 10g to 11g
            Rob_J
            Hi,

            I had the same issue, well multiple issues, with this at first. You should find the solution in one of these links. Make sure you have done each step in the lists and it will work.

            [url http://www.ora00600.com/scripts/databaseconfig/ORA-29278.html]ORA-29278 SMTP
            [url http://www.ora00600.com/scripts/11g/UTL_SMTP_ORA-06512.html]ORA-06512: at SYS.UTL_SMTP

            There are various parameters and configuration steps you need to make sure you have performed for it to work.

            Hopefully that helps,
            Rob

            Edited by: Rob_J on Feb 15, 2013 11:53 AM
            *link was not working