connection with oracle using multiple alias TNS definition


Datagrip does not connects to database when there is a multiple alias definition for a TNS.

Oracle tnsnames.ora file defines that I can have multiple aliases separated by commas (,) before the TNS string


Example of a multiple alias definition on the tnsnames.ora:

mydb, clientname_mydb=(DESCRIPTION = ..... )

when trying to use a TNS with multiple aliases a "could not resolve the connection identifier" error is raised.


Changing the tnsnames.ora to have just one alias, it allows me to connect:

Comment actions Permalink
Comment actions Permalink

Thiago We,

tnsnames.ora is parsed by driver, not DG. Are you able to connect with this file from sqlplus?


Please sign in to leave a comment.