unable to access or list DATA_PUMP_DIR in RDS (Oracle-SE2)

Question

unable to access or list DATA_PUMP_DIR in RDS (Oracle-SE2):
DATA_PUMP_DIR is default oracle DIR and generally we use this to copy /move dumps of the DB, while list DATA_PUMP_DIR today I got this error which is completely new for me:

SQL> select * from table(RDSADMIN.RDS_FILE_UTIL.LISTDIR('DATA_PUMP_DIR')) order by mtime;
select * from table(RDSADMIN.RDS_FILE_UTIL.LISTDIR('DATA_PUMP_DIR')) order by mtime

ORA-20199: Error in rdsadmin.rds_file_util.
ORA-06512: at "RDSADMIN.RDS_FILE_UTIL", line 47
ORA-27369: job of type EXECUTABLE failed with exit code: 1 /usr/bin/rm: cannot remove '/rdsdbdata/tmp/.rds-file-list_90266': No such fil
ORA-06512: at "SYS.DBMS_ISCHED", line 242
ORA-06512: at "SYS.DBMS_SCHEDULER", line 566
ORA-06512: at "SYS.RDS_SYS_UTIL", line 1142
ORA-06512: at "SYS.RDS_SYS_UTIL", line 2009
ORA-27369: job of type EXECUTABLE failed with exit code: 1 /usr/bin/find: '/rdsdbdata/tmp/.rds-file-list_90266': No such file or directo
ORA-06512: at "SYS.DBMS_ISCHED", line 242
ORA-06512: at "SYS.DBMS_SCHEDULER", line 566
ORA-06512: at "SYS.RDS_SYS_UTIL", line 330
ORA-06512: at "SYS.RDS_SYS_UTIL", line 1969
ORA-06512: at "RDSADMIN.RDS_FILE_UTIL", line 38
ORA-06512: at "RDSADMIN.RDS_FILE_UTIL", line 3

Accepted Answer

I  had the exact same issue. Through testing, I determined that this error is now thrown from RDSADMIN.RDS_FILE_UTIL.LISTDIR when you create an Oracle RDS instance and do not enable automated backups.  It appears some necessary directories on the filesystem are not created if this option is not enabled, which causes the errors you are seeing.  As a workaround, you can modify your instance and set automated backup retention to 1 day.  Apply the changes immediately.  When they are applied calls to RDSADMIN.RDS_FILE_UTIL.LISTDIR will now work.  You can then modify the instance again and set backup retention to 0 days and the calls will continue to work.  I agree that this is new behavior that I have not seen before, even when not enabling automated backups.  Seems like a bug.

unable to access or list DATA_PUMP_DIR in RDS (Oracle-SE2)

관련 콘텐츠