7 Replies Latest reply: May 15, 2013 12:49 PM by Alex.Keh .Product.Manager-Oracle RSS

    error while running InstallOracleProfile script

    Prakash T Soundappan
      good evening every one,
      i have installed odac for VS 2010,while running the InstallOracleProfile script the following error occurs can any one help me in solving this problem.im using windows os. the error as follows


      Connected.
      ------ Running 'C:\Users\johny.OOMSYSTECH.000\Desktop\prakash\odac_path\product\11.2.0\client_1\ASP.NET\SQL\InstallOracleProfile.sql' @PRAKASH.orcl ------

      USER
      ------------------------------
      PRAKASH

      old 33: execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Prof_GetProperties FOR &CurrentUser..ora_aspnet_Prof_GetProperties';
      new 33: execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Prof_GetProperties FOR PRAKASH.ora_aspnet_Prof_GetProperties';
      old 34: execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Prof_SetProperties FOR &CurrentUser..ora_aspnet_Prof_SetProperties';
      new 34: execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Prof_SetProperties FOR PRAKASH.ora_aspnet_Prof_SetProperties';
      old 35: execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Prof_GetNOfInactPf FOR &CurrentUser..ora_aspnet_Prof_GetNOfInactPf';
      new 35: execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Prof_GetNOfInactPf FOR PRAKASH.ora_aspnet_Prof_GetNOfInactPf';
      old 36: execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Prof_GetProfiles FOR &CurrentUser..ora_aspnet_Prof_GetProfiles';
      new 36: execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Prof_GetProfiles FOR PRAKASH.ora_aspnet_Prof_GetProfiles';
      old 37: execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Prof_DeleteProfiles FOR &CurrentUser..ora_aspnet_Prof_DeleteProfiles';
      new 37: execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Prof_DeleteProfiles FOR PRAKASH.ora_aspnet_Prof_DeleteProfiles';
      old 38: execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Prof_DeleteInactPf FOR &CurrentUser..ora_aspnet_Prof_DeleteInactPf';
      new 38: execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Prof_DeleteInactPf FOR PRAKASH.ora_aspnet_Prof_DeleteInactPf';
      old 39: execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Prof_pkg FOR &CurrentUser..ora_aspnet_Prof_pkg';
      new 39: execute immediate 'CREATE PUBLIC SYNONYM ora_aspnet_Prof_pkg FOR PRAKASH.ora_aspnet_Prof_pkg';

      PL/SQL procedure successfully completed.


      Package created.


      Package body created.


      Function created.


      Function created.


      Function created.


      Function created.


      Function created.


      Function created.


      Grant succeeded.


      Grant succeeded.


      Grant succeeded.

      GRANT ora_aspnet_Prof_BasicAccess TO ora_aspnet_Prof_FullAccess
      *
      ERROR at line 1:
      ORA-01919: role 'ORA_ASPNET_PROF_BASICACCESS' does not exist


      GRANT ora_aspnet_Prof_ReportAccess TO ora_aspnet_Prof_FullAccess
      *
      ERROR at line 1:
      ORA-01919: role 'ORA_ASPNET_PROF_REPORTACCESS' does not exist



      Grant succeeded.


      Grant succeeded.


      Grant succeeded.


      Grant succeeded.


      Grant succeeded.


      Grant succeeded.


      ---------------------- Done ----------------------




      thank you
      prakash