Unable to deploy changes with sqlplus

Applies to

• Liquibase Enterprise (Datical DB)

Conditions

• Oracle database
• Use of native executor sqlplus

Issue Summary

When attempting a deployment, changes that use the native executor sqlplus fail with no additional details. Other changes that don't use sqlplus are successful, and there are no issues with connecting to the database.

Error Message

Exception: Migration failed for change set Changelog/changelog.xml::20250813113059610_test_space::Amy Smith:
     Reason: liquibase.exception.UnexpectedLiquibaseException: Error executing command: C:\Users\AmySmith\LiquibaseDesktop\instantclient\sqlplus.exe -L liquibase_user/*****@***oracledb.liquibase.net:1521/HMH_REF4 @C:\Users\AmySmith\AppData\Local\Temp\liquibase-sqlplus-14768581295125582002.sql returned a code of 1'

Root Cause

This issue is usually caused by a trailing space at the end of the password. The JDBC driver trims this extra space so that the database connection will be successful, and any changes that do not use sqlplus are deployed without issue, but the changes deployed using sqlplus fail due to the trailing space being included.

Resolution

Remove any trailing spaces from the password where stored. Alternatively, use JDBC only if sqlplus is not required.

Related Article(s)

• SQLPlus Fails with ORA-01017 When Using runWith: sqlplus Despite Successful JDBC Connection