Search code examples
linuxoracleplsqloracle11goracle-sqldeveloper

Host key verification failed. Oracle 11g


I am using a stored procedure in Oracle 11g. This stored procedure will copy a document between two servers (database and application) using Executecmdwithreturn (Command); but when I run it I get this error:

Host key verification failed. 

I already generated the key for the database server.

Command := 'scp ' || 'carpetaServidor1 '||' ' || '/carpetaServidor2';

Executecmdwithreturn(Command);

Solution

  • Looking at your code and at the error i "imagine" that the problem it's not in the PL/SQL but in the scp command invoked.

    Please google "scp Host key verification failed".