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-19.7.0.0.jar

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)?

Thanks!

Ronak

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 liquibase.properties 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 liquibase.properties file, but run the below script:

liquibase --driver=oracle.jdbc.OracleDriver
–classpath=/Users/frans/jdbc_drivers/ojdbc8-19.7.0.0.jar
–url=jdbc:oracle:thin:@ora18_high?TNS_ADMIN=/Users/frans/Oracle/network/admin
—username=**********
–password=“**********"
–changeLogFile=/Users/frans/Projects/pfs/database/OraChangeLog.xml
–contexts=‘pfs,ing,binck’
–logLevel=error
update