000037776 - ORA-39070: "Unable to open the log file" error or ORA-06512: at "SYS.DBMS_SYS_ERROR" and "SYS.DBMS_DATAPUMP" errors when backing up (exporting) an RSA Identity Governance & Lifecycle database

Document created by RSA Customer Support Employee on Jul 28, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037776
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.x
IssueWhen attempting to backup (export) an RSA Identity Governance & Lifecycle database using the RSA-supplied backup script home/oracle/database/DBA/AVDB/scripts/AVDB_Export_AVUSER.sh, the export fails with one of the following errors depending on the RSA Identity Governance & Lifecycle version:

7.1.1

ORA-39002: invalid operation
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4087
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4338
ORA-06512: at line 1


7.1.0 does not fail in this scenario.

7.0.x


ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name AVEKSA_EXPORTIMPORT_DIRECTORY is invalid


6.x


ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation

 

 
CauseThe user (AVUSER) running the database utilities (import or export) is missing READ,WRITE permission on the database directory.

 
Resolution
  1. Check that the database directory is defined in the database.

  1. Execute the following SQL as SYSDBA:


select * from dba_directories where directory_name like 'AVEKSA%';


  1. This should return the following:


DIRECTORY_NAME DIRECTORY_PATH
------------------------------------------------------------
AVEKSA_EXPORTIMPORT_DIRECTORY /home/oracle/AveksaExportImportDir


  1. If the path is missing or incorrect, use the following SQL to correct the directory path:


create or replace directory AVEKSA_EXPORTIMPORT_DIRECTORY as '/home/oracle/AveksaExportImportDir';


  1. The path specified above must also be the same in the /home/oracle/Aveksa_System.cfg file and the /home/oracle/setDeployEnv.sh script. If not, make them the same.
 

  1. Check the read/write privileges on the directory path:

  1. Execute the following SQL as SYSDBA:


select * from all_tab_privs where table_name like 'AVEKSA%';


  1. This should return the following:

User-added image


  1. If this query returns no rows, then grant the needed access to AVUSER by executing the following SQL as SYSDBA:


grant read, write on directory AVEKSA_EXPORTIMPORT_DIRECTORY to AVUSER;




NOTE: In 6.x two additional directories exist that require read/write privileges be granted to AVUSER. These directories and paths are as follows:
 

AVEKSA_REPORTS_DIRECTORY /home/oracle/AveksaReportsDir
AVEKSA_DATA_DIRECTORY /home/oracle/AveksaDataDir






 

Attachments

    Outcomes