Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLCLI + Liquibase problems with an update on Always Free 23ai

YuriAPSep 10 2024 — edited Sep 11 2024

Hello

I am trying to do this basic example https://docs.oracle.com/en/database/oracle/sql-developer-command-line/24.1/sqcug/examples-using-liquibase.html#GUID-D4B11199-D4FB-460A-B9C7-71E498B921A8.

Tried: SQLCL 24.2, 24.1, 23.4, grabbing one schema and trying to create a copy of all objects in another schema of the same physical DB (12.1.0.2).

Also tried to run LB UPDATE at Always Free 23ai with 24.1 SQLCLI.

Every time different errors happen, starting from inability to run LB GENERATE-SCHEMA (24.2) to not be able to create most of the objects in the target schema (almost all tables were missed without error messages, although other objects: packages, types were created)

For example, currently trying to run using 24.1 SQLCLI at 23ai Always Free DB

lb update -changelog-file controller.xml

getting multiple errors like

, sda_sqlpp_r_idx1_index.xml::2f034a776da744bab4c00e5ab8c4aa08e93e16fe::(SQL_DATA_ANALYSIS)-Generated
         ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 34
LPX-00245: extra data after end of document
ORA-06512: at "SYS.XMLTYPE", line 272
ORA-06512: at line 96
, sda_sql_plc_idx1_index.xml::4a356355cc0c1240b6e4e954822dffbdbd3eefd9::(SQL_DATA_ANALYSIS)-Generated

I might be doing something fundamentally wrong…

Is there any good manual with step-by-step instruction taking one schema and reproducing it somewhere else?

I can re-run any experiment with debug an logging and present here the results

Comments
Post Details
Added on Sep 10 2024
5 comments
501 views