RDS oracle EFS integration not working

Question

I am following below to use EFS_INTEGRATION with rds oracle.

https://aws.amazon.com/blogs/database/integrate-amazon-rds-for-oracle-with-amazon-efs/

Though all the network connetivity is fine , I am still getting below error when I am running below command .

Command -
select * from table(rdsadmin.rds_file_util.listdir(p_directory => 'DATA_PUMP_DIR_EFS')); select * from table(rdsadmin.rds_file_util.listdir(p_directory => 'DATA_PUMP_DIR_EFS'))

Error -

ERROR at line 1: ORA-20199: Error in rdsadmin.rds_file_util. ORA-06512: at "RDSADMIN.RDS_FILE_UTIL", line 30 ORA-27369: job of type EXECUTABLE failed with exit code: 1 /usr/bin/find: '/rdsefs-fs-0994ac35038c583b3/efs/': No such file or directory ORA-06512: at "SYS.RDS_SYS_UTIL", line 2133 ORA-06512: at "SYS.DBMS_ISCHED", line 242

I have used below command to mount EFS to EC2

sudo mount -t nfs4 -o nfsvers=4.1,rsize=1048576,wsize=1048576,hard,timeo=600,retrans=2,noresvport :/ /efsdir

I have used below command to create directory in RDS oracle

BEGIN
rdsadmin.rdsadmin_util.create_directory_efs(
p_directory_name => 'DATA_PUMP_DIR_EFS',
p_path_on_efs => '/rdsefs-/efsdir');
END;
/

What could be the reasons why we are encountering this error?

rePost-User-0920076 · Accepted Answer

As the error message states mountpoint as /efs and not /efsdir , Please review if you are using correct mount command.

Please also note , While creating directory give path only as '/rdsefs-/' , and not as '/rdsefs-/efsdir'.
```
BEGIN
rdsadmin.rdsadmin_util.create_directory_efs
( p_directory_name => 'DATA_PUMP_DIR_EFS',
p_path_on_efs => '/rdsefs-/');
END;
/
```
As mountpoint is represented by '/rdsefs-/' only.
If you create further directories inside /efsdir mountpoint , then the path has to be specified.

Leo K · Answer

Just looking at the error message, it shows the mount path as:

``` /rdsefs-/efs/ ```

but you said that the path you created was:

``` /rdsefs-/efsdir ```

Perhaps check first if those match in your actual configuration?

RDS oracle EFS integration not working

Add your answer

Relevant content