"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 FEBRUARY 08, 2017

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

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: Connected
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
Command: LIST
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.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms