Can the liquibase version included in SQLcl run update as a proxy user. Our developers each have their own PDB for isolated development and they connect as a proxy to our main schema. I am able to run generate-schema as the proxy user but when trying to run update on a PDB I get
https://docs.oracle.com/error-help/db/ora-01918/01918. 00000 - "user '%s' does not exist"
*Cause: The specified user did not exist in the system.
*Action: Verify the user name is correct by querying ALL_USERS view.
*Params: 1) Name
at oracle.dbtools.raptor.liquibase.executor.jvm.SqlClExecutor.execute(SqlClExecutor.java:210)
at oracle.dbtools.raptor.liquibase.executor.jvm.SqlClExecutor.execute(SqlClExecutor.java:321)
at oracle.dbtools.raptor.liquibase.executor.jvm.SqlClExecutor.execute(SqlClExecutor.java:300)
at oracle.dbtools.raptor.liquibase.actionlogging.ActionLogTableManager.createUpdateLogTable(ActionLogTableManager.java:413)
at oracle.dbtools.raptor.liquibase.actionlogging.ActionLogTableManager.<init>(ActionLogTableManager.java:253)
at oracle.dbtools.raptor.liquibase.core.CommandGenerator.updateCommand(CommandGenerator.java:380)
at oracle.dbtools.raptor.scriptrunner.commands.liquibase.LbCommand.handleEvent(LbCommand.java:330)
at oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:448)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.lambda$run$0(ScriptRunner.java:236)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext.runWithStoredContext(ScriptRunnerContext.java:833)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:119)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:364)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:245)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:1223)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runSqlcl(SqlCli.java:1401)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:370)
DEBUG:
The error is happening when trying to create the DATABASECHANGELOG_ACTIONS table in the main schema.
liquibase.exception.DatabaseException: Error starting at line : 1 in command -
CREATE TABLE "main_schema"."DATABASECHANGELOG_ACTIONS"
( "ID" VARCHAR2(255) NOT NULL ENABLE,
"SEQUENCE" NUMBER NOT NULL ENABLE,
"SQL" CLOB,
"SXML" CLOB,
"AUTHOR" VARCHAR2(255),
"FILENAME" VARCHAR2(255),
"DEPLOYMENT_ID" VARCHAR2(10),
"STATUS" VARCHAR2(20)
)
-------Provided Arguments-------
PARAM REQUIRED CHANGELOG-FILE controller.xml
PARAM CONTEXTS null
PARAM LABELS null
PARAM OVERRIDE-APP-ALIAS null
PARAM OVERRIDE-APP-ID null
PARAM OVERRIDE-APP-SCHEMA null
PARAM OVERRIDE-APP-WORKSPACE null
PARAM DATABASE-CHANGELOG-TABLE-NAME DATABASECHANGELOG
PARAM DEFAULTS-FILE null
PARAM SEARCH-PATH null
PARAM SECURE-PARSING true
PARAM LOG false
PARAM DEBUG true
PARAM LIQUIBASE-SCHEMA-NAME null
PARAM LIQUIBASE-TABLESPACE-NAME null
PARAM OUTPUT-DEFAULT-SCHEMA false
PARAM DEFAULT-SCHEMA-NAME null
PARAM SHOW-SUMMARY SUMMARY
---------------------
--------Command Arguments----------
HIDDEN changeExecListener oracle.dbtools.raptor.liquibase.changelog.visitor.OracleChangeExecListener@267eebcb
PARAM changeExecListenerClass null
PARAM changeExecListenerPropertiesFilenull
PARAM REQUIRED changelogFile controller.xml
HIDDEN changelogParameters liquibase.changelog.ChangeLogParameters@8e89fc3
PARAM contextFilter null
HIDDEN database main_schema @ jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.21.35.159)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = wlldev.qdb.ashqavcn.oraclevcn.com)) ) (Default Schema: MAIN_SCHEMA)
HIDDEN databaseChangelog null
PARAM defaultCatalogName null
PARAM defaultSchemaName null
PARAM driver null
PARAM driverPropertiesFile null
PARAM labelFilter null
PARAM password null
PARAM showSummary SUMMARY
PARAM showSummaryOutput ALL
HIDDEN skipDatabaseStep false
HIDDEN updateNullChecksums false
PARAM REQUIRED url null
PARAM username null
---------------------
/*-------------------------- END DISPLAY ARGUMENTS --------------------------------- */