...
If you use TNS names in your dbDef, then you should prepare a TNS name with _eph postfix for the ephemeral copy because we are not able to Liquibase cannot modify TNS files in most cases.
If this is what your dbDefs look like:
...
If you have a dev entry in your TNS file, then you should create an alias for the dev_eph entry which points to the ephemeral copy (admin_sysoper is just an example entry for a connection pointing to ORCLCDB.)
Example tnsnames.ora file:
| Code Block |
|---|
dev =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 172.17.0.3)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bucket_01)
)
)
dev_eph =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 172.17.0.3)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = bucket_01_eph)
)
)
admin_sysoper =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 172.17.0.3)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = ORCLCDB)
)
)
|
| Info |
|---|
Liquibase recommends creating a dbDef definition in the datical.project but not including this dbDef on any Liquibase pipelines/plans. |
...