A "directory '/home/oracle/AveksaExportImportDir' must be a valid directory" error occurs when restoring (importing) a database into RSA Identity Governance & Lifecycle
Originally Published: 2019-07-28
Last Modified: 2023-11-30
Article Number
000041000
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%';
  1.  This returns the following:  
DIRECTORY_NAME DIRECTORY_PATH
------------------------------------------------------------
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









 

Related Articles

Trending Articles

Don't see what you're looking for?