[ERROR] Error in executing command:Unable to determine the URL for database 'x' with TNS identifier 'x'

Applies to

Liquibase Enterprise (Datical DB)

Conditions

Using a TNS identifier

Issue Summary

When attempting to run a pipeline on a server with an installed Oracle client, the process fails even though the connectivity check is successful. The error message indicates that the URL for the database with a specified TNS identifier cannot be determined.

Error Message

ERROR c.datical.hammer.repl.util.ReplUtil - Error in executing command:Unable to determine the URL for database 'xx' with TNS identifier 'xx'

Potential Root Causes

The issue occurs because the sqlnet.ora file does not specify the NAMES.DIRECTORY_PATH parameter. Without this specification, Oracle Net Service defaults to LDAP, which is not configured correctly for this scenario.

Troubleshooting

Update the sqlnet.ora File:
- Add the following line to your sqlnet.ora file:
```
NAMES.DIRECTORY_PATH= (TNSNAMES)
```
- This ensures that the TNS name configuration is prioritized.
Verify Local Settings:
- Open the "Edit Connection" window in your local Liquibase setup.
- Click on "Test Connection" to confirm the connection is successful after making the change.
Check the TNS_ADMIN Path:
- Confirm that the TNS_ADMIN environment variable points to the correct directory containing the tnsnames.ora file.
- Update the TNS_ADMIN variable if necessary and retest the connection.
Validate Server Configuration:
- Review your pipeline configuration.
- Add a line to the pipeline configuration file to echo the TNS_ADMIN path during runtime:
```
echo "TNS_ADMIN=$TNS_ADMIN"
```
- Verify the TNS_ADMIN path is set correctly when the pipeline runs.