How do I indicate my role (e.g. AS SYSDBA) in Liquibase?

Question

I'm now trying to connect to an Oracle database. And I can only connect by using a specific role (in this case, since I'm connecting as SYS, I will need the role SYSDBA to connect to the database).

If not, it will result in the following error:

Unexpected error running Liquibase: java.sql.SQLException: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

How do I specify that in liquibase?

Answer 1

If using a liquibase.properties file:

url=jdbc:oracle:thin:@localhost:1521:XE
username=sys as sysdba
password=password1234

If using command line parameters:

./liquibase --username='sys as sysdba' --changeLogFile=etc...