"Error: Failed to retrieve directory listing" Trying to List Directory From a FTP Connection to the XDB Repository
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Database - Standard Edition - Version 220.127.116.11 to 18.104.22.168 [Release 11.2]
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms