0 Replies Latest reply on Jul 14, 2016 8:08 AM by 2679576

    ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 513 where launching autoconfig in database




      I am working on oracle EBS R12.1.3, i had a problem target node queue unavailable concurrent manager, when trying to resolve it, i had laucn autoconfig on database tier but it finished with error: when i checked the log file, i found

      The environment settings are as follows ...



             ORACLE_HOME : /data/dbtest/TEST/db/tech_st/11.1.0

              ORACLE_SID : TEST

                    PATH : /data/dbtest/TEST/db/tech_st/11.1.0/perl/bin:/data/dbtest/TEST/db/tech_st/11.1.0/bin:/usr/ccs/bin:/usr/sbin:/data/dbtest/TEST/db/tech_st/11.1.0/appsutil/jre/bin:/usr/bin:/etc:/usr/lbin:/usr/bin/X11:/usr/local/bin:/data/dbtest/TEST/db/tech_st/11.1.0/perl/bin:/data/dbtest/TEST/db/tech_st/11.1.0/perl/bin:/data/dbtest/TEST/db/tech_st/11.1.0/bin:/usr/ccs/bin:/usr/sbin:/data/dbtest/TEST/db/tech_st/11.1.0/appsutil/jre/bin:/usr/bin:/etc:/usr/lbin:/usr/bin/X11:/usr/local/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/data/dbtest/bin:/usr/bin/X11:/sbin:.:.:.

      Executable : /data/dbtest/TEST/db/tech_st/11.1.0/bin/sqlplus





      Executing txkcreateACL.sql ...





      SQL*Plus: Release - Production on Thu Jul 14 09:30:57 2016



      Copyright (c) 1982, 2008, Oracle.  All rights reserved.




      Checking for existence of the ACL ....

      No ACL exists for this, creating a new one ....

      For this new ACL, adding the privilege ...

      Assigning hosts to the new ACL ...



      ERROR at line 1:

      ORA-01403: no data found

      ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 513

      ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 446

      ORA-06512: at line 54

      ORA-01403: no data found


      Please how can i correct it?