First attempt to open connection failed about as_sftp HOT 5 CLOSED

I would first double check the ACL (port 22 open?). If the ACL is correct I would check if the SFTP server can reached from the database server, no firewall in between? Else I don't have a clue :)

from as_sftp.

Yes, the ACL is * with no port limits, and the privileges are resolve and connect. I have a commercial Java-based SFTP installed for the same Oracle account and it connects just fine.

from as_sftp.

Does that Java-based SFTP client run on the database server or on your client machine?

from as_sftp.

In the database. It is OraSFTP. I installed as_sftp in the same schema. Hmm. This could be an AUTHID issue. I need to run another test.

from as_sftp.

I have the Java code, its package wrapper and as_sftp compiled in schema "A". The ACL/ACEs are granted to schema "B", where the code is being executed from. I think what I'm seeing is that the Java permissions work separately/differently. When I moved as_sftp to schema "B", I was able to get the connection.

from as_sftp.