[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

1. 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.

2. 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.

3. 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.

4. 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.

Related Article(s)

• TNSNAMES Connection to an Oracle Database
• Testing Oracle Connections