My Oracle Support Banner

19c: datapatch fails with Error ORA-01924: role 'DATAPUMP_EXP_FULL_DATABASE'/'DATAPUMP_EXP_FULL_DATABASE' not granted or does not exist (Doc ID 2868424.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.15.0.0.0 and later
Information in this document applies to any platform.

Symptoms

 datapatch fails with error:

Patch 33806152 apply: WITH ERRORS
logfile: $ORACLE_BASE/cfgtoollogs/sqlpatch/33806152/24713297/33806152_apply_SID_2022May03_34_10_06.log (errors)
-> Error at line 147983: script rdbms/admin/prvtgwm.sql
- ORA-01924: role 'DATAPUMP_IMP_FULL_DATABASE' not granted or does not exist
-> Error at line 147990: script rdbms/admin/prvtgwm.sql
- ORA-01924: role 'DATAPUMP_EXP_FULL_DATABASE' not granted or does not exist

 

33806152_apply_SID_2022May03_34_10_06.log shows:

 

SQL> @@&sql_script
SQL> Rem
SQL> Rem $Header: rdbms/admin/prvtgwm.sql /st_rdbms_19/1 2021/04/27 10:42:07 apfwkr Exp $
SQL> Rem
SQL> Rem prvtgwm.sql

......

SQL> GRANT datapump_imp_full_database TO package gsmadmin_internal.exchange;
GRANT datapump_imp_full_database TO package gsmadmin_internal.exchange
*
ERROR at line 1:
ORA-01924: role 'DATAPUMP_IMP_FULL_DATABASE' not granted or does not exist

SQL> GRANT datapump_exp_full_database TO package gsmadmin_internal.exchange;
GRANT datapump_exp_full_database TO package gsmadmin_internal.exchange
*
ERROR at line 1:
ORA-01924: role 'DATAPUMP_EXP_FULL_DATABASE' not granted or does not exist

 

 

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.