My Oracle Support Banner

"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 11.2.0.1 to 11.2.0.4 [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.

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

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.