ORA-01919: Role 'AGILE_ROLE' Does Not Exist In Agile932 (Doc ID 1574662.1)

Last updated on JULY 26, 2015

Applies to:

Oracle Agile PLM Framework - Version 9.3.2.0 and later
Information in this document applies to any platform.
***Checked for relevance on 27-Jul-2015***

Goal

Agile932 upgrade:

while creating agile user in Agile931 through useragile.sql scripts, its granting Agile_Role to user.

But in Agile932, its not having any role like Agile_role. I have created user in Agile932 schema using useragile932.sql script and started importing of Agile931 schema into Agile932. But while importing its throwing the below error.

====================================================================
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'AGILE_ROLE' does not exist
Failing sql is:
GRANT "AGILE_ROLE" TO "AGILE932DEV01"
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
ORA-39083: Object type DEFAULT_ROLE failed to create with error:
ORA-01919: role 'AGILE_ROLE' does not exist
Failing sql is:
ALTER USER "AGILE932DEV01" DEFAULT ROLE "DBA", "AGILE_ROLE"
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM

==========================================================================

Solution

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