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

[#1]

Article Number

000037777

Applies To

RSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.x

Issue

When 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.

 

Cause

This 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.

 

Resolution

Create the physical directory if it does not exist:

1. Execute the following SQL as SYSDBA:

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

2.  This returns the following:  

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

3. 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