1 Reply Latest reply: Apr 28, 2010 2:21 PM by 769761 RSS

    ILM Assistant (1.4) Post Installation Issues (executing @grant_privs)

    769761
      Dear all,

      I am trying to install ILM 1.4 on 11g R2 (APEX 3.2 installed).
      I have installed APEX 3.2 on DB 11g R2 successfully, when I am executing ILM post installation tasks in which we create DB user
      and execute *@grant_privs ilm_user_test;* script it gives me error user does not exists
      please find below log. I tried the grant_privs11 pl/sql block separately its gives error at lines 74 & 75. Please suggest/advise.

      Note: Installad Env. as follows:
      Oracle DB 11g Rel. 2 (installed successfully)
      Apex 3.2 (installed successfully)
      ILM Assistant 4.1 (Post Installation task - under progress)

      username: ilm_user_test
      deafult tablespace: users

      ILM Post Installation task (Log):

      SQL> @grant_privs ilm_user_test;
      Session altered.
      Session altered.

      old 1: GRANT MANAGE TABLESPACE TO &ilm_user
      new 1: GRANT MANAGE TABLESPACE TO ilm_user_test

      Grant succeeded.

      old 1: GRANT ALTER TABLESPACE TO &ilm_user
      new 1: GRANT ALTER TABLESPACE TO ilm_user_test

      Grant succeeded.

      old 1: GRANT ALTER ANY TABLE TO &ilm_user
      new 1: GRANT ALTER ANY TABLE TO ilm_user_test

      Grant succeeded.

      old 1: GRANT DROP ANY TABLE TO &ilm_user
      new 1: GRANT DROP ANY TABLE TO ilm_user_test

      Grant succeeded.


      PL/SQL procedure successfully completed.



      old 1: GRANT ADVISOR TO &ilm_user
      new 1: GRANT ADVISOR TO ilm_user_test
      Grant succeeded.

      old 1: GRANT ALTER ANY TABLE TO &ilm_user
      new 1: GRANT ALTER ANY TABLE TO ilm_user_test
      Grant succeeded.

      old 1: GRANT DROP ANY TABLE TO &ilm_user
      new 1: GRANT DROP ANY TABLE TO ilm_user_test
      Grant succeeded.

      old 1: GRANT MANAGE TABLESPACE TO &ilm_user
      new 1: GRANT MANAGE TABLESPACE TO ilm_user_test
      Grant succeeded.

      old 1: GRANT ALTER TABLESPACE TO &ilm_user
      new 1: GRANT ALTER TABLESPACE TO ilm_user_test
      Grant succeeded.

      old 1: GRANT EXECUTE ON ILM_TOOLKIT.ILM_TOOLKIT TO &ilm_user
      new 1: GRANT EXECUTE ON ILM_TOOLKIT.ILM_TOOLKIT TO ilm_user_test
      Grant succeeded.


      Creating the ILM$$USER package for Immutability features...

      old 2: l_username varchar2(30) := '&ilm_user';
      new 2: l_username varchar2(30) := 'ilm_user_test';
      declare
      *
      ERROR at line 1:
      ORA-01435: user does not exist
      ORA-06512: at line 51

      regards,
      Ali