connection with oracle using multiple alias TNS definition

Answered

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:

2 comments
Comment actions Permalink
0
Comment actions Permalink

Thiago We,

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

0

Please sign in to leave a comment.