Ora-01919 Errors when upgrading ASP.Net Database Objects To 11gr2 (Doc ID 1240174.1)

Last updated on NOVEMBER 11, 2010

Applies to:

Oracle Providers for ASP.NET - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

1. Run InstallAllOracleASPNETProviders.sql to upgrade existing ASP.NET provider support schema from 11gR1 (11.1.0.6) to 11GR2 (11.2.0.1.2).

2. Execution of the SQL Script returned multiple ORA-01919 role does not exist errors:

GRANT ora_aspnet_Mem_BasicAccess TO ora_aspnet_Mem_FullAccess;
GRANT ora_aspnet_Mem_BasicAccess TO ora_aspnet_Mem_FullAccess
*
ERROR at line 1:
ORA-01919: role 'ORA_ASPNET_MEM_BASICACCESS' does not exist

GRANT ora_aspnet_Mem_ReportAccess TO ora_aspnet_Mem_FullAccess;
GRANT ora_aspnet_Mem_ReportAccess TO ora_aspnet_Mem_FullAccess
*
ERROR at line 1:
ORA-01919: role 'ORA_ASPNET_MEM_REPORTACCESS' does not exist

GRANT ora_aspnet_Pers_BasicAccess TO ora_aspnet_Pers_FullAccess
*
ERROR at line 1:
ORA-01919: role 'ORA_ASPNET_PERS_BASICACCESS' does not exist

GRANT ora_aspnet_Pers_ReportAccess TO ora_aspnet_Pers_FullAccess;
GRANT ora_aspnet_Pers_ReportAccess TO ora_aspnet_Pers_FullAccess
*
ERROR at line 1:
ORA-01919: role 'ORA_ASPNET_PERS_REPORTACCESS' does not exist

GRANT ora_aspnet_Prof_ReportAccess TO ora_aspnet_Prof_FullAccess;
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 ora_aspnet_Roles_BasicAccess TO ora_aspnet_Roles_ReportAccess;
GRANT ora_aspnet_Roles_BasicAccess TO ora_aspnet_Roles_ReportAccess
*
ERROR at line 1:
ORA-01919: role 'ORA_ASPNET_ROLES_BASICACCESS' does not exist

GRANT ora_aspnet_Roles_ReportAccess TO ora_aspnet_Roles_FullAccess;
GRANT ora_aspnet_Roles_ReportAccess TO ora_aspnet_Roles_FullAccess
*
ERROR at line 1:
ORA-01919: role 'ORA_ASPNET_ROLES_REPORTACCESS' does not exist





Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms