Tutorial - Connect to Oracle Cloud Infrastructure (OCI)
Published 25 March 2026
Prerequisites:
- Oracle Instant Client installed
- Have a user with permissions to connect to Oracle Cloud instance
- Oracle Wallet
- The
TNS_ADMINenvironment variable pointing to the location of the Oracle Wallet
Note: Currently connecting to OCI using wallet only works on Windows with the Oracle Instant Client installed.
From the Flyway Desktop connection dialog:
- Set the username - Enter just a space e.g. " ", since a username is required in the UI however you will be using the credentials via the Oracle wallet
- Leave the password blank
- Enter the JDBC URL, use one of the TNS name alias provided by OCI e.g. `jdbc:oracle:thin:@<TNS_ALIAS>`
Add the following environment configuration to your toml configuration file (with appropriate environment id):
[environments.target1] url = "jdbc:oracle:thin:@mydatabase_high" user = " "
Adjust the JDBC URL according to your needs. The `@mydatabase_high` needs to the same connection string associated to the connecting user in the Oracle Wallet.
