Verify that EC2 can access Oracle listener:
[kaau@tcacaueslapp003 ~]$ nc -zv kaau-ue1-sbx1-demo-rds-ora-ins-int-01.cpuybd8mdajb.us-east-1.rds.amazonaws.com 1521
Ncat: Version 7.92 ( https://nmap.org/ncat )
Ncat: Connected to 10.160.241.46:1521.
Ncat: 0 bytes sent, 0 bytes received in 0.02 seconds.
Oracle client installation (via Ansible sre_oracle_build):
#
# pre-requistite for Oracle client installation (via Ansible sre_oracle_build):
#
[kaau@tcacaueslapp003 ~]$ sudo su -
Last login: Wed Aug 12 09:06:42 EDT 2026
[root@tcacaueslapp003 ~]# groupadd oinstall
[root@tcacaueslapp003 ~]# useradd --gid oinstall --home-dir /home/oracle --create-home --shell /usr/bin/bash oracle
[root@tcacaueslapp003 ~]# id -a oracle
uid=56490(oracle) gid=56491(oinstall) groups=56491(oinstall)
[root@tcacaueslapp003 ~]# dnf install --assumeyes bc binutils compat-openssl11 elfutils-libelf fontconfig
[root@tcacaueslapp003 ~]# dnf install --assumeyes glibc glibc-devel ksh libaio libasan liblsan libX11
[root@tcacaueslapp003 ~]# dnf install --assumeyes libXau libXi libXrender libXtst libxcrypt-compat libgcc
[root@tcacaueslapp003 ~]# dnf install --assumeyes libibverbs libnsl librdmacm libstdc++ libxcb libvirt-libs
[root@tcacaueslapp003 ~]# dnf install --assumeyes make policycoreutils policycoreutils-python-utils smartmontools sysstat
[root@tcacaueslapp003 ~]# mkdir /opt/apps/downloads /opt/apps/oracle /opt/apps/oraInventory
[root@tcacaueslapp003 ~]# chown -R oracle:oinstall /opt/apps/downloads /opt/apps/oracle /opt/apps/oraInventory
(.....kickstart NACBSRE_sre_client_app_86039/oracle_client.yml)
#
# working with Oracle 19c RDS:
#
[oracle@tcacaueslapp003 ~]$ whoami
oracle
[oracle@tcacaueslapp003 ~]$ ls -l /opt/apps
drwx------. 2 oracle oinstall 6 Aug 12 11:09 downloads
drwx------. 6 oracle oinstall 71 Aug 12 11:09 oracle
drwxrwx---. 4 oracle oinstall 78 Aug 12 11:10 oraInventory
[oracle@tcacaueslapp003 ~]$ cat ${HOME}/.bash_profile
[[blue:# .bash_profile]]
[[blue:]]
[[blue:# Get the aliases and functions]]
[[blue:if [ -f ~/.bashrc ]; then]]
[[blue: . ~/.bashrc]]
[[blue:fi]]
[[blue:]]
[[blue:# User specific environment and startup programs]]
[[blue:export LIQUIBASE_HOME=/opt/liquibase]]
[[blue:export ORACLE_HOME=/opt/apps/oracle/product/19.0.0/client_1]]
[[blue:export LD_LIBRARY_PATH=${ORACLE_HOME}/lib]]
[[blue:export PATH=${PATH}:${ORACLE_HOME}/bin]]
[oracle@tcacaueslapp003 ~]$ source ${HOME}/.bash_profile
[oracle@tcacaueslapp003 ~]$ which sqlplus
/opt/apps/oracle/product/19.0.0/client_1/bin/sqlplus
[oracle@tcacaueslapp003 ~]$ sqlplus -version
SQL*Plus: Release 19.0.0.0.0 - Production
Version 19.31.0.0.0
[oracle@tcacaueslapp003 ~]$ sqlplus "dbadmin/passw0rd@kaau-ue1-sbx1-demo-rds-ora-ins-int-01.cpuybd8mdajb.us-east-1.rds.amazonaws.com:1521/ORADEMO"
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 12 16:47:31 2026
Version 19.31.0.0.0
Copyright (c) 1982, 2026, Oracle. All rights reserved.
Last Successful login time: Wed Aug 12 2026 12:47:39 -04:00
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.27.0.0.0
SQL> [[yellow:exit]]
Disconnected from Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.27.0.0.0
Java installation:
[root@tcacaueslapp003 ~]# dnf list available | grep openjdk
::
::
::
java-25-openjdk.x86_64 1:25.0.4.0.7-1.1.el9 rhel-9-for-x86_64-appstream-rpms
java-25-openjdk-crypto-adapter.x86_64 1:25.0.4.0.7-1.1.el9 rhel-9-for-x86_64-appstream-rpms
java-25-openjdk-demo.x86_64 1:25.0.4.0.7-1.1.el9 rhel-9-for-x86_64-appstream-rpms
java-25-openjdk-devel.x86_64 1:25.0.4.0.7-1.1.el9 rhel-9-for-x86_64-appstream-rpms
java-25-openjdk-headless.x86_64 1:25.0.4.0.7-1.1.el9 rhel-9-for-x86_64-appstream-rpms
java-25-openjdk-javadoc.x86_64 1:25.0.4.0.7-1.1.el9 rhel-9-for-x86_64-appstream-rpms
java-25-openjdk-javadoc-zip.x86_64 1:25.0.4.0.7-1.1.el9 rhel-9-for-x86_64-appstream-rpms
java-25-openjdk-jmods.x86_64 1:25.0.4.0.7-1.1.el9 rhel-9-for-x86_64-appstream-rpms
java-25-openjdk-src.x86_64 1:25.0.4.0.7-1.1.el9 rhel-9-for-x86_64-appstream-rpms
java-25-openjdk-static-libs.x86_64 1:25.0.4.0.7-1.1.el9 rhel-9-for-x86_64-appstream-rpms
::
::
::
[root@tcacaueslapp003 ~]# dnf install -y java-25-openjdk.x86_64
Updating Subscription Management repositories.
Red Hat Satellite Client 6 for RHEL 9 x86_64 (RPMs) 119 kB/s | 3.8 kB 00:00
Red Hat Enterprise Linux 9 for x86_64 - BaseOS (RPMs) 73 kB/s | 4.1 kB 00:00
Red Hat Enterprise Linux 9 for x86_64 - AppStream (RPMs) 60 kB/s | 4.5 kB 00:00
Dependencies resolved.
========================================================================================================================
Package Arch Version Repository Size
========================================================================================================================
Installing:
java-25-openjdk x86_64 1:25.0.4.0.7-1.1.el9 rhel-9-for-x86_64-appstream-rpms 391 k
Installing dependencies:
ModemManager-glib x86_64 1.20.2-1.el9 rhel-9-for-x86_64-baseos-rpms 337 k
adwaita-cursor-theme noarch 40.1.1-3.el9 rhel-9-for-x86_64-appstream-rpms 655 k
::
::
::
xdg-desktop-portal x86_64 1.12.6-1.el9 rhel-9-for-x86_64-appstream-rpms 389 k
xkeyboard-config noarch 2.33-2.el9 rhel-9-for-x86_64-appstream-rpms 866 k
xorg-x11-fonts-Type1 noarch 7.5-33.el9 rhel-9-for-x86_64-appstream-rpms 509 k
Installing weak dependencies:
dconf x86_64 0.40.0-6.el9 rhel-9-for-x86_64-appstream-rpms 117 k
exiv2 x86_64 0.27.5-2.el9 rhel-9-for-x86_64-appstream-rpms 984 k
::
::
tracker-miners x86_64 3.1.2-4.el9_3 rhel-9-for-x86_64-appstream-rpms 942 k
xdg-desktop-portal-gtk x86_64 1.12.0-3.el9 rhel-9-for-x86_64-appstream-rpms 139 k
Transaction Summary
========================================================================================================================
Total download size: 124 M
Installed size: 470 M
Downloading Packages:
(1/125): ModemManager-glib-1.20.2-1.el9.x86_64.rpm 1.5 MB/s | 337 kB 00:00
(2/125): lksctp-tools-1.0.19-3.el9_4.x86_64.rpm 460 kB/s | 104 kB 00:00
(3/125): fuse-common-3.10.2-9.el9.x86_64.rpm 37 kB/s | 8.5 kB 00:00
::
::
::
(123/125): tzdata-java-2026c-1.el9_8.noarch.rpm 1.7 MB/s | 230 kB 00:00
(124/125): p11-kit-server-0.26.4-1.el9_8.x86_64.rpm 53 kB/s | 28 kB 00:00
(125/125): java-25-openjdk-headless-25.0.4.0.7-1.1.el9.x86_64.rpm 19 MB/s | 61 MB 00:03
------------------------------------------------------------------------------------------------------------------------
Total 12 MB/s | 124 MB 00:10
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Running scriptlet: java-25-openjdk-headless-1:25.0.4.0.7-1.1.el9.x86_64 1/1
Preparing : 1/1
Installing : alsa-lib-1.2.15.3-1.el9.x86_64 1/125
Installing : libogg-2:1.3.4-6.el9.x86_64 2/125
Installing : libvorbis-1:1.3.7-5.el9.x86_64 3/125
::
::
::
Created symlink /etc/systemd/user/pipewire-session-manager.service → /usr/lib/systemd/user/wireplumber.service.
Created symlink /etc/systemd/user/pipewire.service.wants/wireplumber.service → /usr/lib/systemd/user/wireplumber.service.
Running scriptlet: java-25-openjdk-1:25.0.4.0.7-1.1.el9.x86_64 125/125
Running scriptlet: pipewire-pulseaudio-1.4.11-1.el9_8.x86_64 125/125
Creating group 'pipewire' with GID 984.
Creating user 'pipewire' (PipeWire System Daemon) with UID 984 and GID 984.
Verifying : ModemManager-glib-1.20.2-1.el9.x86_64 1/125
Verifying : lksctp-tools-1.0.19-3.el9_4.x86_64 2/125
Verifying : fuse-common-3.10.2-9.el9.x86_64 3/125
::
::
::
Verifying : p11-kit-server-0.26.4-1.el9_8.x86_64 124/125
Verifying : tzdata-java-2026c-1.el9_8.noarch 125/125
Installed products updated.
Installed:
ModemManager-glib-1.20.2-1.el9.x86_64
adwaita-cursor-theme-40.1.1-3.el9.noarch
adwaita-icon-theme-40.1.1-3.el9.noarch
::
::
::
xdg-desktop-portal-gtk-1.12.0-3.el9.x86_64
xkeyboard-config-2.33-2.el9.noarch
xorg-x11-fonts-Type1-7.5-33.el9.noarch
Complete!
Liquibase installation:
[root@tcacaueslapp003 ~]# cd ${HOME}
[root@tcacaueslapp003 ~]# export HTTPS_PROXY=http://nsawsqsse.bmogc.net:8080
[root@tcacaueslapp003 ~]# curl --insecure --location --remote-name https://github.com/liquibase/liquibase/releases/download/v5.0.3/liquibase-5.0.3.tar.gz
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0
100 8505k 100 8505k 0 0 1575k 0 0:00:05 0:00:05 --:--:-- 2096k
[root@tcacaueslapp003 ~]# ls -la liquibase-5.0.3.tar.gz
-rw-------. 1 root root 8709679 Aug 12 11:19 liquibase-5.0.3.tar.gz
#
# untar liquibase binary in /opt/liquibase:
#
[root@tcacaueslapp003 ~]# mkdir /opt/liquibase
[root@tcacaueslapp003 ~]# tar --directory=/opt/liquibase -zxvf liquibase-5.0.3.tar.gz
ABOUT.txt
GETTING_STARTED.txt
LICENSE.txt
README.txt
UNINSTALL.txt
changelog.txt
examples/
examples/sql/
examples/sql/blank-changelog.sql
examples/sql/liquibase.properties
examples/sql/example-changelog.sql
examples/sql/example-changeset-sql.txt
examples/xml/
examples/xml/liquibase.properties
examples/xml/example-changeset-xml.txt
examples/xml/blank-changelog.xml
examples/xml/example-changelog.xml
examples/start-h2.bat
examples/json/
examples/json/example-changeset-json.txt
examples/json/example-changelog.json
examples/json/liquibase.properties
examples/json/blank-changelog.json
examples/yaml/
examples/yaml/liquibase.properties
examples/yaml/example-changeset-yaml.txt
examples/yaml/example-changelog.yaml
examples/yaml/blank-changelog.yaml
examples/start-h2
internal/
internal/lib/
internal/lib/commons-lang3.jar
internal/lib/opencsv.jar
internal/lib/liquibase-core.jar
internal/lib/picocli.jar
internal/lib/h2.jar
internal/lib/snakeyaml.jar
internal/lib/commons-collections4.jar
internal/lib/commons-io.jar
internal/lib/commons-text.jar
lib/
lib/README.txt
lib/liquibase_autocomplete_mac.bash
lib/liquibase_autocomplete.zsh
lib/liquibase_autocomplete.sh
licenses/
licenses/oss/
licenses/oss/gpl-2.0-classpath-exception.txt
licenses/oss/usage-data.txt
licenses/oss/README.txt
licenses/oss/apache-2.0.txt
licenses/oss/epl-2.0.txt
licenses/oss/FSL-1.1-ALv2.txt
liquibase
liquibase.bat
[root@tcacaueslapp003 ~]# ls -l /opt/liquibase
-rw-r--r--. 1 1001 1001 50 May 14 12:12 ABOUT.txt
-rw-r--r--. 1 1001 1001 466775 May 14 12:12 changelog.txt
drwxr-xr-x. 6 1001 1001 88 May 14 12:12 examples
-rw-r--r--. 1 1001 1001 11088 May 14 12:12 GETTING_STARTED.txt
drwxr-xr-x. 3 1001 1001 17 May 14 12:12 internal
drwxr-xr-x. 2 1001 1001 130 May 14 12:12 lib
drwxr-xr-x. 3 1001 1001 17 May 13 15:11 licenses
-rw-r--r--. 1 1001 1001 3688 May 14 12:12 LICENSE.txt
-rwxr-xr-x. 1 1001 1001 2655 May 13 15:11 liquibase
-rw-r--r--. 1 1001 1001 3247 May 13 15:11 liquibase.bat
-rw-r--r--. 1 1001 1001 3566 May 14 12:12 README.txt
-rw-r--r--. 1 1001 1001 738 May 14 12:12 UNINSTALL.txt
[root@tcacaueslapp003 ~]# chown -R root:root /opt/liquibase
[root@tcacaueslapp003 ~]# chmod 755 /opt/liquibase
#
# download Oracle JDBC Driver:
# refers: https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html
#
[root@tcacaueslapp003 ~]# ls -ld /opt/liquibase/lib
drwxr-xr-x. 2 root root 149 Aug 12 12:29 /opt/liquibase/lib
[root@tcacaueslapp003 ~]# ls -l /opt/liquibase/lib
-rwxr-xr-x. 1 root root 2846 May 13 15:11 liquibase_autocomplete_mac.bash
-rw-r--r--. 1 root root 3690 May 13 15:11 liquibase_autocomplete.sh
-rw-r--r--. 1 root root 2387 May 13 15:11 liquibase_autocomplete.zsh
-rw-r--r--. 1 root root 430 May 14 12:12 README.txt
[root@tcacaueslapp003 ~]# export HTTPS_PROXY=http://nsawsqsse.bmogc.net:8080
[root@tcacaueslapp003 ~]# curl --insecure --location https://download.oracle.com/otn-pub/otn_software/jdbc/23263/ojdbc17.jar \
[[yellow:--output /opt/liquibase/lib/ojdbc17.jar]]
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0
100 447 100 447 0 0 1780 0 --:--:-- --:--:-- --:--:-- 1780
100 7598k 100 7598k 0 0 14.4M 0 --:--:-- --:--:-- --:--:-- 14.4M
[root@tcacaueslapp003 ~]# ls -l /opt/liquibase/lib/ojdbc17.jar
-rw-------. 1 root root 7781120 Aug 12 19:19 /opt/liquibase/lib/ojdbc17.jar
[root@tcacaueslapp003 ~]# chmod 644 /opt/liquibase/lib/ojdbc17.jar
[root@tcacaueslapp003 ~]# ls -l /opt/liquibase/lib/ojdbc17.jar
-rw-r--r--. 1 root root 7781120 Aug 12 19:19 /opt/liquibase/lib/ojdbc17.jar
[root@tcacaueslapp003 ~]# exit
Working with liquibase:
[kaau@tcacaueslapp003 ~]$ vi ${HOME}/.bash_profile
::
::
[kaau@tcacaueslapp003 ~]$ cat ${HOME}/.bash_profile
[[blue:## .bash_profile]]
[[blue:]]
[[blue:## Get the aliases and functions]]
[[blue:if [ -f ~/.bashrc ]; then]]
[[blue: . ~/.bashrc]]
[[blue:fi]]
[[blue:]]
[[blue:## User specific environment and startup programs]]
[[blue:export LIQUIBASE_SHOW_BANNER=false]]
[[blue:export PATH=${PATH}:/opt/liquibase]] ---this
[kaau@tcacaueslapp003 ~]$ source ${HOME}/.bash_profile
[kaau@tcacaueslapp003 ~]$ which liquibase
/opt/liquibase/liquibase
[kaau@tcacaueslapp003 ~]$ liquibase --version
Starting Liquibase at 19:09:11 using Java 25.0.4 (version 5.0.3 #10665 built at 2026-05-13 17:55+0000)
Liquibase Home: /opt/liquibase
Java Home /usr/lib/jvm/java-25-openjdk (Version 25.0.4)
Libraries:
- internal/lib/commons-collections4.jar: Apache Commons Collections 4.5.0 By The Apache Software Foundation
- internal/lib/commons-io.jar: Apache Commons IO 2.22.0 By The Apache Software Foundation
- internal/lib/commons-lang3.jar: Apache Commons Lang 3.20.0 By The Apache Software Foundation
- internal/lib/commons-text.jar: Apache Commons Text 1.15.0 By The Apache Software Foundation
- internal/lib/h2.jar: H2 Database Engine 2.4.240 By H2 Group
- internal/lib/opencsv.jar: opencsv 5.12.0
- internal/lib/picocli.jar: picocli 4.7.7 By Remko Popma
- internal/lib/snakeyaml.jar: SnakeYAML 2.6.0
- lib/ojdbc17.jar: JDBC 23.26.3.0.0 By Oracle Corporation
Liquibase Version: 5.0.3
#
# ${HOME}/liquibase:
#
[kaau@tcacaueslapp003 ~]$ mkdir ${HOME}/liquibase
[kaau@tcacaueslapp003 ~]$ ls -ld ${HOME}/liquibase
drwx------. 2 kaau kaau 6 Aug 12 19:26 /home/kaau/liquibase
[kaau@tcacaueslapp003 ~]$ cd liquibase
[kaau@tcacaueslapp003 ~]$ vi liquibase.properties
::
::
[kaau@tcacaueslapp003 liquibase]$ cat liquibase.properties
[[blue:## Oracle JDBC driver]]
[[blue:driver=oracle.jdbc.OracleDriver]]
[[blue:]]
[[blue:## RDS Oracle connection]]
[[blue:url=jdbc:oracle:thin:@//kaau-ue1-sbx1-demo-rds-ora-ins-int-01.cpuybd8mdajb.us-east-1.rds.amazonaws.com:1521/ORADEMO]]
[[blue:]]
[[blue:## User for Liquibase changes]]
[[blue:username=dbadmin]]
[[blue:password=passw0rd]]
[[blue:]]
[[blue:## Changelog file]]
[[blue:changeLogFile=changelog.xml]]
[[blue:]]
[[blue:## Logging]]
[[blue:logLevel=info]]
[kaau@tcacaueslapp003 liquibase]$ vi changelog.xml
::
::
[kaau@tcacaueslapp003 liquibase]$ cat changelog.xml
[[blue:<?xml version="1.0" encoding="UTF-8"?>]]
[[blue:<databaseChangeLog]]
[[blue: xmlns="http://www.liquibase.org/xml/ns/dbchangelog"]]
[[blue: xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"]]
[[blue: xsi:schemaLocation="]]
[[blue: http://www.liquibase.org/xml/ns/dbchangelog]]
[[blue: http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd">]]
[[blue:]]
[[blue: <changeSet id="1" author="kaau">]]
[[blue: <createTable tableName="TEST_TABLE">]]
[[blue: <column name="ID" type="NUMBER">]]
[[blue: <constraints primaryKey="true"/>]]
[[blue: </column>]]
[[blue: <column name="NAME" type="VARCHAR2(100)"/>]]
[[blue: </createTable>]]
[[blue: </changeSet>]]
[[blue:]]
[[blue:</databaseChangeLog>]]
[oracle@tcacaueslapp003 liquibase]$ liquibase status
Starting Liquibase at 12:34:58 using Java 25.0.4 (version 5.0.3 #10665 built at 2026-05-13 17:55+0000)
Liquibase Version: 5.0.3
[2026-08-12 12:34:58] INFO [liquibase.ui] Liquibase Version: 5.0.3
[2026-08-12 12:34:58] INFO [liquibase.ui]
[2026-08-12 12:34:58] INFO [liquibase.integration] Starting command execution.
[2026-08-12 12:35:06] INFO [liquibase.changelog] Creating database changelog table with name: DBADMIN.DATABASECHANGELOG
[2026-08-12 12:35:06] INFO [liquibase.snapshot] Creating snapshot
[2026-08-12 12:35:07] INFO [liquibase.changelog] Reading from DBADMIN.DATABASECHANGELOG
1 changeset has not been applied to DBADMIN@jdbc:oracle:thin:@//kaau-ue1-sbx1-demo-rds-ora-ins-int-01.cpuybd8mdajb.us-east-1.rds.amazonaws.com:1521/ORADEMO
changelog.xml::1::kaau
[2026-08-12 12:35:07] INFO [liquibase.command] Command execution complete
Liquibase command 'status' was executed successfully.
[2026-08-12 12:35:07] INFO [liquibase.ui] Liquibase command 'status' was executed successfully.
[oracle@tcacaueslapp003 liquibase]$ liquibase update
Starting Liquibase at 12:36:26 using Java 25.0.4 (version 5.0.3 #10665 built at 2026-05-13 17:55+0000)
Liquibase Version: 5.0.3
[2026-08-12 12:36:26] INFO [liquibase.ui] Liquibase Version: 5.0.3
[2026-08-12 12:36:26] INFO [liquibase.ui]
[2026-08-12 12:36:26] INFO [liquibase.integration] Starting command execution.
[2026-08-12 12:36:31] INFO [liquibase.changelog] Reading from DBADMIN.DATABASECHANGELOG
[2026-08-12 12:36:31] INFO [liquibase.lockservice] Successfully acquired change log lock
[2026-08-12 12:36:31] INFO [liquibase.command] Using deploymentId: 6552585306
[2026-08-12 12:36:31] INFO [liquibase.changelog] Reading from DBADMIN.DATABASECHANGELOG
Running Changeset: changelog.xml::1::kaau
[2026-08-12 12:36:31] INFO [liquibase.ui] Running Changeset: changelog.xml::1::kaau
[2026-08-12 12:36:31] INFO [liquibase.changelog] Table TEST_TABLE created
[2026-08-12 12:36:31] INFO [liquibase.changelog] ChangeSet changelog.xml::1::kaau ran successfully in 26ms
UPDATE SUMMARY
Run: 1
Previously run: 0
Filtered out: 0
-------------------------------
Total change sets: 1
[2026-08-12 12:36:31] INFO [liquibase.util] UPDATE SUMMARY
[2026-08-12 12:36:31] INFO [liquibase.util] Run: 1
[2026-08-12 12:36:31] INFO [liquibase.util] Previously run: 0
[2026-08-12 12:36:31] INFO [liquibase.util] Filtered out: 0
[2026-08-12 12:36:31] INFO [liquibase.util] -------------------------------
[2026-08-12 12:36:31] INFO [liquibase.util] Total change sets: 1
[2026-08-12 12:36:31] INFO [liquibase.util] Update summary generated
[2026-08-12 12:36:31] INFO [liquibase.command] Update command completed successfully.
Liquibase: Update has been successful. Rows affected: 0
[2026-08-12 12:36:31] INFO [liquibase.ui] Liquibase: Update has been successful. Rows affected: 0
[2026-08-12 12:36:31] INFO [liquibase.lockservice] Successfully released change log lock
[2026-08-12 12:36:31] INFO [liquibase.command] Command execution complete
Liquibase command 'update' was executed successfully.
[2026-08-12 12:36:31] INFO [liquibase.ui] Liquibase command 'update' was executed successfully.
Examine the Oracle database:
[kaau@tcacaueslapp003 liquibase]$ sudo su - oracle
Last login: Wed Aug 12 19:24:18 EDT 2026 on pts/2
[oracle@tcacaueslapp003 ~]$ sqlplus "dbadmin/passw0rd@kaau-ue1-sbx1-demo-rds-ora-ins-int-01.cpuybd8mdajb.us-east-1.rds.amazonaws.com:1521/ORADEMO"
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 12 12:42:31 2026
Version 19.31.0.0.0
Copyright (c) 1982, 2026, Oracle. All rights reserved.
Last Successful login time: Wed Aug 12 2026 12:36:29 -04:00
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.27.0.0.0
SQL> [[yellow:SELECT table_name FROM user_tables WHERE table_name LIKE 'DATABASECHANGELOG%';]]
TABLE_NAME
--------------------------------------------------------------------------------
DATABASECHANGELOG
DATABASECHANGELOGLOCK
SQL> [[yellow:SELECT table_name FROM user_tables WHERE table_name = 'TEST_TABLE';]]
TABLE_NAME
--------------------------------------------------------------------------------
TEST_TABLE
SQL> [[yellow:DESCRIBE TEST_TABLE;]]
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
NAME VARCHAR2(100)
SQL> [[yellow:COLUMN id FORMAT A5;]]
SQL> [[yellow:COLUMN author FORMAT A10;]]
SQL> [[yellow:COLUMN filename FORMAT A20;]]
SQL> [[yellow:COLUMN dateexecuted FORMAT A30;]]
SQL> [[yellow:SELECT id, author, filename, dateexecuted FROM DATABASECHANGELOG;]]
ID AUTHOR FILENAME DATEEXECUTED
----- ---------- -------------------- ------------------------------
1 kaau changelog.xml 12-AUG-26 04.36.31.338481 PM
SQL> [[yellow:COLUMN constraint_name FORMAT A20;]]
SQL> [[yellow:COLUMN constraint_type FORMAT A20;]]
SQL> [[yellow:SELECT constraint_name, constraint_type FROM user_constraints WHERE table_name = 'TEST_TABLE';]]
CONSTRAINT_NAME CONSTRAINT_TYPE
-------------------- --------------------
SYS_C006304 C
PK_TEST_TABLE P
SQL> [[yellow:exit]]
Disconnected from Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.27.0.0.0
[oracle@tcacaueslapp003 ~]$ exit
logout
[kaau@tcacaueslapp003 liquibase]$ liquibase status
Starting Liquibase at 19:45:38 using Java 25.0.4 (version 5.0.3 #10665 built at 2026-05-13 17:55+0000)
[2026-08-12 19:45:38] INFO [liquibase.ui] Starting Liquibase at 19:45:38 using Java 25.0.4 (version 5.0.3 #10665 built at 2026-05-13 17:55+0000)
Liquibase Version: 5.0.3
[2026-08-12 19:45:38] INFO [liquibase.ui] Liquibase Version: 5.0.3
[2026-08-12 19:45:38] INFO [liquibase.ui]
[2026-08-12 19:45:38] INFO [liquibase.integration] Starting command execution.
[2026-08-12 19:45:42] INFO [liquibase.changelog] Reading from DBADMIN.DATABASECHANGELOG
DBADMIN@jdbc:oracle:thin:@//kaau-ue1-sbx1-demo-rds-ora-ins-int-01.cpuybd8mdajb.us-east-1.rds.amazonaws.com:1521/ORADEMO is up to date
[2026-08-12 19:45:42] INFO [liquibase.command] Command execution complete
Liquibase command 'status' was executed successfully.
[2026-08-12 19:45:42] INFO [liquibase.ui] Liquibase command 'status' was executed successfully.