"Error: Failed to retrieve directory listing" Trying to List Directory From a FTP Connection to the XDB Repository
(Doc ID 1591867.1)
Last updated on JANUARY 21, 2020
Applies to:Oracle Database - Standard Edition - Version 184.108.40.206 to 220.127.116.11 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
Connecting to the XDB repository using an FTP tool, from a client machine works fine, however attempting to list the
current directory content fails and returns the message 'Error: Failed to retrieve directory listing'.
Below is an example of the debug output that can be obtained:
Status: Resolving address of host.domain.be
Status: Connecting to xxx.xxx.xxx.xx:2100...
Status: Connection established, waiting for welcome message...
Response: 220- host.domain.be
Response: Unauthorised use of this FTP server is prohibited and may be subject to civil and criminal prosecution.
Response: 220 host.domain.be FTP Server (Oracle XML DB/Oracle Database) ready.
Command: USER HEPL
Response: 331 pass required for HEPL
Command: PASS ************
Response: 230 HEPL logged in
Status: Server does not support non-ASCII characters.
Status: Retrieving directory listing...
Command: CWD /test
Response: 250 CWD Command successful
Command: TYPE I
Response: 200 Type set to I.
Command: PORT nnn,nnn,nnn,nnn,nnn,nnn
Response: 200 PORT Command successful
Response: 150 BIN Data Connection
Response: 550 LIST error in processing request
Error: Failed to retrieve directory listing
There is a firewall between the client and the server, and it is working perfectly when the ftp connection
is executed directly from the database server.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document