Oracle 11g Grant Access before DLP 15.0/15.0 MP1 upgrade

Only applies to customers on Oracle 11g.

It has been identified that the DLP 15.0 and 15.0 MP1 upgrades fail if the below permissions are not granted to the Oracle DB protect user. Prior to the upgrade, please perform the steps below.

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

 

1. SSH to enforce as appuser

 

2. Switch to the oracle user

sudo su - oracle

 

3. connect to the Oracle database as protect

sqlplus sys/protect as sysdba

 

4. Execute each command below:

GRANT READ,WRITE ON directory DATA_PUMP_DIR TO protect;

GRANT SELECT ON dba_registry_history TO protect;

GRANT SELECT ON dba_temp_free_space TO protect;

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.