000037777 - A "directory '/home/oracle/AveksaExportImportDir' must be a valid directory" error occurs when restoring (importing) a database into RSA Identity Governance & Lifecycle

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

Article Content

Article Number000037777
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.x
IssueWhen attempting to restore (import) an RSA Identity Governance & Lifecycle database using the RSA-supplied backup script home/oracle/database/DBA/AVDB/scripts/AVDB_Import_AVUSER.sh, the import fails with the following error:

The directory '/home/oracle/AveksaExportImportDir' must be a valid directory.

CauseThis error occurs when /home/oracle/AveksaExportImportDir does not physically exist on the disk. When a directory is created in the Oracle database, Oracle does not check for the existence of the physical directory on the file system. The checking for its existence is done at run-time and inn most cases the directory itself is created during installation.

ResolutionCreate the physical directory if it does not exist:
  1. Execute the following SQL as SYSDBA:

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

  1.  This returns the following:  

AVEKSA_EXPORTIMPORT_DIRECTORY /home/oracle/AveksaExportImportDir

  1. Note the DIRECTORY_PATH. If the directory is missing from the file system, create it by executing the following operating system commands as user 'oracle':

$ cd /home/oracle
$ mkdir AveksaExportImportDir