5 Replies Latest reply on Nov 15, 2016 4:51 PM by M.Emmanuel

    Activate ORDS in Oracle 11g r2 -APEX 5-

    M.Emmanuel

      I am following https://docs.oracle.com/cd/E59726_01/install.50/e39144/listener.htm#HTMIG29160

      4.8 Enabling Network Services in Oracle Database 11g or Later

       

      while trying to install ORDS in Oracle 11g r2 (apex 5)

       

      But I get the following errors:

       

      $cat network_enable.sql

       

      DECLARE

        ACL_PATH  VARCHAR2(4000);

      BEGIN

        -- Look for the ACL currently assigned to '*' and give APEX_050000

        -- the "connect" privilege if APEX_050000 does not have the privilege yet.

       

        SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS

         WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;

       

        IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_050000',

           'connect') IS NULL THEN

            DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,

           'APEX_050000', TRUE, 'connect');

        END IF;

       

      EXCEPTION

        -- When no ACL has been assigned to '*'.

        WHEN NO_DATA_FOUND THEN

        DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml',

          'ACL that lets power users to connect to everywhere',

          'APEX_050000', TRUE, 'connect');

        DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');

      END;

      /

      COMMIT;

       

       

       

      SQL> @network_enable.sql

      DECLARE

      *

      ERROR at line 1:

      ORA-00904: : invalid identifier

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

      ORA-06512: at line 19

      ORA-01403: no data found

       

       

       

      Commit complete.

       

      any help is welcomed.