I’m using 4.3.4 Liquibase Pro, trying to run my build scripts as sys (dba) as that is how our scripts are run locally in a docker container. I can connect for status using a command as follows:
Liquibase --changeLogFile=masterchangelog.xml --url="jdbc:oracle:thin:@localhost:1521/orclpdb1" --username='sys as sysdba' --password=pw status
but when the files actually run with the above parameters and
update, they fail with
sqlplus returned a code of 1.
In the debug logs, the ORA error being thrown is:
ERROR: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
I’m using SQL changesets with this header at the top:
--liquibase formatted sql --changeset ***:*** runWith:sqlplus
I’ll add that these commands work when fired against an AWS RDS Oracle database, using a
sys equivalent user since AWS doesn’t allow you to use
Thank you for any suggestions as to what’s going on here.