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

    2679576

      Hi,

       

      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 11.1.0.7.0 - Production on Thu Jul 14 09:30:57 2016

       

       

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

       

       

      Connected.

      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 ...

      DECLARE

      *

      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?