Problems with connection to Oracle 19c ATP database

When I try to connect to Oracle 19c ATP, I get a message: IO-fout: IO Error Received fatal alert: handshake_failure, Authentication lapse 0 ms.

I use Liquibase 4.1.0 on Mac with Oracle jdbc ojdbc8-

Hi @fvl,

Sorry you are having issue, let’s see if we can’t get you going. May I have a little more information?

  • What is the exact command line you are attempting when you get above error?
  • Version of Java being used?
  • Are you able to connect to the database outside of liquibase (ex using sqlplus)?



Hi Ronak,

Thanks for your fast response, I hope you can help me. I already use Liquibase for PostgreSQL and now I try to start with Oracle (in the cloud).

  1. liquibase update
  2. java version “1.8.0_91"
  3. yes, with sqlplus or SQL Developer

Okay, well, I know we can connect to Oracle ATP and have confirmed with my collegue @szandany he was able to do it. He documented the effort here:

If that still doesn’t help, we will need next layer of info, like your file (please redact any credential info).

Hi Ronak,

This is exactly the document I followed, with two exceptions. I don’t know the location of the liquibase.bat file, but is this only for Windows environments? I use Mac and liquibase is in my PATH variable. I also changed the sqlnet.ora file and change the ? in the wallet_location for sqlplus to work WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="/Users/frans/Oracle/network/admin")))

I don’t use the file, but run the below script:

liquibase --driver=oracle.jdbc.OracleDriver